Re: odbc errors

2005-10-16 Thread Roger Upole
[EMAIL PROTECTED] wrote: > hi > > i have a piece of code: > ... > > def connectdb(sql): >import dbi >import odbc >import sys >try: >s = odbc.odbc('DSN=CONN;UID=user;PWD=pass') >cur = s.cursor() > # cur.execute("set nocount on") >cur.execute(sql) >

odbc errors

2005-10-16 Thread eight02645999
hi i have a piece of code: ... def connectdb(sql): import dbi import odbc import sys try: s = odbc.odbc('DSN=CONN;UID=user;PWD=pass') cur = s.cursor() # cur.execute("set nocount on") cur.execute(sql) while 1: rec = cur.fetchone()