Database Connection String Assistant

Top  Previous  Next

 VS   VB6   VB5   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, the keyboard shortcut associated with the MZTools8.DatabaseConnectionStringAssistant command.
     
  • In VB6 / VB5 / VBA, the keyboard shortcut associated with the Database Connection String Assistant feature.

The Database Connection String Assistant window is the following:

DatabaseConnectionStringAssistant

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:

Keyboard Shortcuts Options