Kennisbank

1. Huis
2. How To
3. How to add a ODBC data source

Artikel 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

• MySQL
  http://dev.mysql.com/downloads/connector/odbc/
• SQLite
  http://www.ch-werner.de/sqliteodbc/
• PostgreSQL
  http://www.postgresql.org/ftp/odbc/versions/msi/
• Microsoft SQL Server
  ODBC drivers are automatically installed. 

Keywords
odbc

Gerelateerde Arikelen