1. This exception is always reported when the database is deployed on the client machine.
Analysis: Because of the use of OLE DB, the Universal driver,
Connection string
Provider=MSDAORA.1; PASSWORD=CCIM; User Id=ccim;data Source=ccim; Persist Security Info=true
This Microsoft offers a driver that may not be in the system.
Then the replacement
Provider= oraoledb.oracle; PASSWORD=CCIM; User Id=ccim;data Source=ccim; Persist Security Info=true
This is the driver that is directly designated as Oracle.
By checking the information on the Internet, we know:
Msdaora.1 using the MS driver
OraOLEDB.Oracle use Oracle driver, the reason is not successful is not installed Oracle provides driver, you go to oracle.com download, free, bigger (about 100M)
This is Oracle drive Oracle Provider for OLE DB 10.2.0.1.0
The "msdaora.1" provider is not registered on the local computer