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

[DB-SIG] DSN or not

2007-10-24 Thread Carl Karsten
>> An example from my code, which returns a database connection: >> >> import pyodbc >> >> def connect_to_db2(): >> """ >> quick and dirty connect to db2 >> """ >> s='DRIVER={iSeries access ODBC Driver};SYSTEM=10.3.36.150;UID=%s;PWD=%s' >> return >> connect_to_db(connect_str=s%(

Re: [DB-SIG] DSN or not

2007-10-24 Thread M.-A. Lemburg
Carl Karsten wrote: >>> An example from my code, which returns a database connection: >>> >>> import pyodbc >>> >>> def connect_to_db2(): >>> """ >>> quick and dirty connect to db2 >>> """ >>> s='DRIVER={iSeries access ODBC Driver};SYSTEM=10.3.36.150;UID=%s;PWD=%s' >>> return >>

[DB-SIG] [SOLVED]Re: no-error error

2007-10-24 Thread Lukasz Szybalski
On 10/19/07, Lukasz Szybalski <[EMAIL PROTECTED]> wrote: > Hello, > I have a python program that converts some data and writes it via ODBC driver. > I am using a win32 dbi,odbc to do that. (none of the free other ones work) > > I just upgraded my ODBC driver to a newer version that supposedly is a