Before you can use this product to deploy SQL applications developed for .NET managed COBOL with COBSQL, DB2 ECM or OpenESQL, ensure any third-party software prerequisites are installed and the environment is set properly.
- HCO for SQL Server (HCOSS)
-
- Microsoft SQL Server
- SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012, Developer or Enterprise Editions.
- Database Migration
-
- Microsoft OLE DB Provider for DB2, available in the SQL Server 2008 or 2012 Feature Pack
- Mainframe DB2
Note: We support only the mainframe DB2 versions that are currently under IBM support.
- Application Migration
-
- ADO.NET applications
- ADO.NET applications require either of the following combinations:
- SQL Server 2008 and SqlClient Data Provider in .NET Framework 3.5
- SQL Server 2012 and SqlClient Data Provider in .NET Framework 3.5 or 4.0 (4.0 is preferred)
- COBOL Stored Procedures
- See the requirements specified in the
SQL CLR Integration section below.
- OpenESQL
-
- Database access is supported using the OpenESQL preprocessor with applications compiled as .NET managed code to access relational databases using ODBC 3.0-compliant drivers. Refer to your driver vendor's documentation to determine whether your driver is suitable for use with OpenESQL.
- OpenESQL has been tested against the following ADO.NET data providers:
- Microsoft provider for SQL Server
- Microsoft provider for Oracle
- IBM DB2
- Oracle Data Provider for .NET (ODP.NET)
- OleDb
- Managed ODBC .NET providers
- Dynamic SQL using the SQL Descriptor Area (SQLDA) is not currently supported for OpenESQL applications compiled with the SQL(DBMAN=ODBC) directive.
