Issue 76: [ODBC dBase Driver] "Optional feature not implemented"
Status:  NoFix
Owner: ----
Closed:  Dec 2009
Reported by faul...@iinet.net.au, Nov 9, 2009
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'

Nov 9, 2009
#1 faul...@iinet.net.au
Addendum:

Same error with Autocommit=True also
Nov 9, 2009
#2 faul...@iinet.net.au
DOH!

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

appears to work
Nov 10, 2009
Project Member #3 mkleehammer
Great.  I'll leave this open and make it generate an error if autocommit has the
wrong case...
Status: Investigating
Dec 31, 2009
Project Member #4 mkleehammer
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.

Status: Invalid
Nov 21, 2010
Project Member #5 mkleehammer
(No comment was entered for this change.)
Status: NoFix