- Specify the source of data
Use data source name: Select or enter the ODBC data source name (DSN) that you want to access.
Use connection string: Allows you to enter or build an ODBC connection string rather than using an existing DSN.
Build: Opens the ODBC Select Data Source dialog box. Once you select a data source, the connection string in that data source will be returned and set into the connection string edit control. If you select a File DSN, then the resulting ODBC connection string is DSN-less. The ODBC connection string is persisted in the data link (.udl) file and does not rely on the selected File DSN. If you select a Machine DSN, then the resulting ODBC connection string is DSN-based. The ODBC connection string references the selected Machine DSN. If a user on a different system attempts to access the data link (.udl) file, the user must also have the Machine DSN installed.
- Enter information to log on to the server
User name: Enter the User ID to use for authentication when you log on to the data source.
Password: Enter the password to use for authentication when you log on to the data source.
Blank password: Enables the specified provider to return a blank password in the connection string.
Allow saving password: Allows the password to be saved with the connection string. Whether the password is included in the connection string depends on the functionality of the calling application.
Note: If saved, the password is returned and saved unmasked and unencrypted.
- Enter the initial catalogue to use
Enter the database that you want to access.
Test Connection: Click to attempt a connection to the specified data source. If the connection fails, ensure that the settings are correct. For example, spelling errors and case sensitivity may be the cause of a failed connection.
Ensure you use Test Connection button before you continue.
