Learn more about SQL Server tools

   
   















































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

MSSQLTips author Jugal Shah By:   |   Read Comments (8)   |   Related Tips: More > SQL Server Configurations
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


Last Update: 9/22/2011


About the author
MSSQLTips author Jugal Shah
Jugal Shah has 8+ years of extensive SQL Server experience and has worked on SQL Server 2000, 2005, 2008 and 2008 R2.

View all my tips
Related Resources


print tip Print  
Become a paid author





join MSSQLTips for free SQL Server tips     



Learn more about SQL Server tools
Post a comment or let the author know this tip helped you.

       All comments are reviewed, so stay on subject or we may delete your comment.

*Name   *Email Notify for updates



       Note: your email address is not published. Required fields are marked with an asterisk (*)


Get free SQL tips:

*Enter Code refresh code     



Thursday, December 19, 2013 - 9:25:12 AM - ndeye Read The Tip

Hi Jugal,

thanks for this post, very useful.

I'm not familiar with SQL.

I'm failing to install vmware update manager because it needs 32 bit DSN. I've tried to follow your procedure but I can't pass the step where the wizard connects to SQL server. It fails and i have 53 error code.

 

Could you help please.


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

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

 

 


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


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


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

 

 


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 22, 2011 - 7:56:29 AM - Babji talluri Read The Tip

Thanks jugal,Nice article!!




 
Sponsor Information