Trying to connect to Oracle DB using VBA. The machine has both oracle 10g and 11g.
When DSN is created for 11g, test connection is successful but when used in the following code
Set cn = New ADODB.Connection
cn.Open "DSN=" &DSNname& ";UID=" &uid& ";PWD=" &pwd
Specified driver could not be loaded due to system error 193(Oracle in OraDB11g_home1)
if connection is setup without DSN as below
str1 = "Provider=OraOLEDB.Oracle;Data Source=;User ID=;Password=;"
cn.ConnectionString = str1
then it gives following error
OraOLEDBplus10.dll: The specified module could not be found.
Provider cannot be found. It may not be properly installed