Re: [DB-SIG] Reading DB2 on AIX in Python scripts

2007-10-24 Thread M.-A. Lemburg
On 2007-10-24 06:03, James Briggs wrote: > Hi, > > I have been using pyodbc to connect to DB2 on an AS400. > Different beast I know but this is successful provided you have the correct > ODBC drivers installed for the flavour of DB2 on your PC. > > An example from my code, which returns a databas

Re: [DB-SIG] Reading DB2 on AIX in Python scripts

2007-10-23 Thread James Briggs
Hi, I have been using pyodbc to connect to DB2 on an AS400. Different beast I know but this is successful provided you have the correct ODBC drivers installed for the flavour of DB2 on your PC. An example from my code, which returns a database connection: import pyodbc def connect_to_db2():

Re: [DB-SIG] Reading DB2 on AIX in Python scripts

2007-10-23 Thread David . Lloyd
Many thanks for that Harald. I will try that out and have a look at the pydb2 project site. Kind Regards Dave Lloyd "Harald Armin Massa"

Re: [DB-SIG] Reading DB2 on AIX in Python scripts

2007-10-23 Thread Harald Armin Massa
David, never done that. But a quick google reveals: http://sourceforge.net/projects/pydb2/ there is a python package, called pydb2. So the most propable code will be: import pydb2 cn=pydb2.connect(database="database", host="host", user="user", password="password") cs=cn.cursor() cs.execute