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 ADO.NET) 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:
- You can use the ADO.NET Connection Editor to catalog other data sources as ADO.NET data providers.
- 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.
- 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.