While connecting to sql server using pyodbc lib in jupyterlab of SAP DI getting error

[arti_yadav2]

In SAP Data Intelligence ,while connecting to sql server using pyodbc lib in jupyterlab getting below error:

Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found (0) (SQLDriverConnect)")

whereas tried pymsql instead of pyodbc in jupyterlab and ended up getting below error:

OperationalError: (20010, b'DB-Lib error message 20010, severity 8:\nUnable to allocate sufficient memory (1.6.94.229)\n')

just a clarification here the servers used are all fresh server with no memory issue.

[marcus_schiffer]

Hi,

could you solve this ? I have the same issue....

Regards

Marcus

[jimgiffin]

I bet you have to install the MSSQL drivers for pyodbc to read. I did a quick search and perhaps this stackoverflow reply can guide you https://stackoverflow.com/questions/57436527/jupyter-cant-connect-to-ms-sql-server-with-pyodbc

[arti_yadav2]

Thanks James for your answer however this is with respect to SAP Data Intelligence and in the link its required to give the driver path like below. Any idea how to address it in SAP Data Intelligence.

driver = '/usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so'