In the <ODBC driver installation directory>/demo directory, there are SQL scripts that you can use to create tables for each specific type of database—for example, emporacle.sql and empinformix.sql. Run the appropriate SQL script to create a demo table for your specific database and insert the test data. For example, if you are using an Oracle database, use a command similar to the following to run the demoodbc program against your database:
# ./demoodbc Oracle8 –uid<username> -pwd<password>
The same output that displayed on the window using the dBase driver should also display when you use your database driver (because you are using the same test data).
If the driver does not work, the problem may be in the driver’s configuration or in the database’s configuration. If you cannot make the connection, you may need to ask your database administrator (DBA) to verify or fix something for you. For example, for Oracle8, the ServerName should have an entry in both the tsnames.ora file and the listener.ora file. Both the database and the listener must be running. Your DBA would have to verify that these are true.
If you have properly installed and tested the EC Gateway software and the DataDirect Technologies ODBC drivers, you are ready to begin using EC Gateway in a production mode.
