64 bit ODBC Exception

vb.net sql-server-2005 odbc driver windows-7-x64
Jrud picture Jrud · Dec 22, 2009 · Viewed 15.8k times · Source

I am getting the following ODBC exception when I moved my development platform from Windows XP X86 to Windows 7 X64:

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

What I'm sure it means is that the server it is connecting to is 32 bit, and the computer I'm running on is 64 bit and the ODBC driver in use is 64 bit.

The application I am writing is set to run in 32 bit mode because some of the third-party software that we employ is not 64 bit compatible.

I tried downloading a 32 bit driver and changing the DSN but it did not fix my issue. I still get the exception.

If anyone has any links for 32 bit SQL drivers, or any ideas on how I could fix this by changing the project around, I'm all ears.

Thanks in advance,

-Jrud-

Answer

MartW picture MartW · Dec 22, 2009

It sounds more that you've setup a 32-bit DSN using the 64-bit ODBC Administrator :

http://msdn.microsoft.com/en-us/library/ms712362(VS.85).aspx

Try using this ODBC Administrator instead :

c:\windows\sysWOW64\odbcad32.exe

Related questions

A network-related or instance-specific error occurred while establishing a connection to SQL Server

I HOST MY ASP.NET WEBSITE ON WEBSERVER ..But after upload when i try to access my site ... http://www.vbi.volvobusesindia.com Then following error occurs .... A network-related or instance-specific error occurred while establishing a connection to SQL Server. …

Read More
What is a NullReferenceException, and how do I fix it?

I have some code and when it executes, it throws a NullReferenceException, saying: Object reference not set to an instance of an object. What does this mean, and what can I do to fix this error?

Read More
Converting string to byte array in C#

I'm converting something from VB into C#. Having a problem with the syntax of this statement: if ((searchResult.Properties["user"].Count > 0)) { profile.User = System.Text.Encoding.UTF8.GetString(searchResult.Properties["user"][0]); } I then see the following errors: Argument 1: cannot …

Read More