How do I create a new ODBC connection?

  1. Select Start > Settings > Conntrol Panel > Administrative Tools > Data Sources (ODBC).
  2. Select the System DSN tab.

    DSNSet1
  3. Select SQL Server (SQL Server 2000 database) or SQL Native Client (SQL Server 2005/2008 database).

    DSNSet2
  4. Click Finish.
  5. Enter your DSN Name, Description and Server name. NOTE: DO NOT use (local) for the Server name if it is an option!

    DSNSet3
  6. Click Next.
  7. Take all the defaults on the next screen.

    DSNSet4
  8. Check the box next to Change the default database to and select the database. NOTE: For simplicity this should match the DSN Name you entered in Step 5.

    DSNSet5
  9. Click Next.
  10. Take all the defaults on the next screen.

    DSNSet6
  11. Click Finish.
  12. Click the Test Data Source button. You should get a successful message. If not, please contact your network administrator.

    DSNSet7
  13. You are now ready to have this connection used with Freight.Ware.

Article ID: 40
Last updated: 30 Oct, 2019
Revision: 3
Installation & Upgrades -> How do I create a new ODBC connection?
https://faq.freightware.biz/index.php?View=entry&EntryID=40