Creating ODBC Connections

Contents of this Topic: ShowHide

Overview

This document outlines the manual steps to create ODBC connections for an SQL database in the Windows 7 environment as it relates to connecting a Monsoon Order Manager data file to external shipping software applications, or to connect additional workstations to a new SQL data file that was converted from Microsoft Access.
If ODBC connections are made manually on a 64-bit operating system, please read the Knowledge Base article, Windows 64-bit Operating System Considerations before proceeding.

Create an ODBC connection to a Microsoft SQL Server database in Windows 7

Select the Start Menu.
Select Control Panel.
Select System and Security.
Select Administrative Tools and double-click Data Sources (ODBC).
Select the System DSN tab.
Select Add.
Select SQL Server from the drivers list and select Finish.
The next screen as you to enter a name for the data source. Make it a meaningful name, such as OMSDataFile or OMSStoreNameDataFile name, if more than one data file is used. Make a note of the name entered here, as it will be needed in future steps. Enter a brief description of the connection, as well. Select the appropriate instance of SQL Server with which to connect. It is possible to type in the name if it is not in the drop-down list.
Select Next.
The next screen asks for information about the method of authentication used to connect to the data base. This topic describes the method recommended by Monsoon Commerce, however, check with your system administrator about the proper settings for your environment.
Select With Windows NT authentication using the network login ID and password.
Connect to SQL Server to obtain default settings for the additional configuration options. should already be selected.
Select Next.
Select the Monsoon Order Manager store file from Change the default database to : and leave Use ANSI quoted identifiers. and Use ANSI nulls, paddings and warnings. selected.
Select Next.
Leave Perform translation for character data selected.
Select Finish.
Select Test Data Source to verify the connection. You should see the message " Tests Completed Successfully!".
Select OK three times to exit the dialog.

Additional information

Windows 64-Bit Operating System Considerations

Windows 7

Created:

Revised: 7/6/15

Published: 08/19/15