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


What do you think about this topic? Send feedback!