Configure an ODBC connection using ODBC administrator.
Start
Studio Enterprise Edition as an administrator.
Set the OpenESQL Assistant
Mode option to
ODBC.
Set the
Automatically catalog data source option to
True.
Start the OpenESQL Assistant from within the Visual Studio IDE, or start it from the
Start menu as an administrator.
From the tree view, check the box next to the data source you want to catalog.
This imports the connection details into the ADO.NET Connection Editor, and the connection remains available to the OpenESQL Assistant even when the
Mode option is set to
ADO.NET.
Alternative method:
On a machine where the ADO.NET Connection Editor is installed and that has an ODBC connection already cataloged, start the ADO.NET Connection Editor as an administrator.
Export the ODBC connection.
On the machine where you want to add the ODBC connection, start the ADO.NET Connection Editor as an administrator.