I have a Visual Basic 6 app that currently connects fine to an Oracle database using the Oracle XE driver:
Set MyConn = New ADODB.Connection
MyConn.Open "Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Ora.mydomain.com)(PORT=1000)))(CONNECT_DATA=(SID=SVR)(SERVER=DEDICATED)));User Id=myuser;Password=mypassword;"
However, I need to change the program to use the Oracle Instant Client driver instead, and I am unable to get it to work. I've tried multiple formats but they all fail. Also, I do not have access to the user's TNSnames.ora file on their PC, so the connection string can not reference the user's TNS settings.
Any help would be greatly appreciated. Thanks.