ODBC Driver could not be loaded due to system error code 126

[Former Member]

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"

[t1950]

do you get the same error when you use c:\\windows\\syswow64\\odbcad32.exe to set up the odbc connection.

[MCMartin · Accepted solution]

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.

[Former Member · Accepted solution]

Thanks, that did the trick.

How do you enable short filenames?

[MCMartin · Accepted solution]

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

[VolkerBarth · Accepted solution]

@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...:)

[MCMartin · Accepted solution]

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.

[jack_schueler]

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.