Register a Database

Previous  Top  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:

ODBC
ADO

 

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

 

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.

 

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.