[egenix-users] InterfaceError: HY024

[M.-A. Lemburg]

Tentin Quarantino wrote:
> Hello,
> 
> Recently, this error started to display:
> -----
> File "mx/ODBCConnect/Common/ProxyObjects.py", line 1319, in process_response
> mx.ODBCConnect.Error.InterfaceError: ('HY024', -1023,
> "[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid
> path.  Make sure that the path name is spelled correctly and that you
> are connected to the server on which the file resides.", 10102)
> 
> ###
> 
> I thought to ask here in case it was a common error.
> Is this saying that the database file is missing somehow?
> Could it be locked, as in another application possibly has locked it?

This sounds like a permissions problem. Make sure that you define
the DSN as a system DSN and that the service account under which
mxODBC Connect Server runs has access to this DSN and/or Access
file.

Here's something Google returns for the above error:

http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/c2750880-ef19-4ec4-88bf-9fadfe677d1e

That discussion there suggests a problem with the authentication management
used for the Access DB.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Jun 05 2009)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2009-06-29: EuroPython 2009, Birmingham, UK                23 days to go

::: Try our new mxODBC.Connect Python Database Interface for free ! ::::


   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611
               http://www.egenix.com/company/contact/