SQLTeam.com | Weblogs | Forums

SQL Server Linked Server - Architecture mismatch


I am trying to create a linked server from SQL Server using Microsoft OLE DB Provider for ODBC Drivers.

I have all the settings and I am sure they are correct, but SQL Server keeps throwing an error back at me,

"The specified DSN contains an architecture mismatch between the Driver and Application"

The server is 64-bit and the application is 32-bit. I have setup an ODBC connection in both the 32 & 64 bit ODBC managers and still get this error.

Is there anything else I should be trying?