I am having trouble making the connection to Oracle tables with VB6. I am using the code below. The only message I get is 'unable to connect to destination'. I am able to view the tables with Oracles ODBC test application using the same driver as in the code. Can anyone help me out on how to debug my connection problem? Thanks.
conn = "UID=argLoginId;PWD=argPassword;driver=" _
& "{Oracle ODBC Driver};SERVER=ODBC_IVR;"
Set cn = New ADODB.Connection
cn.ConnectionString = conn
cn.Open
