Registering a data source

Before you can work with a data source you must register it. To do this select the menu Datasource -> Register. The following screen will appear:

You will need to fill this in as follows:

Name

This is the name by which this connection will be known. It can contain spaces but it must be unique

DSN

This is the data source name as it is known in the ODBC settings

UID

This is the user name to connect to the database with

Password

This is the password to connect to the database with

VSS Project

This is the visual sourcesafe project that this data source is known by

Local directory

This is the local directory to store work in progress scripts

Modifying a data source registration

To modify a data source make sure it is the currently selected data source and select the menu Datasource -> Properties which will bring up the above screen populated with the current settings.

When you have made your changes press OK to accept them or press Cancel to exit this screen without saving your changes

Removing a registered data source

To remove a data source make sure it is the currently selected data source and select the menu Datasource -> Remove and press Yes to confirm this

You should keep the number of registered data sources to a minimum to improve the performance of the DBtool

Troubleshooting

The registered data sources information is held in the registry. If you are having problems with a registered data source and are unable to resolve them through the DBTool, open up the registry and navigate to the hive HKEY_CURRENT_USER\Software\VB and VBA Program Settings\DBTool and edit the settings directly.