From your desktop, click
Start > All Programs > Micro Focus Enterprise Developer > Data Tools > Data Connections > ODBC Data Source Administrator (32-bit).
Note: If using Windows 8 or later, press the
Windows key on your keyboard and type
ODBC Data; then select
ODBC Data Sources (32-bit).
In the ODBC Data Source Administrator, click the
System DSN tab.
Click
Add.
On the
Name list, select
SQL Server; then click
Finish.
On the Create a new Data Source to SQL Server page, type
SQLCLRTutorial into the
Name field. This is the data source name.
In the
Server field, type
. (dot) to represent your local server; then click
Next.
Here, you can optionally change the default authentication method from Windows authentication to SQL Server authentication.
To change the authentication method, click
With SQL Server authentication.... (Optional)
Click
Next.
Check
Change the default database to; then type
SQLCLR_Test into the accompanying field.
Click
Next, then
Finish.
On the ODBC Microsoft SQL Server Setup page, click
Test Data Source.
Once the tests complete successfully, click
OK to exit.
Click
OK to close the ODBC Data Source Administrator.