Accessing 64-bit SQL Anywhere DB DSN source

Question

0.00/5 (No votes)

See more:

Hello all,

Well, I've run into a road block and could use some ideas. I built a program that looks at a SQL Anywhere database 9.0. It has worked fine under XP or windows 7 as long as the DB is in the 32bit ODBC directory. As the application that creates the database, not mine, puts it there. Seems like the application in W7'puts the DSN in the 64-bit directory now. I've managed to get the listing off the DSN from the 64-bit directory but when I take the DSN and put it in the connect string the error says "DSN' blah,blah,blah' does not exist.

So, I'm assuming that for some reason the connect string is missing something or my library the iAnyhere.Data.SQLAnywhere.v3.5 does not have the idea to look at the 64-bit ODBC sources.

I've tried DSN-less connect string without any luck cannot seem to geta valid connect string built. Have scowered the Internet for examples without any success.

Any ideas?

Thanks

Posted 16-Apr-12 6:12am

tharre

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2012-04-17T07:37:00

Solution 1

Try to run: C:\Windows\SysWOW64\odbcad32.exe to register new DSN source. And use this DSN name building connection string ;)

Posted 17-Apr-12 7:37am

Maciej Los

Comments

tharre 18-Apr-12 0:05am

It's not I can't create a 64 bit ODBC. The issue is that the DB that i'm trying to access is 64 bit and my program is 32bit trying to read a 64 bit DSN. I can retrieve the DSN from the registry but the iAnywhere sql odbc does not find it as I'm sure it thinks it is 32 bit. I'm still investingating if i need to install 64bit SQL Anywhere tools and then grab the proper iAnywhere .net dll.