Previous Topic Next topic Print topic


Tutorial: Create a SQL Server Database Connection

Requirements

Before attempting this tutorial, you must complete Tutorial: Create a SQL Server Database.

Create the Connection

  1. Start Studio Enterprise Edition as an administrator from Start > All Programs > Micro Focus Studio Enterprise Edition x.x > Microsoft Visual Studio 2008.
  2. From the Visual Studio IDE, click Tools > Micro Focus COBOL Tools > HCO for SQL Server Tools.
  3. From the HCO for SQL Server interface, click Manage Connections.
  4. Select the User Connection Type.
  5. From the Connection List tab, click New SQL Server Connection. This takes you to the SQL Server Connection tab.
  6. In the Data Source Name field, type HCODemo.
  7. Click Integrated Windows Authentication to select it. This means that SQL Server uses your Windows logon credentials to access the database.
  8. 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.
  9. Click Confirm Server to confirm that HCOSS can locate your specified SQL Server Instance.
  10. Check Use a database other than the default database:.
  11. From the Database drop-down menu, select the HCO_Test destination database that you created in SQL Server 2008 Management Studio.
  12. Click Test. If the test fails, review your field entries, make corrections accordingly, and try again. When you have a successful connection, click OK.
  13. 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.

Previous Topic Next topic Print topic