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.
