As an alternative to the Manage Connections tool, you can also establish appropriate connections using a combination of the Micro Focus ADO.NET Connection Editor and the Microsoft ODBC Data Source Administrator tool. This can be useful if you want to fine-tune your connection settings, including those that are set to defaults when you use the Manage Connections tool.
If you choose to use the ADO.NET Connection Editor and Microsoft ODBC Data Source Administrator to create and catalog your connections, be aware that your development environment can affect your connections.
In 64-bit environments, Microsoft provides 32-bit and 64-bit versions of the ODBC Administrator tool. You might need to create 32- and 64-bit versions of some connections. Here are the scenarios and required connections necessary for using a connection with HCOSS tools:
| Scenario | Required Connections |
|---|---|
| Using HCOSS database migration tools in a 32-bit environment | 32-bit ADO.NET DB2 and ADO.NET SQL Server |
| Using HCOSS database migration tools in a 64-bit environment | 32- and 64-bit ADO.NET DB2 and ADO.NET SQL Server |
| Using HCOSS application migration tools in a 32-bit environment, and targeting a 32-bit environment (x86) | 32-bit ADO.NET SQL Server and ODBC SQL Server |
| Using HCOSS application migration tools in a 64-bit environment, and targeting a 32-bit environment (x86) | 32- and 64-bit ADO.NET SQL Server and 32-bit ODBC SQL Server |
| Using HCOSS application migration tools in a 64-bit environment, and targeting a 64-bit environment (x64) | 32- and 64-bit ADO.NET SQL Server and ODBC SQL Server |
To specify 32-bit and 64-bit connections, use the radio buttons provided on the ADO.NET Connection Editor Connection tab, and the corresponding Microsoft ODBC Data Source Administrator tool.
You can also launch the ADO.NET Connection Editor from the OpenESQL Assistant in Visual Studio.