Share via

Connection Problem

Sandeep Mudgal 0 Reputation points
2025-09-09T06:37:26.87+00:00

Failed to connect to database.

Error code 999 Error text Invalid OLE DB provider name specified.

SQL Server Database Engine
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 35,326 Reputation points MVP Volunteer Moderator
    2025-09-09T15:08:49.9933333+00:00

    Please make sure you download and install the latest Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) and make sure the provider is not misspelled in the connection string. Make sure you are using provider Provider=SQLOLEDB or Provider=SQLNCLI11.

    To use SQLNCLI11 you need to have SQL Server Native Client driver installed.

    If you are trying to use SQLOLEDB as provider, know that driver is deprecated.

    Another probable reason is that your application runs 64-bit but only a 32-bit OLE DB provider is installed (or vice versa). In that scenario, the provider won't be found.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.