Hi,<br><br>I have been using pyodbc to connect to DB2 on an AS400. <br>Different beast I know but this is successful provided you have the correct ODBC drivers installed for the flavour of DB2 on your PC.<br><br>An example from my code, which returns a database connection:
<br><br>import pyodbc<br><br>def connect_to_db2():<br> """<br> quick and dirty connect to db2<br> """<br> s='DRIVER={iSeries access ODBC Driver};SYSTEM=<a href="http://10.3.36.150">
10.3.36.150</a>;UID=%s;PWD=%s'<br> return connect_to_db(connect_str=s%('myuser','mypassword'),autocommit=True)<br><br>db=connect_to_db2()<br>c=db.cursor()<br>#<br># insert working code here<br>#<br>
c.close()<br>db.close()<br><br>I found the autocommit needs to be true for our flavour of DB2, this may not be the case with DB2 on AIX which has proper rollbacks and commits.<br><br>James<br><br><br><br><div><span class="gmail_quote">
On 10/24/07, <b class="gmail_sendername"><a href="mailto:David.Lloyd@cis.co.uk">David.Lloyd@cis.co.uk</a></b> <<a href="mailto:David.Lloyd@cis.co.uk">David.Lloyd@cis.co.uk</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>Hello,<br><br>I am new to Python and I am trying to work out if it is possible to use<br>Python to read DB2 version 8/9 tables on an AIX server. The code will<br>reside on the same server as the database.<br><br>If it is possible, does anyone have any examples of connecting to a DB2
<br>database they could forward to me?<br><br>Regards<br><br>Dave Lloyd<br>*************************************************************************<br><br>This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return: you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions expressed are those of the individual author.
<br><br>The CIS marketing group, members of which are authorised and regulated by the Financial Services Authority, includes:<br>Co-operative Insurance Society Limited Registered in England number 3615R<br>CIS General Insurance Limited Registered in England number 29999R
<br>CIS Unit Managers Limited Registered in England and Wales number 2369965<br>CIS Policyholder Services Limited Registered in England and Wales number 3390839<br><br>Registered offices: Miller Street, Manchester M60 0AL
<br>Internet <a href="http://www.cis.co.uk">http://www.cis.co.uk</a><br><br><br>CIS & the CIS logo (R) Co-operative Insurance Society Limited<br><br><br>*************************************************************************
<br>_______________________________________________<br>DB-SIG maillist - <a href="mailto:DB-SIG@python.org">DB-SIG@python.org</a><br><a href="http://mail.python.org/mailman/listinfo/db-sig">http://mail.python.org/mailman/listinfo/db-sig
</a><br></blockquote></div><br>