how to used pyodbc to connect foxpro table

ajak_yahoo arazak73 at yahoo.com.my
Tue Jul 1 23:12:14 EDT 2008


Good Morning to All,

Can anyone help me to connect pyodbc to foxpro table.
Below code can't works.


import pyodbc
cnxn = pyodbc.connect("DSN=sls_detl")

Traceback (most recent call last):
  File "<pyshell#1>", line 1, in <module>
    cnxn = pyodbc.connect("DSN=sls_detl")
Error: ('S1000', "[S1000] [Microsoft][ODBC Visual FoxPro Driver]File is not open. (113) (SQLDriverConnectW); [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). (0)")


T.q
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20080702/44896db9/attachment.html>


More information about the Python-list mailing list