ODBC - How to create a DSN connection in Windows

Windows Odbc Registry


A step by step guide on how to (configure|create) an DSN (data source name) connection on Windows with the ODBC Data Source Administrator application.

To configure a DSN on the Windows 64-bit platform, you must use the 32-bit ODBC Data Source Administrator.


  • Start > All Program > Administrative Tools > Data Source ODBC
  • Select the tab “System DSN” and click Add

You can choose also to create a DSN in the :

  • User DSN tab to restrict access to one user.
  • System DSN tab to restrict access to system users.
  • File DSN tab to allow access to all users on a network.
  • Depending of your data source, you must select the good driver.


  • For Excel : Microsoft Excel Driver

Windows Odbc Dsn

  • For Oracle 11g : Oracle in OraDb11g_Home1

Oracle Odbc Driver 11g

  • ….

If the driver isn't in the list, you must get it from the software provider and install it (except if you are on a 64 bit plateform, see the support section for more information.)

  • Enter the connection information if required and close the windows.


I don't find my driver on a 64 bit machine

Be careful if you want to install DSN with a 32 bit driver, you may have to launch the executable file odbcad32.exe in the 32 bit directory:


SysWOW64 contains all the 32-bit binary files required for compatibility, which run on top of the 64 bit Windows.

Indeed, you have two different environment and then two files :


Discover More
Essbase Eis Tbc Dsn Odbc
Essbase - Integration Service - Setting up the TBC sample application

To set up the Beverage Company sample application in integration service, you have two possibilities : automatically manually Log in the Oracle Database and perform this statement ...
Eis Meta Odbc
Essbase - Integration Services - OLAP Metadata Catalog

To create OLAP models or build metaoutlines with Integration Services, you must connect Integration Services to a database that contains metadata (the OLAP Metadata Catalog database). To make these connections,...
Obia Powercenter Topology
OBIA - Installation Version 7.9.6 with EBS, PowerCenter, Oracle Database on Windows

Roadmap To install and set up Oracle BI Applications, do the following: preinstallation steps for the source...
Obiee Connection Pool
OBIEE - Connection Pool

This articles regroups all the articles and talk the connection pool features of the BI Server such as: the connection script tab ... see below 10G 11G To automate connection pool changes...
Obiee Dsn Configuration 1
OBIEE 10G/11G - How to create an Analytics ODBC Data Source (System DSN ODBC connexion)

How to create an odbc DSN to be able to connect to the OBIEE BI Server ? On Windows XP (), go to Control Panel / Administration Tools and open “Data Sources ODBC”. Go to the “System DNS”...
Card Puncher Data Processing
ODBC - DSN (data source name)

When an ODBC based application connects to a database, it connects to a logical name, the Data Source Name (DSN), which identifies the datasource to which it wants to connect. Some external repository...
Card Puncher Data Processing
ODBC - Open Database Connectivity

In computing, Open Database Connectivity (ODBC) provides a standard software API method for using database management systems (DBMS). The designers of ODBC aimed to make it independent of programming languages,...

Share this page:
Follow us:
Task Runner