Requirements
Before attempting this tutorial, you must complete
Tutorial: Create a SQL Server Database.
Create the Connection
- Start
Studio Enterprise Edition as an administrator from
Start > All Programs > Micro Focus Studio Enterprise Edition x.x > Microsoft Visual Studio 2008.
- From the Visual Studio IDE, click
Tools >
Micro Focus COBOL Tools > HCO for SQL Server Tools.
- From the HCO for SQL Server interface, click
Manage Connections.
- Select the
User Connection Type.
- From the
Connection List tab, click
New SQL Server Connection. This takes you to the
SQL Server Connection tab.
- In the
Data Source Name field, type
HCODemo.
- Click
Integrated Windows Authentication to select it. This means that SQL Server uses your Windows logon credentials to access the database.
- In the
SQL Server Instance field, type the name of your SQL Server instance. If you have a default instance, this could be
. or
(local). If you have a named instance, use the combined server name and instance name. For example:
mysqlserver\myinstance.
- Click
Confirm Server to confirm that HCOSS can locate your specified SQL Server Instance.
- Check
Use a database other than the default database:.
- From the
Database drop-down menu, select the
HCO_Test destination database that you created in SQL Server 2008 Management Studio.
- Click
Test. If the test fails, review your field entries, make corrections accordingly, and try again. When you have a successful connection, click
OK.
- Click
Save to save the connection. This takes you back to the
Connection List tab where you should now see your SQL Server connection listed.
This completes the tutorial. Next, please complete
Tutorial: DB2 Database Migration.