RSA Admin

Oracle UDS Integration Problem

Discussion created by RSA Admin Employee on Jul 28, 2008

Hi All, I am trying to configure a connection between enVision and Oracle 9.X in order to collect an application logs from a dedicated table in the database (not a system logs). After creating the relevant query with my DBA (we found it working properly on SQLPLUS) I configured enVision with the relevant parameters. My problem is that enVision server can't connect to the DB, I'm receiving the following error message:

 

 

 %NIC-3-605128: ODBC, ODBC, -, -, -, -, Detail: 5868: symbols:query:Extended DB error: Database error details: retcode=-1, sqlstate=42000, native_error=933, msg=[Microsoft][ODBC driver for Oracle][Oracle]ORA-00933: SQL command not properly ended 

 

Any idea? 

 

Thanks, 

 

Moshe. 

Outcomes