We have a VB6 application that access Oracle database
using 9.2 client. When we try to run this application using a
10g client, we experience problems with database
connections getting dropped, application hangs, etc.
We'd prefer to use the 10g client, but we are not sure what
needs to be changed in order to get it to work.
Example below of logic we are using to create db connections
Set mvarSession = CreateObject("OracleInProcServer.xOraSession")
Set mvarConnection = Nothing
Set mvarConnection = New RDO.rdoConnection
sAltersession = "ALTER SESSION SET OPTIMIZER_MODE=RULE"
.Connect = "uid=" & sUserID _
& ";pwd=" & sPassword _
& ";DSN=" & sRemoteDatabase & ";"
.CursorDriver = rdUseClientBatch