Open Source Development

Open Source Development

Connect, learn, share, and engage with IBM Power.

 View Only

  • 1.  Install on iserirs pymssql using Yum

    Posted Tue February 04, 2025 10:57 AM

    good morning, I have been using python packages on Iseries for a long time. I would like to connect to a sql server database but I didn't understand how to install the pymssql package using yum since via PIP3 is not possible.
    If I understand correctly I have to install freetds-devel but I don't know how to proceed after that.
    I thank in advance anyone who can help me.
    best regards



    ------------------------------
    Antonio Colombo
    ------------------------------


  • 2.  RE: Install on iserirs pymssql using Yum

    Posted Wed February 05, 2025 12:40 PM
    Edited by Jack Woehr Wed February 05, 2025 12:40 PM

    IBM i -> MSSQL use FreeTDS

    yum install freetds

    Then use pyodbc to connect

    ------------------------------
    Jack Woehr
    Senior Consultant
    Seiden Group LLC
    Beulah CO
    3038478442
    ------------------------------

    Original Message


  • 3.  RE: Install on iserirs pymssql using Yum

    Posted Thu February 06, 2025 02:52 AM 
    thanks you very much


    ------------------------------
    Antonio Colombo
    ------------------------------

    Original Message


  • 4.  RE: Install on iserirs pymssql using Yum

    Posted Thu February 06, 2025 09:26 AM

    Good luck. Let us know if you have problems.



    ------------------------------
    Jack Woehr
    Senior Consultant
    Seiden Group LLC
    Beulah CO
    3038478442
    ------------------------------

    Original Message