Skip to content

ODBC DSN Sets on MS Windows 64b OS

April 8, 2014

Nowadays, it is common practice to work on 64b MS Windows OSs and run 64b or 32b application on those platforms. Some of those applications connect to databases through ODBC. To properly configure communication using ODBC, it is important to understand the different sets of ODBC Data Sources Names (DSN) that can be created on a MS Windows 64b and when each of those set are use.

In MS windows OS 64b there are 2 ODBC data source administrators, each of them manage 2 sets of ODBC Data Source Names (DSN).

The default is the 64b ODBC data source administrator. This can be invoked using the Data Sources (ODBC) link from the Administrative Tools group in control panel and manage the following 2 sets of ODBC DSN:

  1. The 64b ODBC DSN on the user DSN tab: These are the DSN use for any 64b application running on the machine, they are only accessible to the user that was login when the DSN entries where created, no other user can see or use those DSN.
  2. The 64b ODBC DSN on the System DSN tab: These are the DSN use for any 64b application running on the machine; they are accessible to any user that connects to machine.

     

The 32b ODBC data source administrator need to be manually invoked executing ‘C:\Windows\SysWOW64\odbcad32.exe’; this manage the following 2 sets of ODBC DSN:

  1. The 32b ODBC DSN on the user ODBC tab: These are the DSN use for any 32b application running on the machine, they are only accessible to the user that was login when the DSN entries where created, no other user can see or use those DSN.
  2. The 32b ODBC DSN on the System DSN tab: These are the DSN use for any 32b application running on the machine; they are accessible to all users login on the machine.

 

It is not recommended to save usernames and passwords on the systems DSN, instead, provide them from the invoking application.

Advertisements

From → ODBC

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: