2017-04-12 05:27 PM
I am trying to setup an ODBC connection to an Oracle SQLPlus database. I cannot figure out which combination of parameters to include in the DSN. I have used every Oracle DSN template available in NetWitness... nothing works. I have also cycled through all the drivers available in /opt/netwitness/odbc/lib/ as well as all the ODBCHOME/lib/ *.zz listed in the other DSN templates. I also tried a MySQL driver I uploaded for another custom DSN and some others...(libmyodbc5a.so, libmyodbc5-5.1.5.so, and libsqlplus.so)
Test connection failed:Error! An error occurred creating an ODBC connection for DSN: TEST The trapped error is Unable to create an ODBC connection. DSN: TEST: username TEST_username; reason: state 81; error-code:0;description:523 80
2017-04-14 01:46 PM
Michelle:
What version of Oracle are you using?
Also here is a few things to try to get ODBC to give some additional info.