mkleehammer/pyodbc

Python ODBC sql error on WSL2 environment

jagathprasanga opened this issue · 7 comments

jagathprasanga commented

To diagnose, we usually need to know the following, including version numbers. On Windows, be
sure to specify 32-bit Python or 64-bit:

  • Python: 3.10.12 64bit
  • pyodbc: 5.0.1
  • OS: Ubuntu 22.04.2 LTS on Windows 11 WSL2
  • DB: MS SQL Server 2019
  • driver:libmsodbcsql-18.3.so.2.1

Cant select more than 53 raws (the number changes with number of columns selected)

The below code hangs at indicated line with this error;
pyodbc.OperationalError: ('08S01', '[08S01] [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x68 (104) (SQLExecDirectW)')

image

But below code runs with out any issue;
image

But I can retrieve all rows without any issue using other SQL Server tools.

v-chojas commented

Why do you have both "ENCRYPT" and "Encrypt" in your connection string?
Could you post an ODBC trace of this error?

Also, please post actual code instead of images --- it's hard to read images.

jagathprasanga commented 
def  sql_test3(self):
    server = 'tcp:hqwin21s.ceb.local\SQLSERVER,1433'
    database = ''
    username = ''
    password = ''
    driver = 'DRIVER={/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.3.so.2.1};'
    connection = pyodbc.connect(driver+ 'SERVER=' + 
                                server + ';DATABASE=' + database + ';UID=' + username + ';PWD=' + 
                                password + ';TrustServerCertificate=yes;Encrypt=no;')

    cursor = connection.cursor()
    cursor.execute("SELECT top 500 areaid, CenterLon, CenterLat  FROM AreaList order by areaid")
    row = cursor.fetchone()
    while row:
        print(row)
        row = cursor.fetchone()
    cursor.close()
    connection.close()
jagathprasanga commented

ENCRYPT/Encrypt issue corrected, but not solved. Anyway, thanks for the reply.

v-chojas commented

I shall ask again. Can you post an ODBC trace?

jagathprasanga commented

Sorry, I dont know how to get it, i tried to add below lines to odbcinst.ini file but it is write protected
Trace=Yes
TraceFile=/home/user/odbclog/odbctrace18.log