search

WanderInCode / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

Unable to connect to *.DBF, if file name lenght exceeds 8 characters #329

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. Create a *.dbf file with 9 or more characters in file name
2.e.g.
DBFconn = pyodbc.connect('Driver={Microsoft dBASE Driver 
(*.dbf)};DBQ='+directory, autocommit = True)
DBFcursor = DBFconn.cursor()
SQL_Query = 'SELECT * FROM abcdefghi.dbf ORDER BY UID;'

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

As usual it should return a cursor

What version of the product are you using? On what operating system?
pyodbc-3.0.6.win32-py2.6
On Windows 7 32-bit OS

Please provide any additional information below.

Error Info:
    <class 'pyodbc.ProgrammingError'>: ('42S02', "[42S02] [Microsoft][ODBC dBase Driver] The Microsoft Jet database engine could not find the object 'abcdefghi.dbf'.  Make sure the object exists and that you spell its name and the path name correctly. (-1305) (SQLExecDirectW)")

Original issue reported on code.google.com by mallikar...@gmail.com on 4 Jul 2013 at 6:27