Help ODBC Problem With me
by Arvind Sidhaye other posts by this author
Feb 8 2006 5:00AM messages near this date
view in the new Beta List Site
RE: Cannot install ACtivestatepython2.4.2.10 on WinXP
|
Subscription
�
Hi,
I have Visual FoxPro 5.0 Database having proper data inserted.
I created ODBC database DSN Name "myDSN" with no user and passwod.
Following program gives me error
import odbc
import dbi
import datetime
conn = odbc.odbc("myDSN//")
cur = conn.cursor()
sql = 'Select doc_date,doc_num from transpt where doc_Type = "ZF" and '
sql = sql + ' doc_date = ? '
mydate = datetime.date(2005,4,30)
dbimydate = dbi.dbiDate(mydate)
r = cur.execute(sql,(dbiimydate,))
res = cur.fetchall()
pint res
***Program Ends
Here if statement is fired without using parameter clauses, the result is very fine. but as
soon as when parameter clauses are added, the pythonwin error occurs and IDE environment ter
minated.
Please help me to resolve this problem
Thanks
Arvind Sidhaye
Attachments:
unknown1
unknown2
unknown3
unknown4
|