Open Source Development

Power Open Source Development

Explore the open source tools and capabilities for building and deploying modern applications on IBM Power platforms including AIX, IBM i, and Linux.


#Power


#Power


#Servers
#Opensource
 View Only
  • 1.  Install on iserirs pymssql using Yum

    Posted 02/04/25 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
    ------------------------------

    #OpenSourceDevelopment


  • 2.  RE: Install on iserirs pymssql using Yum

    Posted 02/05/25 12:40 PM
    Edited by Jack Woehr 02/05/25 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
    ------------------------------



  • 3.  RE: Install on iserirs pymssql using Yum

    Posted 02/06/25 02:52 AM
    thanks you very much


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



  • 4.  RE: Install on iserirs pymssql using Yum

    Posted 02/06/25 09:26 AM

    Good luck. Let us know if you have problems.



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



  • 5.  RE: Install on iserirs pymssql using Yum

    Posted 03/04/26 10:28 AM

    Good morning, I'm here to bother you again. I installed from ACS the freetds package, not freedts-devel and freetds.odbc. You had told me to use it with pyodbc - could you please give me an example in Python of how I can use it? Thank you.



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