My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 76: [ODBC dBase Driver] "Optional feature not implemented"
1 person starred this issue and may be notified of changes. Back to list
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

Powered by Google Project Hosting