3. Click on the New??¦ button.
This opens the Connection Manager's window that opens as a default
connection to the SQL Server 2005 using the SQL Native Client provider,
and as such this window has controls suitable to connect to an SQL Server.
However, to connect to an Oracle database we need to use a Provider for
Oracle, which is chosen using the drop-down menu item corresponding to
the Provider label on this page.
4. Click on the drop-down menu and choose the Microsoft OLE DB Provider
for Oracle, as shown in the next screenshot.
The next figure shows the Connection Manager's page as well as the result of
clicking the Test Connection button in the mini-step 5 to follow.
5. Enter Xe for the Server name, hr for username, and hr for password. Also
place a check mark for the Save my password check box.. Click on the Test
Connection button.
As the information supplied is correct, the connection to the Oracle 10G XE
was successful.
6. Click on the OK button on the Test Connection button generated message as
well as the Connection Manager window.
This will bring you back to the Configure OLE DB Connection Manager's
window. A new OLE DB Connection xe.hr gets added to the Data
Connections area in the left.
7. Click on the OK button on this window.
Chapter 13
[ 205 ]
This completes the connection manager setup for the Oracle 10G XE. A connection
manager xe.hr appears in the Connection Managers' page on the Canvas.
Step 3: Configuring the OLE DB Source
1.
Pages:
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151