Hello,

I have been trying to connect o MS SQL server from Python 3.9.18 using pyodbc package. But by so far no lock. I am wondering if anyone has success experience with connecting to SQL server from Python on AIX?

Our environment: 

Python 3.9.18 on AIX 7.2

pyodbc package: version 5.0.1

unixODBC from AIX Toolbox: version  2.3.9

SQL driver: 'SAS Institute, Inc 7.1 SQL Server Legacy Wire Protocol' and 'SAS Institute, Inc 8.2 SQL Server Wire Protocol'

Thanks

Mi

Hi Wang,

Can you elaborate more on use case ?

Are you trying to connect Microsoft SQL Server from AIX using python Pyodbc package ?

As per https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16&tabs=redhat18-install%2Calpine17-install%2Cdebian8-install%2Credhat7-13-install%2Crhel7-offline  , Microsoft provides ODBC driver for various OS'es and I don't see AIX in list.

So not sure if your use case can be achieved in AIX.

Hello,

I have been trying to connect o MS SQL server from Python 3.9.18 using pyodbc package. But by so far no lock. I am wondering if anyone has success experience with connecting to SQL server from Python on AIX?

Our environment: 

Python 3.9.18 on AIX 7.2

pyodbc package: version 5.0.1

unixODBC from AIX Toolbox: version  2.3.9

SQL driver: 'SAS Institute, Inc 7.1 SQL Server Legacy Wire Protocol' and 'SAS Institute, Inc 8.2 SQL Server Wire Protocol'

Thanks

Mi