Setup odbc connection windows 2008 r2

Archived Forums. Sign in to vote. I had 32 bit application installed on Win R2 64 bit, my applications use ODBC to access sql server 32 bits on another server. Would you please guide me, how to solve it? Tuesday, December 1, AM. Thanks, Leks. So you have to Add or Change in 2 places to cover both types. Tuesday, December 1, PM. Wednesday, December 2, AM. But on bit systems, there are two views on ODBC - one is bit, the other is bit. It looks like you opened the default bit view which doesn't show the bit ODBC drivers.

Here you find odbcad After launching the exe you can add a new system dsn or user dsn for the required ODBC driver. Configure it as usual. All other ODBC drivers you have been missing will appear there. Works great! At least to the point I can test the connection and get a successful response. After I enter it, I get this response Any other thought?

That made things work for my 32bit application. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Sign in to vote. Thursday, September 3, PM.

Hi, Wilson! I'd like to thank you for the hints. I found the solution by searching information in the forums you indicated. Tuesday, September 8, PM. Hi Mirela, Windows Server R2 is the first operating system which is bit only. Friday, September 4, AM. Hi Mirela, Thanks you for sharing the information here. This posting is provided "AS IS" with no warranties, and confers no rights. Wednesday, September 9, AM.