Guides you through the process of creating the HCODemo SQL Server connection to access the HCO_Test database.
- In
Visual Studio, click
View > Micro Focus SQL 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 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 concludes the tutorial.