- Start the ADO.NET Connection Editor.
- From the
(Settings) menu, set each option as required to define the new connection. For a description of each option, see
Add to start the Add an ADO.NET Connection wizard.
- Type a data source name into the
Data Source Name field; then click
- Do one of the following to filter the list on the
.NET Data Providers grid:
- To view only the catalogued ADO.NET data providers, select
- To view both the catalogued ADO.NET and ODBC data providers, select
- Select the data provider that you want to use; then click
Depending on your provider selection, the wizard progresses to the Provider Connection Details, ODBC Data Providers, or OLE
DB Data Providers page.
- For .NET providers, continue to the next step. For ODBD and OLE DB providers, do one of the following:
- For ODBC providers, select an ODBC DSN on the
ODBC DSNs list; then click
- For OLE DB providers, select an OLE DB provider from the list; then click
- On the Provider Connection Details page, specify additional connection settings or modify default connection settings as required;
Note: Depending on the selected provider, this page shows all or some of the available connection settings including those required
to connect. You can adjust all connection settings from the main window of the ADO.NET Connection Editor. See the context
help located at the bottom of the main window for a description of each setting.
- Review your connection settings; then click
Finish to create and catalog the connection.
- On the ADO.NET Connection Editor main window, adjust connection settings values as appropriate for your environment. Optional.
Test to test your connection. Optional.
Note: Alternatively, right-click the connection and select
Test Connection from the context menu.
- Close the ADO.NET Connection Editor.