Support Articles

Set up ODBC without using Linked Table Manager
Last Updated 4 months ago

Q: How do I set up an ODBC connection outside TRAIN TRACK?

A: To set up an ODBC connection, please follow these steps:

  1. From the Windows Control Panel, select Administrative Tools > ODBC Data Sources (32-Bit).
  2. A pop-up window will open. Select the "User DSN" tab.
  3. Click "Add".
  4. Scroll to the bottom and select "SQL Server Native Client" (or just "SQL Server" if you don't see the native client).
  5. Click "Finish".
  6. Type in the Name "TTSERV".
  7. Type in (or select) the name of your server where the database is installed.
  8. Click "Next".
  9. Select "Integrated Windows authentication" and click "Next".
  10. Check "Change the default database to" and select TRAINTRACK.
  11. Click "Next".
  12. Click "Finish".
  13. Click "Test Data Source".
You should see a message that the test was successful. If not, go back and confirm that you have the correct server name, and that the Windows user has permission for the database.

Please Wait!

Please wait... it will take a second!