VS VB6 VBA
The Database Connection String Assistant feature allows you to easily create connection strings for native .NET data providers, OLE DB providers or ODBC drivers.
MZ-Tools offers the following ways to show the Database Connection String Assistant:
- The MZ-Tools | Other Utilities | Database Connection String Assistant... menu.
- The Database Connection String Assistant button on the MZ-Tools - Other Utilities toolbar.
- In Visual Studio 2015 and higher, the keyboard shortcut associated with the MZTools.DatabaseConnectionStringAssistant command.
- In Visual Studio 2013 and lower, the keyboard shortcut associated with the MZTools8.DatabaseConnectionStringAssistant command.
- In VB6 / VBA, the keyboard shortcut associated with the Database Connection String Assistant feature.
The Database Connection String Assistant window is the following:
In this window you can select the database provider (native .NET data provider, OLE DB provider or ODBC driver). Each list shows the actual providers installed on your machine.
Once you have selected a database provider, you can edit the settings of the connection string using the Build... button, which shows a window that depends on the selected provider.
Once you have the connection string you can insert it into the current document or copy it to the clipboard.
See Also: