On the
Connection tab, select a
Connection Type and
Connection Availability for this connection; then click
Add.
On the
Provider tab, click the ADO.NET data provider that you want to use, then type a data source name into the
Data Source Name field. All data providers installed on your machine appear on this list.
If you want the connection settings for your data source to be encrypted in the repository, check
Encrypt connection settings. Optional.
Click
Next. This automatically saves your new connection information.
Do one of the following:
If your ADO.NET data provider is an OleDb provider, the Microsoft
Data Link Properties dialog box appears. Select an OLE DB provider from the
Provider tab. Depending on the provider you select, you might need to also select a data source and set security on the
Connection tab, then click
OK. For more information, click the
Help button on the dialog box.
Note:
If the Data Link Properties dialog box provides a
Test button for your data provider, we recommend that you click it to test the connection. If the connection fails here it will also fail in ADO.
If your ADO.NET data provider is not an OleDb provider, proceed to step
7.
On the
Connection tab, ensure that each default value listed in the
Value column is valid, editing incorrect values when necessary. If you make changes, click
Save.
