3. Click on the drop-down handle for Server name.
SQL Servers on the computer should show up here. For a local server a "."
may be used for the server name (127.0.0.1 is also acceptable). The local
server is set for SQL Server authentication, which requires both User name:
and Password.
4. Type in a "." for the Server name as well as the User name and Password that
you use for authentication in the respective fields.
If the information is correct, you will be able to display all the databases on
this server.
5. Click on the drop-down handle for the field Select or enter a database name:
in the Connect to a database area.
A list of all the available databases will be displayed as shown below.
SqlClient Data Provider is the provider that brings data fastest from an SQL
Server 2005. You can test the connectivity using the Test Connection button,
which will display a message saying the connection was successful.
Transferring Data to a Text File
[ 90 ]
6. Click on the OK button on this screen.
7. Click on the OK button on the Configure ADO.NET Connection Manager
window, shown in the previous screenshot.
A connection manager, Localhost.MyNorthwind.sa, will be added to the
Connection Manager's page.
Step 3: Configuring the Source
Right-click the DataReader Source, in the drop-down menu, choose Edit??¦. This
opens the Advanced Editor for DataReader Source, as shown below. First, you need
to indicate a connection manager that the DataReader can use.
Pages:
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77