- Start the ADO.NET Connection Editor.
- On the
Connection tab, select a
Connection Type and
Connection Availability for the connection you want to test. This populates the
Data Source Name list with connections that fit your selections.
- On the
Data Source Name list, click the connection you want to test.
- If your application requires a user ID and password to connect to a data source, type these into the
User ID and
Password fields. Optional.
- Click
Test Connection. A message box appears reporting the status of the connection attempt.
- Click
OK to clear the prompt.
Note: If your application requires a user ID and password to connect to a data source, then for security reasons, do not save the user ID and password in the
Connection Settings table. Information in those fields is used only to test the connection and is ignored when a CONNECT statement is executed. To provide your application with a user ID and password, pass the values as parameters in the CONNECT statement.
