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:
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:
After using the Next button, you will be presented with a page that allows you to enter the details for the selected connection type.
For ODBC, the following connection details will be shown:
ODBC connection details
You can use the Test button to try to connect to the datasource with the connection details you filled in.
To setup an ADO connection, the following details will be shown:
ADO connection details
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.