ODBC Setup

HelpID: 542422019

Navigation: Tools >> Setup >> Company >> Setup LabelLink. Then click the GoTo button >> Create ODBC

The Create ODBC Connections window can be used to create data sources to each company database with LabelLink installed. This window can only be opened by SA or DYNSA.

In addition to creating the ODBC connection, a SQL user named LABELLINK will be created, granted access to the databases when LabelLink is enabled, and given read-only access to the two SQL Views used by LabelLink (LabelLink and LabelLinkSLView). This SQL User will not have a password.

IMPORTANT: To create ODBC Connections, Dynamics GP must be “Run As Administrator”. If you wish to use this utility, close GP, then re-launch it by right-clicking on the GP icon, and select “Run As Administrator”.

Main Database: Enter the company that will be the primary user of LabelLink. The data source for the company entered here will be simply called “LabelLink”. Data sources for the remaining companies will contain the database ID, such as LabelLink_TEST.

Database: Displays the company databases that were marked for installation.

Data Source: Displays the data source name that is created by LabelLink when Create ODBC is clicked.

Status: Displays an icon to indicate if the connection was successful or not. If an exclamation mark displays, use the scrolling window “show detail” button to expand the line to show the issue.

IMPORTANT: At least one label report must be created per GP User/Workstation. This setup is Company-Specific, so if labels are printed from multiple companies the user will need different copies of the label report. Each label report, being company specific, will require an ODBC defined for that company database.

The following steps describe how to manually create an ODBC connection for use with LabelLink.

Open the ODBC Data Source Administrator (32-bit) window:

Click the ADD button to open the Create New Data Source window:

Select SQL SERVER NATIVE CLIENT. If multiple versions are present, choose the correct version for your SQL Server. Click the FINISH button.

Enter Name, Description, and select the Server. Click the NEXT button.

Select the “With SQL Server Authentication” option. Enter the SQL Login and click NEXT.

If you have not already done so, create a new SQL Server User ID called LABELLINK. We strongly recommend that the User ID does NOT have a password as this will ensure labels can print without requiring the user to login. At a minimum, the SQL User will need Read permissions on two SQL Views: LabelLink and LabelLinkSLView. Your particular requirements may dictate that the user have additional Read permissions added on other tables, such as the Sales Header or PO Header.

Mark “Change the default database to” option, then select the Company Database. NOTE: if you will print labels from multiple companies you will need to create an ODBC for each company.

Leave all of the other options unmarked. Click NEXT.

Click FINISH.

Click TEST DATA SOURCE. If it is OK, click the OK button.