2.2 Databases and Connections

In order for a DBTools.h++ application to interact with a database, an RWDBDatabase instance must be created by calling:

RWDBManager::database(accessLib, serviceName, userName, 
                      passWord, "");

All arguments are of type RWCString. For Oracle, you must provide the following:

accessLib: If you are using DLLs or shared libraries, provide the name of the shared library or DLL. See the DBTools.h++ Build Guide for information about naming conventions. If you are using a static library, supply the string ORACLE.
serviceName: Supply the Oracle service name for your connection; ask your DBA for assistance.
userName: Supply the user name of a valid Oracle user.
passWord: Supply the password for the user.
databaseName: Empty string.

Here are two examples of opening a database on an Oracle service. Notice that both require a user name and password to provide the highest level of security. In the first example, the accessLib is defined as ORACLE, indicating that the application must be linked with the static version of the access library:

RWDBManager::database("ORACLE", "INHOUSE", "cratchitt", 
                      "scrooge", "");

The second example shows how to open the same database from a Windows application. In this case, the accessLib is defined as ora7d.dll, which indicates that the application will dynamically load the access library at runtime:

RWDBManager::database("ora7d.dll", "INHOUSE", "cratchitt",
                      "scrooge", "");