Before you can use OpenESQL Assistant to generate SQL, you must first connect to the data source that contains the data you want to access. All data sources cataloged on your workstation are listed in the tree view of the OpenESQL Assistant. You can connect to one data source at a time. After you have connected, all of the table names in the data source show on the tree view.
Note:
- You can use the ADO.NET Connection Editor to catalog other data sources as ADO.NET data providers. See the chapter ADO.NET Connection Editor for more information.
- If you receive a connect error when running in ADO.NET mode, OpenESQL Assistant prompts you for your User ID and Password if you don't want to save the informationin Options or in the data source information saved by the Connection Editor