ASPN ActiveState Programmer Network
ActiveState
/ Home / Perl / PHP / Python / Tcl / XSLT /
/ Safari / My ASPN /
Cookbooks | Documentation | Mailing Lists | Modules | News Feeds | Products | User Groups


Recent Messages
List Archives
About the List
List Leaders
Subscription Options

View Subscriptions
Help

View by Topic
ActiveState
.NET Framework
Open Source
Perl
PHP
Python
Tcl
Web Services
XML & XSLT

View by Category
Database
General
SOAP
System Administration
Tools
User Interfaces
Web Programming
XML Programming


MyASPN >> Mail Archive >> activepython
activepython
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


Privacy Policy | Email Opt-out | Feedback | Syndication
© ActiveState Software Inc. All rights reserved