The OpenESQL Assistant must first connect to a data source before it can generate SQL. All data sources cataloged on your
workstation for the database type you have selected as your OpenESQL Assistant
Mode option (ODBC or XDB) are listed in the tree view of the OpenESQL Assistant. By default, the connection is made automatically after you select
a database from the tree view. After you have connected, all of the table names in the data source show on the tree view.
You can only connect to one data source at a time.
Important: You must connect to a 64-bit data source even if the generated application targets a 32-bit platform.
Note:
- If you have not provided a
User name and
Password in your OpenESQL Assistant options, you might receive a connect error. In this case, OpenESQL Assistant prompts you for your
User ID and Password.
- PL/I SQL queries are supported using ODBC database connections only.
- If you need to connect to an Access 97 format MDB file using a Microsoft Access ODBC driver, use the Microsoft Access Database
Engine 2010 Redistributable.