Sentinel: Connecting to the Oracle database through ODBC DSN works for some server, but not others

  • 3191758
  • 29-Jan-2007
  • 26-Apr-2012


Microsoft Windows Server 2003 Standard Edition
Microsoft Windows 2000 Server
RedHat Linux
Solaris 9


In some cases, ODBC connection through an agent does not work.


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.


The problem is the version of the Oracle ODBC driver. Make sure that the driver is Oracle version 9i.