Register a Database

Top Previous Next

Using Databases | Register a Database will open the Register Database wizard.

The Register Database Wizard

After the Welcome page, you should select a data-source connection type. Currently, the following types are supported:

•

If you're using one of the specific database engine versions, you can connect to that particular database engine only, for information on how to connect, see:

•	Registering an InterBase database

•	Registering a Firebird database

•	Registering a MySQL database

•	Registering an Access database

After using the Next button, you will be presented with a page that allows you to enter the details for the selected connection type.

ODBC

For ODBC, the following connection details will be shown:

ODBC connection details

Alias	An user defined alias for use in the ADG.
ODBC Datasource	A system or user defined ODBC datasource at the local machine. You can use the button to define a new ODBC datasource name.
Username	The username, if required, to connect to the selected datasource.
Password	The password, if required, to connect to the selected datasource.
Description	A user written description for the given database.

You can use the Test button to try to connect to the datasource with the connection details you filled in.

Click here if you're not seeing your ODBC data sources on Windows 64 bit.

ADO

To setup an ADO connection, the following details will be shown:

ADO connection details

Alias	An user defined alias for use in the ADG.
Connect string	An ADO connect string. Use the ADO Wizard button to guide you through the process of creating a connect string.
Description	A user written description for the given database.

You can use the Test button to try to connect to the data source with the connection details you filled in.

An ADO connect string is a complicated thing to setup. Luckily, the Advanced Data Generator comes with a dialog that allows you to easily create a connect string. By using the ADO Wizard button, you can select a previously saved ADO "data link file", or "build a connect string".

Using the wizard will show a dialog similar to this one:

ADO Build Connect String dialog

Select the appropriate OLE DB Provider and use Next to enter the required information.

After registering a database, you can create a New Project.