|
I just installed SQLAnywhere 11 on a new Win7 64 machine. I have a legacy application that needs to use 32 ODBC. When I click on any demo System Data Source supplied in the install I get the following error: Microsoft ODBC Administrator The setup routines for the SQL Anywhere 11 ODBC driver could not be loaded due to system error code 126: The specified module could not be found. (D:\PROGRA~2\SQLANY~1\BIN32\dbodbc11.dll) It also seems to post a version of this message when I cancel the first but this seems to originate from Driver's ConfigDSN, or ConfigTranslator failed as this the message header. I have verified that this file does exist in the Bin32 directory. I have also verfied that the directory is in the system PATH. I can successfully do this from the 64Bit ODBC administrator however this does me no good. I have successfully started my database using "D:\Program Files\SQL Anywhere 11\Bin32\dbeng11.exe" |
|
Try to insert the full path in the reg key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\SQL Anywhere 11 Maybe the short filenames are disabled on your machine. Thanks, that did the trick. How do you enable short filenames?
(27 Jun '12, 09:58)
Joe Snyder
Replies hidden
1
By default your NTFS drives creates an 8.3 (8-character for the name and 3 for the extension) filename each time a long filename is created. This feature can be disable, to increase disk speed: •Click on Start, type cmd in the Search Bar> right click "Run as admininstrator". •Once the commnand prompt is opened type the command below: •fsutil behavior set disable8dot3 1 •Restart your PC
(27 Jun '12, 12:19)
Martin
1
@Martin: Just out of curiosity - do your machines have disabled short file names? (I wasn't aware of that optimization, though I would think it's effect won't be huge...:)
(27 Jun '12, 12:28)
Volker Barth
I think for the database it doesn't make any difference, but for file intensive applications like a Document Management System considering it might be beneficial.
(28 Jun '12, 02:32)
Martin
|
|
Also make sure that you have D:\PROGRA~2\SQLANY~1\BIN32\dbcon11.dll present. This is the module that contains the ODBC Admin dialogs. |
do you get the same error when you use c:\windows\syswow64\odbcad32.exe to set up the odbc connection.