Before running the tests you must do the following:
Connect
to the Oracle database that you will use for the Oracle tests using the
sys as sysdba user, create a user and grant the user two roles:
dba and wm_admin_role.
Install
a MySql ODBC driver. Go to http://dev.mysql.com/downloads/connector/odbc/3.51.html,
download the Windows driver installer (MSI), and run the installer.
For this exercise a file named mysql-connector-odbc-3.51.12-win32.msi
was downloaded.
Open
Sql Server 2000 Enterprise Manager. Create a new login for the target Sql
Server. Use SQL Server authentication and grant the new user the “Database
Creators” role.
cmd> cd C:\OpenSource\Providers\GenericRdbms\Src\UnitTest
cmd> copy /A OdbcInit.txt OdbcInitEx.txt
Edit
OdbcInitEx.txt. Replace the serviceMySql and passwordMySql values in
“serviceMySql=mysqlserver;usernameMySql=root;passwordMySql=xxxx;”
with valid values. The usernameMySql value must remain as root.
Edit
OdbcInitEx.txt. Replace the serviceOracle, usernameOracle and passwordOracle
values in “serviceOracle=oraserver;usernameOracle=xxxx;passwordOracle=xxxx;”
with the actual service name, the name of the user that you created
and the password that you assigned to that user.
Edit
OdbcInitEx.txt. Replace the serviceSqlServer, usernameSqlServer
and passwordSqlServer values in “serviceSqlServer=sqlserver;usernameSqlServer=xxxx;passwordSqlServer=xxxx;”
with the actual service name, the name of the user that you created
and the password that you assigned to that user.
