Data Source Connections and Cataloging

Before you can use the HCO for SQL Server (HCOSS) tools, you will need to create DB2 and SQL Server database connections and then catalog those connections.

For DB2 on z/OS the recommended provider for establishing database connections is the Microsoft OLE DB Provider for DB2, which is available in the SQL Server 2008 Feature Pack download. For SQL Server 2008, the recommended provider for use with the HCOSS tools is the .NET provider for SQL Server (System.Data.SqlClient) which is available with the .NET framework. For application use at runtime the recommended provider is the Microsoft SQL Server 2008 Native Client ODBC driver (SQL Server Native Client 10.0).

Establishing a DB2 Connection using Microsoft OLE DB Provider for DB2

Follow these steps to establish a DB2 Data source connection using Microsoft OLE DB Provider:

Download and install the Microsoft OLE DB Provider for DB2.
Launch the Microsoft Data Access Tool from Start > All Programs > OLE DB Provider for DB2 > Data Access Tool.
Select File > New > Data Source. The Data Source Wizard appears. Click Next.
Enter an Address and a port number then click Next.
Enter an Initial catalog and Package. The Default qualifier and schema can be left blank. Click Next.
On the Locale page, make no changes. Click Next.
Leave Security method as “Interactive sign-on”. Enter a User name, and Password. Confirm the password then press Next.
On the Advanced Options page, make no changes. Click Next.
On the Validation page, click Connect. Confirm that the connection was successful by viewing the Output messaging. Click Packages, confirm that this operation was successful (make take a minute or two). Click Next.
Enter a data source name. Activate both Universal data link and Initialization options. Click Next.
Click Finish.
In the Tree view find your new Data Source name and highlight (click) it. From the Actions menu, select Display Connection String.
Make note of the information listed here. You can reference some of this information, which will be needed when cataloging the Data Source name with the MF ADO.NET Connection Editor.

Establishing a Microsoft SQL Server Connection

To establish a SQL Server connection you need to have SQL Server 2008 Enterprise or Developer Edition installed. Use the SQL Server Management Studio to create a database if you don’t have one created already. Then go into the Connection Editor and catalog the SQL Server database using the OleDB Provider type. You can setup "connection" to use no id/password by setting the “Integrated security” option to TRUE

Cataloging Data Source Connections

For cataloging the DB2 and SQL Server DSNs, use the Micro Focus ADO.NET Connection editor to create OleDB Providers.

Note: For the DB2 connection, most of the information needed by the Connection Editor will be identical to the information you provided when using the Microsoft OLE DB Provider for DB2 Data Access Tool. You can display this connection information from the Action menu > Display Connection String option.

You can access the ADO.NET Connection Editor in several ways:

From Windows Start menu All Programs > Micro Focus reUZE Developer 6.0 > ADO.NET Connection Tools > ADO.NET Connection Editor.
From the Visual Studio IDE Tools menu > Micro Focus COBOL Tools > Open ESQL Assistant. From the Assistant, click the green/black connection editor icon.

See theADO.NET Connection Editor topic in the Database Access Guide for details on setting up DSNs.

Note: If you have the HCOSS tools open while cataloging your DSNs you will need to close and reopen them (including Visual Studio) before they will show as options.