Connect Information Step

If you selected the Remote(ODBC) format in the Database Type step of the Data Form Wizard, then the Connect Information step allows you to specify the ODBC information, such as a data source name (DSN), database, and driver.

The following procedures show different ways of connecting to a database through ODBC.

To connect to a database using a DSN that you have created

1. From the DSN drop-down list, select the name of your ODBC data source. (To create a data source, use the ODBC icon in the Windows Control Panel.)
   
   
2. If a user ID and password are associated with this data source, enter the information in the UID and PWD boxes, respectively.

To connect to a database using a generic DSN

1. From the DSN drop-down list, select the name of the generic data source, such as FoxPro Files.
   
   
2. In the Database box, enter the full path and name of the database file.

To connect to a database using a specified driver

1. In the Database box, enter the full path and name of the database file.
   
   
2. From the Driver drop-down list, select the driver you want to use, such as Microsoft FoxPro Driver (*.dbf).

To connect to a full server database

1. In the UID and PWD boxes, enter the associated user ID and password, respectively.
   
   
2. In the Database box, enter the name of the database.
   
   
3. From the Driver drop-down list, select the driver you want to use, such as SQL Server or Oracle.
   
   
4. In the Server box, enter the name of the server.

Click Next to specify details about the form to be created.