Creating ODBC Connections

Overview

• Steps needed to create an ODBC connection for an SQL database in the Windows operating system.
• This is needed to connect Stone Edge to your SQL database.

Opening the ODBC Controller

1. In finder type “ODBC”
2. You may find 2 programs come up -> Click: “ODBC Data Sources (32-Bit)”
   NOTE: You may need to run this program as an administrator for the ability to make edits.

*If you cannot find the program though the search, you can also use this direct file path: “C:\Windows\SysWOW64\odbcad32.exe”

Set up the DSN (Data Source Name)

NOTE: You will need to setup an SQL server and database beforehand.

1. Click “System DSN” from the tabs at the top and click the “Add” button on the right to open the “Create New Data Source” pop-up.
2. Select a driver for the data source should be “SQL Server” near the bottom of the list.
3. Click “Finish” to open the “Create a New Data Source to SQL Server” pop-up
4. Enter the required fields on the initial screen:
   1. Create a “Name” for the ODBC connection, something you will remember.
      NOTE: Every computer that connects to the database will need a DSN, so keep the naming consistent.
   2. Skip the “Description”
   3. The SQL “Server” to connect to is where the database is located.
      1. The same server name is used for logging into SQL Server Management Studio.
      2. If you choose the wrong server name, you will eventually get an error.
5. Click “Next” and choose a verification method for the login ID.
   1. The first option uses Windows Auth if enabled and setup prior on your SQL server. If you are not able to click “Next” to move to the next sceen it is not setup properly and you may need to check your server settings.
   2. The second, easier option is using SQL authentication. Enter the login ID and password you created to access the SQL database in SSMS.
6. Click “Next”. If you have the correct permissions the next screen should load.
   1. If it takes more than a few seconds, it most likely failed. You may need to try a different authorization method or change the “Client Configuration” from a Dynamic port to the Port number: 1433 (setup using SQL Server Manager).
7. Checkmark to “Change the default database” from “Master” to the database you created.

8. Click “Next” -> “Finish”
9. The “ODBC Microsoft SQL Server Setup” pop-up will appear reviewing your choices.
10. Click “Test Data Source…” on the bottom-left of the screen.
11. If the test comes back successfully (as a pop-up) click “OK” -> “OK” and you have finished the setup.
    1. If you are not able to get a successful message you may need to change your settings or check your network connection to the server.