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?