5

I have a flask-sqlalchemy project running on an Azure Web App Service plan using a Linux machine. It is connecting to an Azure SQL DB (SQL Server). Intermittently I am receiving the error below:

sqlalchemy.exc.OperationalError: (pyodbc.OperationalError) ('08S01', '[08S01] [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x68 (104) (SQLExecDirectW)')

This error is being raise from the execution of a select query on the database.

Robert Riley
  • 389
  • 1
  • 7
  • 31
  • 1
    Did you search google for the error? I found https://github.com/mkleehammer/pyodbc/issues/427 – fredrik Oct 08 '21 at 13:16
  • 1
    [mcve] please? What is an Azure DB? MSSQL aka. SQLServer? M(aria|y)SQL? – Ulrich Eckhardt Oct 08 '21 at 13:16
  • 1
    Yes i have googled the error, there is not a solution in that link. – Robert Riley Oct 08 '21 at 13:18
  • It is impossible to tell whether that's a bug in your code or somewhere else with the info you provide. Depending on that, either file a new bug ticket (or update the existing one) or fix your own code, but for a start you need to provide enough instructions how to reproduce it. – Ulrich Eckhardt Oct 08 '21 at 13:25
  • 1
    related: https://stackoverflow.com/q/65329179/2144390 https://github.com/mkleehammer/pyodbc/issues/680 – Gord Thompson Oct 08 '21 at 13:50
  • Any solution to this issue? – Ziur Olpa Jun 29 '22 at 13:55
  • @Gord Thompson these are not helpful links - you're linking to a github issue that doesn't resolve the issue beyond saying "look elsewhere", and another SO post that gives vague answers and just links to the same issue. – riptusk331 Oct 29 '22 at 13:56

0 Answers0