An Oracle oriented environment makes use of Oracle Provider for OLE DB in Oracle 11g.
Before you begin
You must have a valid
tnsnames.ora file in place to create and test the connection. If this has not been done, refer to the procedure for editing the
tnsnames.ora database connection file.
Procedure
- Create a new text document in your installation directory (C:\InfoShare) and name it connection.udl.
Note:
- Be sure that the file extension is .udl. If required, change your Windows Explorer settings to recognize the file extension. You have created a Universal Data Link file, which has a wizard-like program associated to create connection strings.
- Ensure that the filename was not appended with a .txt filename extension. If file name extensions are not visible, modify the Windows , and check that Hide extensions for known file types is not selected.
- Start the associated program by executing the command:
%WINDIR%\SysWOW64\cmd.exe /c START C:\InfoShare\connection.udl
The command window launched from SysWOW64 ensures that the 32-bit database provider in the wizard screen is found.
- Click the Provider tab, and select Oracle Provider for OLE DB.
- Click Next.
- Under the Connection tab, in the first field select or enter the data source. For example: ISH.WORLD.
The data source is the net_service_name entry in the Oracle_home\network\admin\tnsnames.ora file.
- In the second field, select the Use a specific username and password checkbox.
- In the User name field, enter isource.
- In the Password field, enter the password for the isource user.
The default password is isource. If you did not use the default password, be sure to enter the password used when you created the new user. The password was specified for the isource user when configuring the Oracle server.
- Select the Allow saving password checkbox.
- Test the connection by clicking Test Connection.
If the connection is valid, a message is displayed to notify that the connection is working correctly.
- Click OK to confirm.
This saves the password as plain text in the UDL file. If the connect string does not contain the password variable, no valid connections can be made with this connection string.