Micro Focus Studio Enterprise Edition Test Server > Programming > Data Access > Database Access > OpenESQL > Programming for OpenESQL > OpenESQL Assistant > Using OpenESQL Assistant > Connecting to a Data Source

Connecting to a Data Source

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 only 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.

Important: You must connect to a 32-bit data source even if the generated application targets a 64-bit platform.

If you are running in ODBC mode and have checked the Automatically catalog data source on CONNECT option for OpenESQL Assistant, all ODBC data sources on your workstation are automatically cataloged as an ODBC ADO.NET data provider. See your Microsoft documentation for information on setting up ODBC data sources.

Note:

You can use the ADO.NET Connection Editor to catalog other data sources as ADO.NET data providers.
If you receive a connect error, OpenESQL Assistant prompts you for your User ID and Password if you don't want to save the information with connection settings.