solving sql server problems for millions of dbas and developers since 2006

Top SQL Server Tools

dbForge SQL Complete

SQL Monitor

SQL diagnostic manager

SQL Sentry Performance Advisor for SQL Server

SQL safe backup

Create a 32-bit DSN on 64-bit machine for SQL Server

By: Jugal Shah | Read Comments (7) | Print

Jugal has 8+ years of extensive SQL Server experience and has worked on SQL Server 2000, 2005, 2008 and 2008 R2.

Related Tips: More

Problem

During the install of an application on a 64-bit Windows machine, the application was unable to list the ODBC System DSN because it had been setup as a 64-bit DSN and the application needed a 32-bit system DSN for connectivity to SQL Server. In this tip, we cover how to create a 32-bit DSN on 64-bit machine.

Solution

Before creating the DSN make sure the SQL Server Native client component is installed on the machine. You can install the SQL Server native client either from the SQL Server media or by downloading it from http://www.microsoft.com/download/en/details.aspx?id=16978.

Below are the steps to create a 32-bit DSN on a 64-bit machine.

Step 1
On the 64-bit machine where the application is installed, open the Microsoft Windows ODBC Data Source Administrator using one of the methods shown below.

Open C:\WINDOWS\SYSWOW64\odbc32.exe or type %systemdrive%\Windows\SysWoW64\Odbcad32.exe in the Run window.

syswow64 odbc

Step 2
Select the System DSN tab and click on the Add... button.

system dsn

Step 3
Select the SQL Server Native Client 10.0 from the list and click on the Finish button.

create new data source

Step 4
Specify the data source name, description and the SQL Server instance name. Click Next to proceed.

create new data source sql server

Step 5
Select the authentication mode as per the requirement. For SQL authentication, specify the SQL login name and password. Click Next to proceed.

create new data source sql server

Step 6
Select the desired application database from drop down list and click Next.

create new sql server data source

Step 7
Click on Finish and test the data source connectivity.

complete sql server odbc setup

Next Steps

Document the DSN details for the application connectivity
As you may have noticed, the real trick is running the 32-bit version of the ODBC Data Source Administrator

Related Tips: More | Become a paid author

Last Update: 9/22/2011

Share:

Free SQL Server Learning

Comments and Feedback:

Thursday, September 22, 2011 - 7:56:29 AM - Babji talluri	Read The Tip
Thanks jugal,Nice article!!

Wednesday, September 28, 2011 - 1:09:59 PM - Mike Washington

Read The Tip

How would this solution work for accessing an oracle 11g database via ODBC on win7 box? When I had win xp accessing the oracle 11g database via odbc but when I moved to win7 I could no longer access the oracle 11g database. Please help.

Thanks,

Mike

Thursday, September 29, 2011 - 1:03:37 AM - Jugal

Read The Tip

Hi Mike,

Are you getting any specific error while connecting to Oracle 11G through ODBC? Can you please share the error details. Please check the below items as well.

1. Firewall is not blocking the port required for Oracle 11G.

2. Check the ODBC driver or Oracle client component is installed on your Win 7 Box

3. You are able to ping the Oracle Machine from Win 7

4. Account has proper access to Oracle database

Friday, September 30, 2011 - 12:54:51 PM - Mike Washington

Read The Tip

Jugal:

When I attempt to perform a ODBC test connetion to the oracle 11g database I received an error message indicating I needed to install the oracle driver eventhough I had installed the oracle driver.

Mike

Friday, September 30, 2011 - 1:52:14 PM - Mike Washington

Read The Tip

Jugal:

1. Firewall is not blocking the port required for Oracle 11G. The firewall is open and the actual version is 10g (sorry for the confusion about the version being used).

2. Check the ODBC driver or Oracle client component is installed on your Win 7 Box. The client version is installed on the win7 box.

3. You are able to ping the Oracle Machine from Win 7. I can ping and log into the oracle machine from the win7 box.

4. Account has proper access to Oracle database. Yes.

The actual message that I get is the folowing:

The Oracle(tm) lcient and networking components were not found. These components are supplied by oracle corporation and are part of the Oracle Version 7.3 (or greater) client software installation. You will be unable to use this driver until these components have been installed.

With that being said, I'm not sure or completely understand why I have received that message even after installing Oracle 10g administrator option on the win7 box... Any and all help is greatly appreciated.

Thanks,

Mike

Sunday, October 02, 2011 - 11:40:19 PM - Jugal

Read The Tip

Hi Mike,

As per the error message, you have to install the client components (which will install the Oracle driver).

Thanks,

Jugal Shah

Monday, January 09, 2012 - 8:45:33 PM - Armena	Read The Tip
I'm not wohrty to be in the same forum. ROTFL

Sponsor Information

Try the award winning SQL diagnostic manager as a free 14-day trial!

The 10 tools in the SQL Developer Bundle cut the time spent in dull and tedious tasks. Learn more.

SQL Servers keeping you up at night? Contact expert SQL Server consultants for a Health Check.

Find and Fix SQL issues with Foglight Performance Analysis. Get a free copy.

Join the over million SQL Server Professionals who get their issues resolved daily.

Learn SQL Server 2012, Performance Tuning, Development, Administration, Replication and more - free webcasts