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.