Knowledge Base

Home > How To > How to add a ODBC data source

Created
Modified

Print Article

Article 2686

How to add a ODBC data source

Howto

  1. Go to Control Panel
  2. Select Administrative Tools
  3. If you are using the 32-bit version of the application, select ODBC Data Sources (32-bit)
    If you are using the 64-bit version of the application, select ODBC Data Sources (64-bit)
  4. Select the User DSN tab
  5. Click Add...
  6. Select the driver from the list
  7. Click OK and fill out all the data for the data source

Notes

  • Unicode vs. Ansi
    If you have the choice between an Unicode or an Ansi driver, you need the Unicode driver.
  • SQL Server Native Client vs SQL Server driver
    Prefer the SQL Server Native Client over the SQL Server driver 

ODBC Drivers

Keywords

Related Articles


Please choose 1 to 5 whether this article solves your problem.

1 No Help at all

5 Problem Solved

Saving...
Thank you for your feedback.

What do you think about this topic? Send feedback!