AIX Open Source

AIX Open Source

Share your experiences and connect with fellow developers to discover how to build and manage open source software for the AIX operating system

 View Only

  • 1.  Connecting from Python 3.9.18 to MS SQL server failure

    Posted Thu March 28, 2024 05:50 PM

    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



    ------------------------------
    Mi Wang
    ------------------------------


  • 2.  RE: Connecting from Python 3.9.18 to MS SQL server failure

    Posted Wed April 03, 2024 08:51 AM

    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.



    ------------------------------
    Ranjit Ranjan
    ------------------------------

    Original Message


  • 3.  RE: Connecting from Python 3.9.18 to MS SQL server failure

    Posted Thu April 04, 2024 06:07 AM

    I don't know what the topic starter means but there are open source ODBC drives for MS SQL like FreeTDS. 



    ------------------------------
    Andrey Klyachkin

    https://www.power-devops.com
    ------------------------------

    Original Message


Related Content