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.


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 button to define one.


You can use the Test button to try to connect to the datasource 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 button next to the Connectstring edit box, you can select an ADO "data link" file, or "build a connect string".

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


ADO Build Connect String dialog

The first thing you need to do, is select the right OLE DB Provider from he dialog, then use the Next button. What is shown next, is data provider dependent.