Creating ODBC Connections in Microsoft Windows 7

In this Topic: Show

Overview

This document outlines the manual steps to create an ODBC connection to an SQL database in Windows 7.

If the ODBC connection will be 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

  1. Select the Start Menu.

  2. Select Control Panel.

  3. Select Administrative Tools and double-click the Data Sources (ODBC) icon.

  4. Select the System DSN tab.

  1. Select Add.

  1. Select SQL Server from the drivers list and select the Finish button.

  1. Enter a meaningful name for the data source, such as the name of the Stone Edge store file, or the name of the SixBit database. In this example, the Name is the store data file's name, Ajax Orders. 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. It is possible to type in the name if it is not in the drop-down list. Select  Next.

  1. Select With Windows NT authentication using the network login ID.

  1.  Select Next.

  1. Select Next again.

  1. Select the Finish button.

  1. Select the Test Data Source button to verify the connection.

  2.  You should see the message "TESTS COMPLETED SUCCESSFULLY!".

  1. Select OK button twice to return to the System DSN tab of the ODBC System Administrator screen.

  2. Select OK to exit the ODBC Data Source Administrator window.

 

Created: 6/6/14

Updated: 11/11/14

Go to Top