Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How to connect to DSN(64bit) from 32bit applicatio

Author  Topic 

deepakb
Starting Member

1 Post

Posted - 2008-11-24 : 04:07:59
Hi,

I have a 32-bit dll which calls SQLConnectW() with DSN and credentials.
This works fine on 32 bit OS but when I run it on Win2k3 x64 with MSSQLServer 2000 SP4 (32 bit) it fails with error.

I know that if we use C:\WINDOWS\SysWOW64\odbcad32.exe to create DSN, then this DSN can be accessed by SQLConnectW() from my 32 bit application.

But if we create a DSN on x64 using the default C:\WINDOWS\system32\odbcad32.exe, this DSN cannot be connected using SQLConnectQ() from 32 bit DLL

I need to make this work.

Any idea, can this be done & how ?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-26 : 23:28:46
You need to have 64-bit ODBC drivers to support that.
Go to Top of Page
   

- Advertisement -