Python connect to Informix
Frank asked for outline steps to connect Python to Informix 12.10 on Linux. Replies pointed to several options: IBM's python-ibmdb driver (https://github.com/ibmdb/python-ibmdb), which connects ODBC-style over DRDA — the IBM Data Server Driver package ships with the Informix Client SDK, so you configure a DRDA listener on the server and use one of the supplied drivers; the older informixdb DBAPI module from SourceForge (plus SQLAlchemy's Informix dialect); or using Python's REST framework against the Informix REST listener. Links to the Python wiki and a StackOverflow page were given, but no step-by-step setup or confirmation from Frank appears in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
HI, IDS12.10 , Linux Any outline steps to set up connection between Python and Informix ? Thanks Frank --001a1141d9b6177d4d053670e796
Use the Python driver from IBM ? Connection is very ODBC'ish > HI, > > IDS12.10 , Linux > > Any outline steps to set up connection between Python and Informix ? > > Thanks > Frank > > --001a1141d9b6177d4d053670e796 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com Oninit® is a registered trademark of Oninit LLC Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. What this country needs are more unemployed politicians
Frank: You can use the Python REST framework and connect it to the Informix REST listener (easy to start up). Or, here are a couple of links that discuss how to connect Python to Informix natively: https://wiki.python.org/moin/Informix http://stackoverflow.com/questions/19460560/connect-to-informix-with-pythons-ibm -db Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Jun 29, 2016 at 4:50 PM, FRANK <yunyaoqu@gmail.com> wrote: > HI, > > IDS12.10 , Linux > > Any outline steps to set up connection between Python and Informix ? > > Thanks > Frank > > --001a1141d9b6177d4d053670e796 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --94eb2c05665cf0320a0536710a64
HI, Art and Paul, They were talking about using DRDA connection between Python and Informix . I did not find the detail info about its setup .... Thanks Frank On Wed, Jun 29, 2016 at 5:00 PM, Art Kagel <art.kagel@gmail.com> wrote: > Frank: > > You can use the Python REST framework and connect it to the Informix REST > listener (easy to start up). > > Or, here are a couple of links that discuss how to connect Python to > Informix natively: > > https://wiki.python.org/moin/Informix > > > > http://stackoverflow.com/questions/19460560/connect-to-informix-with-pythons-ibm -db > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Wed, Jun 29, 2016 at 4:50 PM, FRANK <yunyaoqu@gmail.com> wrote: > > > HI, > > > > IDS12.10 , Linux > > > > Any outline steps to set up connection between Python and Informix ? > > > > Thanks > > Frank > > > > --001a1141d9b6177d4d053670e796 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --94eb2c05665cf0320a0536710a64 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1146ecc6b981e40536716b14
https://github.com/ibmdb/python-ibmdb > HI, Art and Paul, > > They were talking about using DRDA connection between Python and > Informix . I did not find the detail info about its setup .... > > Thanks > Frank > > On Wed, Jun 29, 2016 at 5:00 PM, Art Kagel <art.kagel@gmail.com> wrote: > >> Frank: >> >> You can use the Python REST framework and connect it to the Informix >> REST >> listener (easy to start up). >> >> Or, here are a couple of links that discuss how to connect Python to >> Informix natively: >> >> https://wiki.python.org/moin/Informix >> >> >> >> > http://stackoverflow.com/questions/19460560/connect-to-informix-with-pythons-ibm -db >> >> Art >> >> Art S. Kagel, President and Principal Consultant >> ASK Database Management >> www.askdbmgt.com >> >> Blog: http://informix-myview.blogspot.com/ >> >> Disclaimer: Please keep in mind that my own opinions are my own opinions >> and do not reflect on the IIUG, nor any other organization with which I >> am >> associated either explicitly, implicitly, or by inference. Neither do >> those opinions reflect those of other individuals affiliated with any >> entity with which I am affiliated nor those of the entities themselves. >> >> On Wed, Jun 29, 2016 at 4:50 PM, FRANK <yunyaoqu@gmail.com> wrote: >> >> > HI, >> > >> > IDS12.10 , Linux >> > >> > Any outline steps to set up connection between Python and Informix ? >> > >> > Thanks >> > Frank >> > >> > --001a1141d9b6177d4d053670e796 >> > >> > >> > >> > >> >> > ******************************************************************************* >> > Forum Note: Use "Reply" to post a response in the discussion forum. >> > >> > >> >> --94eb2c05665cf0320a0536710a64 >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > --001a1146ecc6b981e40536716b14 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com Oninit® is a registered trademark of Oninit LLC Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. What this country needs are more unemployed politicians
The IBM Data Server Driver package, which is included in IBM Informix Client SDK constains various drivers for the DRDA protocol. DRDA is a formal standard protocol for clients and database server to communicate. It's supported by DB2 and Informix (among others) So, if you configure a DRDA listener for Informix you can use one of the provided drivers. Regards. On Wed, Jun 29, 2016 at 10:39 PM, Paul Watson <paul@oninit.com> wrote: > https://github.com/ibmdb/python-ibmdb > > > HI, Art and Paul, > > > > They were talking about using DRDA connection between Python and > > Informix . I did not find the detail info about its setup .... > > > > Thanks > > Frank > > > > On Wed, Jun 29, 2016 at 5:00 PM, Art Kagel <art.kagel@gmail.com> wrote: > > > >> Frank: > >> > >> You can use the Python REST framework and connect it to the Informix > >> REST > >> listener (easy to start up). > >> > >> Or, here are a couple of links that discuss how to connect Python to > >> Informix natively: > >> > >> https://wiki.python.org/moin/Informix > >> > >> > >> > >> > > > > http://stackoverflow.com/questions/19460560/connect-to-informix-with-pythons-ibm -db > >> > >> Art > >> > >> Art S. Kagel, President and Principal Consultant > >> ASK Database Management > >> www.askdbmgt.com > >> > >> Blog: http://informix-myview.blogspot.com/ > >> > >> Disclaimer: Please keep in mind that my own opinions are my own opinions > >> and do not reflect on the IIUG, nor any other organization with which I > >> am > >> associated either explicitly, implicitly, or by inference. Neither do > >> those opinions reflect those of other individuals affiliated with any > >> entity with which I am affiliated nor those of the entities themselves. > >> > >> On Wed, Jun 29, 2016 at 4:50 PM, FRANK <yunyaoqu@gmail.com> wrote: > >> > >> > HI, > >> > > >> > IDS12.10 , Linux > >> > > >> > Any outline steps to set up connection between Python and Informix ? > >> > > >> > Thanks > >> > Frank > >> > > >> > --001a1141d9b6177d4d053670e796 > >> > > >> > > >> > > >> > > >> > >> > > > > ******************************************************************************* > >> > Forum Note: Use "Reply" to post a response in the discussion forum. > >> > > >> > > >> > >> --94eb2c05665cf0320a0536710a64 > >> > >> > >> > >> > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > > > > --001a1146ecc6b981e40536716b14 > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > -- > Paul Watson > Tel: +1 913-674-0360 > Mob: +1 913-387-7529 > Web: www.oninit.com > > Oninit® is a registered trademark of Oninit LLC > > Failure is not as frightening as regret. > If you want to improve, be content to be thought foolish and stupid. > What this country needs are more unemployed politicians > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001a11405dcc4e7f0c0536740058
On Wed, 2016-06-29 at 16:50 -0400, FRANK wrote: > HI, > IDS12.10 , Linux > Any outline steps to set up connection between Python and Informix ? The informixdb <https://sourceforge.net/projects/informixdb/>; DBAPI module. DBAPI is the standard for Python database connectivity. The dialect for Informix in SQLAlchemy also works fairly well - which uses the underlying DBAPI module. -- Meetings Coordinator, Michigan Association of Railroad Passengers 537 Shirley St NE Grand Rapids, MI 49503-1754 Phone: 616.581.8010 E-mail: awilliam@whitemice.org GPG#D95ED383 Web: http://www.marp.org