Within the Connection tab you can set the connection properties.
In order to set the connection properties correctly, follow the steps below.
- Type in the source server name, or select one from the drop-down list. You can get the actual server list by clicking the Refresh button.
- Depending on the preferable way to log on to the server, you can specify either Use Windows NT Integrated security or the database server account. If you have specified the specific server account to be used, enter User name and Password in the corresponding fields.
- Select a database on the server or specify the Microsoft database file (*.mdf) which will be attached as a database.
Note: The set of available Connection options depends on the selected Ole DB Provider.
If you have selected Microsoft OLE DB Provider for ODBC Drivers the Connection tab is the following.
Click the Test Connection button to see if your connection settings are specified correctly.
Use the Advanced and the All tabs of the dialog to access the corresponding pages available for the specified data source.