Run the ODBC Unit Tests
 
 
 

There are two sets of tests. One set for Oracle, and one set for MySql. Do the following in a terminal window:

  1. cd /home/OpenSource/Providers/GenericRdbms/Src/UnitTest
  2. cp OdbcInit.txt OdbcInitEx.txt
  3. NoteThe contents of this file is
    provider=Odbc;clean=false;
    serviceOracle=oraserver;usernameOracle=xxxx;passwordOracle=xxxx;DSNOracle=xxxx;enableOracleSetup=false;
    serviceMySql=mysqlserver;usernameMySql=root;password=xxxx;DSNMySql=xxxx;
    serviceSqlServer=sqlserver;usernameSqlServer=xxxx;passwordSqlServer=xxxx;DSNSqlServer=xxxx;
  4. Edit OdbcInitEx.txt. Replace “serviceOracle=oraserver” with “service=<netServiceName>” where <netServiceName> is the name of the entry in the $ORACLE_HOME/network/admin/tnsnames.ora file. Replace “xxxx” in “usernameOracle=xxxx” with the name of a user that you created in the Oracle database that has been assigned the F_USER_ROLE role. Replace “password=xxxx” with “password=<userPassword>”. Replace the “xxxx” in “DSNOracle=xxxx” with the Data Source Name in the /etc/odbc.ini file created during the install of the Easysoft ODBC Oracle driver. By default, that value is ORACLE.
  5. unix> ./UnitTestOdbc initfiletest=OdbcInitEx.txt OdbcOracleTests