Oracle Alias Creation

In order to use the Oracle Extension, you must first create an alias in the Borland Database Engine (BDE) for your source data store to communicate with the Oracle client installed on your machine. A BDE alias is not required for your target data store.

Note:

To create an Oracle alias:

  1. Open BDE Administrator (from the Control Panel). Click the Configuration tab, and then select ORACLE from the Native Drivers list as shown in Figure A-1:
  2. In the Definition of ORACLE pane, click in the second column for DLL32 to display a list of DLLs. Select SQLORA8.DLL, and click Object > Apply as shown in Figure A-2:
  3. 3. In the Definition of ORACLE pane, click in the second column for VENDOR INIT, and enter OCI.DLL as the Vendor DLL file name.
  4. 4. In the Drivers and System pane, click the Databases tab.
  5. 5. Create a new Oracle database alias (right-click, select New, select the Database Driver Name ORACLE, and then OK) and rename the alias as appropriate.
  6. 6. In the Definition of AliasName pane, click in the second column for SERVER NAME, and enter your Oracle TNS.