mxODBC

M.-A. Lemburg mal at lemburg.com
Wed Jan 12 13:20:21 EST 2000


Anders M Eriksson wrote:
> 
> hELLO!
> 
> I'm trying to use the mxODBC module to access an dBASE 5 database on a
> Windows NT system. I have used this script:
> 
> import ODBC.Windows
> 
> db = ODBC.Windows.connect('myDatabase')         # MyDatabase is a
> local DSN
> <snip>
> db.close()
> 
> When I run this script I get this error on the connect line
> 
> NotSupportedError: ('S1C00', 106, '[Microsoft][ODBC dBase
> Driver]Optional feature not implemented ', 4226)
> 
> If I use the Win32 odbc then it works!
> 
> any idea what is wrong??

As already mentioned in private mail: you have to pass
0 for the optional clear_autocommit parameter of the
connect APIs. File DSNs do not support transactions and thus
always operate in auto commit mode.

-- 
Marc-Andre Lemburg
______________________________________________________________________
Business:                                      http://www.lemburg.com/
Python Pages:                           http://www.lemburg.com/python/






More information about the Python-list mailing list