Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

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.


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"

asked 26 Jun '12, 13:09

Joe%20Snyder's gravatar image

Joe Snyder
accept rate: 0%

edited 27 Jun '12, 05:39

Breck%20Carter's gravatar image

Breck Carter

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

(27 Jun '12, 05:22) Tom Mangano

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.

permanent link

answered 27 Jun '12, 05:23

Martin's gravatar image

accept rate: 14%

Thanks, that did the trick.

How do you enable short filenames?

(27 Jun '12, 09:58) Joe Snyder
Replies hidden

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

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

permanent link

answered 27 Jun '12, 09:37

JBSchueler's gravatar image

accept rate: 20%

edited 27 Jun '12, 09:38

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 26 Jun '12, 13:09

question was seen: 62,219 times

last updated: 28 Jun '12, 02:32