Environment
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows 2000 Server
RedHat Linux
Solaris 9
Situation
In some cases, ODBC connection through an agent does not
work.
---------------------
Scenario:
After loading the Oracle9i ODBC driver for microsoft and an DSN is created.
Testing the DSN through the driver works with "connection successful"
Importing the entire table into excel or access using the same DSN was successful.
In state 4 it calls the OpenDB routine from the eSecurity_Actions lookup file.
In the OpenDB routine, it continues to return a -1 for the i_DB_Handle during the DBOPEN command.
---------------------
Scenario:
After loading the Oracle9i ODBC driver for microsoft and an DSN is created.
Testing the DSN through the driver works with "connection successful"
Importing the entire table into excel or access using the same DSN was successful.
In state 4 it calls the OpenDB routine from the eSecurity_Actions lookup file.
In the OpenDB routine, it continues to return a -1 for the i_DB_Handle during the DBOPEN command.
Resolution
The problem is the version of the Oracle ODBC driver. Make sure
that the driver is Oracle version 9i.