In order to post questions, answers, or comments, you now need a validated email address. Details on how to validate your address are in the FAQ.

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"

asked Jun 26 '12 at 13:09

Joe%20Snyder's gravatar image

Joe Snyder
36115

edited Jun 27 '12 at 05:39

Breck%20Carter's gravatar image

Breck Carter
19.5k303452649

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

(Jun 27 '12 at 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.

answered Jun 27 '12 at 05:23

Martin's gravatar image

Martin
7.6k84120204

Thanks, that did the trick.

How do you enable short filenames?

(Jun 27 '12 at 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

(Jun 27 '12 at 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...:)

(Jun 27 '12 at 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.

(Jun 28 '12 at 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.

answered Jun 27 '12 at 09:37

JBSchueler's gravatar image

JBSchueler
1.0k520

edited Jun 27 '12 at 09:38

Your answer
toggle preview

Are you providing an answer to the original question, or making a comment on the question or an answer? If you are making a comment please do not post a new answer. Click "Add new comment" on the question or answer instead. If you are responding to a previous comment, click on the "reply" icon (    ) for that comment.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link: [text](http://url.com/ "title")
  • image: ![alt text](/path/img.jpg "title")
  • numbered list (indent for sublists):
    1. Foo
    2. Bar
  • bullet list (indent for sublists):
    * Foo
    * Bar
  • to add a line break, add two spaces to where you would like the new line to be.
  • Code blocks should be indented by 4 spaces. SQL code should begin with ":::SQL" on the first line.
  • basic HTML tags are also supported

Tags:

×96
×15

Asked: Jun 26 '12 at 13:09

Seen: 19,481 times

Last updated: Jun 28 '12 at 02:32

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link: [text](http://url.com/ "title")
  • image: ![alt text](/path/img.jpg "title")
  • numbered list (indent for sublists):
    1. Foo
    2. Bar
  • bullet list (indent for sublists):
    * Foo
    * Bar
  • to add a line break, add two spaces to where you would like the new line to be.
  • Code blocks should be indented by 4 spaces. SQL code should begin with ":::SQL" on the first line.
  • basic HTML tags are also supported