Search code examples
vb6odbcsql-server-native-client

VB6 "Provider cannot be found."

I have a few applications written in VB6 that are all using the same connection string on the same machine. They are using the ODBC provider with the SQL Server Native Client 10.0 driver and connecting with explicit username and password.

At run-time, one of the applications throws an exception when I try to connect to the database:

3706: Provider cannot be found. It may not be properly installed.

I don't understand why this one application is having an issue when the others are working fine. The references are the same, down to the version number.

Solution

  • Try installing MDAC on your machine.