I run Matlab 2009a on Windows 7 64bit. I try to set up a database connection as described in the database toolbox. When I open the odbc connection manager and try to set up a user-dsn I always end up in an error message "cannot load odbc driver, system error 193".Later I found out that on 64bit systems there is another odbc configuration manager located in c:\windows\sysWoW64\odbcad32.exe. Using that application I could successfully set up a user-dsn named 'interface' as required by the matlab docs. But when I try to connect to this database from matlab, I again receive that error:conn = database('interface', '', '')conn.Messageans =due to system error 193 [...] the specified driver could not be loadedPlease help to get that odbc connection running.Thanks
|
|
0
|
|
|
|
Reply
|
me
|
12/15/2009 10:41:26 PM |
|
me
> I run Matlab 2009a on Windows 7 64bit. I try to set up a database connection as described in the database toolbox. When I open the odbc connection manager and try to set up a user-dsn I always end up in an error message "cannot load odbc driver, system error 193".Later I found out that on 64bit systems there is another odbc configuration manager located in c:\windows\sysWoW64\odbcad32.exe. Using that application I could successfully set up a user-dsn named 'interface' as required by the matlab docs. But when I try to connect to this database from matlab, I again receive that error:conn = database('interface', '', '')conn.Messageans =due to system error 193 [...] the specified driver could not be loadedPlease help to get that odbc connection running.Thanks
Be aware that connections between 64-bit systems to 32-bit software won't work...
I work on 64 win server 2008 and can't connect to access 32-bit.
Submit a service request for confirmation
Oleg
|
|
0
|
|
|
|
Reply
|
oleg.komarov (127)
|
12/24/2009 1:47:04 PM
|
|