Connect SQL Server 64 bit to odbc 32 bit

Question: I’m attempting to connect a SQL Server 64 bit linked server to a 32 bit odbc driver . The error message

The specified DSN contains an architectureThe specified DSN contains  mismatch between the Driver and application

I’ve read the post The specified DSN contains an architecture mismatch between the Driver and application  .   This doesn’t solve the specific problem , as there is no version of the Lotus Notes client driver which is 64 bit. 

I’ve tested attempting to set up a 64 bit DSN – but this doesn’t work because the set up is looking for a 64 bit Lotus Notes client – which is not installed.

How can I fix?

Answer: A SQL Server  64 bit can’t  connect to a 32 bit ODBC driver. SQL Server 64 bit can only link to the  64 bit library. Therefore , SQL Server 64 bit  only connects with a  64 bit ODBC Driver Manager library.

Some vendors haven’t invested on creating  ODBC drivers supporting both 32 bit and 64 bit.  In your case , you only have the option of a Lotus Notes client driver 32 bit.

Options to connect a SQL Server 64 bit to a 32-bit library

Your options are to a) contact the vendor and see if they have an unsupported version of the 64 bit    or b ) Investigate the possibility of using a bridge driver which allows a 32 bit to 64 bit transition.

Read More on DSN

Difference between System DSN and User DSN

Excel Connect to SQL Server - SQL Server DBA

SQL Server - SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed

SQL Kill connections to a database

SQL Server - Login failed for user 'username'. The user is not associated with a trusted SQL Server connection SQL Server - How to setup ODBC for IBM AS/400 - SQL Server DBA