The ADO .NET Connection String Assistant feature allows you to easily create connection strings for ODBC drivers, OLE DB providers or native .NET data providers.
MZ-Tools offers the following ways to show the ADO .NET Connection String Assistant:
- The MZ-Tools | Other Utilities | ADO .NET Connection String Assistant... menu.
- The Other Utilities | ADO .NET Connection String Assistant... button on the MZ-Tools toolbar.
- The keyboard shortcut associated with the MZTools6_VSXXXX.ADONetConnectionStringAssistant command.
The ADO .NET Connection String Assistant window is the following:
In this window you can select the database provider (the ODBC driver, OLE DB provider or native .NET data provider). The list of database providers is hard-coded. If you want to hide the database providers that are not installed on your machine, check the Hide database components not installed on this computer checkbox.
Once you have selected a database provider, you can edit the settings of the connection string, such as the data source, user id, etc. These settings vary by database provider.
Finally, you can test the connection string, preview it, insert it into the current document or copy it to the clipboard.
See Also: