Sage 100

Dumb-arse SQL ODBC question. I'm using a 32-bit application on Server A (running a 64-bit version of Windows) to connect to a 64-bit SQL Server on Server B. Can I use the 32-bit ODBC Administrator on Server A to create a SQL DSN that connects to the 64-bit SQL Server on Server B? Or does it require I use the 64-bit ODBC Administrator on Server A?

@AlnoorCassim I think the underlying issue is the bitness of the client; It needs to comply with the bitness of the DSN and the corresponding ODBC driver. At our office, we use a 64 bit SQL server to run SalesLogix. We also have a couple test workstations still running 32 bit versions of Windows with 32 bit version of Office.2010. I can still connect to the 64 bit SQL server using a 32 bit ODBC driver via a 32 version of Excel.

I think either will work since the SQL client usually includes both 32/64 bit drivers. For future troubleshooting simplicity, I would go with the former.

That's exactly what I needed to know. Thanks you both!