we have a C++ program that uses ADO to connect to various databases. We've successfully been connecting to SQL Server databases using the SQL Server Native Client ODBC drivers. We are now trying to use the "ODBC Driver 11 for SQL Server" driver and I keep getting the following error from ADODB.Connection:
( 0x800a0e7a ) Provider cannot be found. It may not be properly installed.
This is my connection string:
Provider=ODBC Driver 11 for SQL Server;SERVER=MYPC\SQL2014a;Trusted_Connection=Yes;
It works fine if I use SQL Server Native Client 10 or 11.
I can create a DSN using the ODBC Administrator and "ODBC Driver 11 for SQL Server" and do a test connection successfully.
Any suggestions as to why I'm getting the error ?