Monday, March 19, 2012

ODBC Components not loading

I am running SQL Express on a Server 2003 R2 machine. The application that uses the database needs to have the ODBC drivers installed. Everytime I try to add them, the installer looks like it does something, but when I go to the Data Source option under Administrative Tools, the only driver I see is the SQL Native Client. Any ideas?1) What ODBC driver are you expecting to install?
2) When you mentioned "Data Source", you meant that the drivers did not show up under the "drivers" tab of "ODBC Data Source Administrator", correct?|||

The SQL Native client is the ODBC driver for SQL Server. You just need to add a new DSN to connect to the right server and then use the DSN to connect. If that is not what you intend on doing, please describe exactly what you trying to do.

The following links talks more about it in detail.

http://blogs.msdn.com/sqlnativeclient/archive/2006/09/27/774287.aspx

HTH

Riyaz

No comments:

Post a Comment