Set up the ODBC Data Source

Before configuring an ODBC data source to work with Remote Link, create a new ODBC data source on the user's workstation. Any user created to be used for SQL Server authentication must have permission to read, write, modify, and delete all tables.

Note: If setting up the DSN on a Windows 7 64-bit system you need to use a 32-bit version of the ODBC configuration utility. The executable odbcad32.exe is in C:\Windows\System32\.

Add a System DSN for SQL Server

1. Go to Control Panel > Administrative Tools > Data Sources (ODBC).

2. Go to System DSN.

3. Select Add.

4. In Create New Data Source window, give the data source a Name and Description. Make note of the name you assign.

5. Select the server from the dropdown. If you are running SQL Server Express, add \SQLEXPRESS to the end of the server name. It may also be necessary to add the port 1433 at the end of the name. For example, MY_SERVER_NAME_OR_IP_ADDRESS\SQLEXPRESS,1433

6. Select Next.

7. Consult with your database administrator to determine whether to use SQL Server Authentication. If using SQL Server Authentication, use the Login ID and Password provided by the administrator.

8. Select Next.

9. Change default database to the Remote Link database.

10. Select Next, then select Finish.

11. Test the data source.