[ODBC dBase Driver] "Optional feature not implemented"

[GoogleCodeExporter]

What steps will reproduce the problem?
1.pyodbc.connect(r"DRIVER={Microsoft dBASE Driver
(*.dbf)};Autocommit=False;Dbq=d:\projects\todd") 
2.
3.

What is the expected output? What do you see instead?

expect a connection object.

get:
pyodbc.Error: ('HYC00', '[HYC00] [Microsoft][ODBC dBase Driver]Optional
feature not implemented  (106) (SQLSetConnnectAttr(SQL_ATTR_AUTOCOMMIT))')

What version of the product are you using? On what operating system?
pyodbc-2.1.5-py2.6

Windoze XP

Please provide any additional information below.

Same error with or without 'Autocommit=False'

Original issue reported on code.google.com by faul...@iinet.net.au on 9 Nov 2009 at 11:16

[GoogleCodeExporter]

Addendum:

Same error with Autocommit=True also

Original comment by faul...@iinet.net.au on 10 Nov 2009 at 12:50

[GoogleCodeExporter]

DOH!

pyodbc.connect(r"DRIVER={Microsoft Access dBASE Driver (*.dbf, *.ndx, 
*.mdx)};Dbq=d:\projects\todd", autocommit=True)

appears to work

Original comment by faul...@iinet.net.au on 10 Nov 2009 at 12:56

[GoogleCodeExporter]

Great.  I'll leave this open and make it generate an error if autocommit has the
wrong case...

Original comment by mkleehammer on 10 Nov 2009 at 1:26

• Changed state: Investigating

[GoogleCodeExporter]

Actually, I misunderstood the original error.  Autocommit is a special 
*keyword* to the connect function, it is not 
something that can be part of the connection string.  pyodbc does not examine 
your connection string at all.  It 
will append keywords to your string, but it doesn' t look at it for settings.

Original comment by mkleehammer on 31 Dec 2009 at 6:42

• Changed state: Invalid

[GoogleCodeExporter]

Original comment by mkleehammer on 21 Nov 2010 at 4:43

• Changed state: NoFix