To set up a direct Oracle configuration using OLE DB
-
Click
dbConnect menu
Data
SourcesConfigure
.
At the command prompt,
enter DBCONNECT
- In the Data Link Properties dialog box, the Provider tab, select Microsoft OLE DB Provider for Oracle. Click Next.
- Enter the Oracle server name in Enter a Server Name.
- Enter a valid user name and password.
- Click Test Connection to verify that the settings are correct. For example, spelling errors and case sensitivity may be the cause of a failed connection.
- In the Microsoft Data Link dialog box, click OK.
- Click OK.
