ODBC 32bit Connection Windows 7

I am trying to setup an ODBC 32bit connection on a Windows 7 64bit client to access a SQL server.  I am aware about the differences between the installed 64bit ODBC and the Syswow 64 bit / 32bit client connection.  The problem is when I try to setup the connection I am not seeign the server in the pull down list.  Can anyone help?  I have added ODBC 32bit to the firewall policy just to make sure.
Beavish1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

elawadCommented:
if you write the server name in the odbc doe it connect to it ?
0
Beavish1Author Commented:
No I have tried that aswell and this is the error I receive:

Connection failed:
SQL state: '010000'
SQL Server Error: 231
[Micorosft](ODBC SQL Server Driver)[DBNETLIB]ConenctionOpen
(Connect()).
Connections Failed:
SQL State: '080001'
SQL server error: 17
[Micorosft](ODBC SQL Server Driver)[DBNETLIB]ConenctionOpen

0
elawadCommented:
if you nslookup on the server name from this pc do u get the correct response of the server ip address.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Beavish1Author Commented:
Yes it does and also resolves by ip to name
0
elawadCommented:
make sure that the sql server is functioning and healthy, could you turn off the firewall and try.
0
adiloadiloCommented:
verify that the  this sql server has a named instance. On services you'll see the sql server as MSSQL$instancename, so, in this case, your sql server is "servername\instance" and all strings you'll have to connect using servername\instancename as a name of this server.
Also Turn enable remote connections on firewall options in windows 7 . Then, enable "file and print sharing". this must be done on the sql server too .
0
senadCommented:
' I am aware about the differences between the installed 64bit ODBC and the Syswow 64 bit / 32bit client connection.'
Are you sure ?
ODBC Syswow 64 bit you must use and make FW exception for it.
Try disabling the FW just to check if it functions ok...
0
grayeCommented:
Just to make sure...   Are you sure you've used the 32-bit version of the ODBC utility (C:\windows\SysWow64\odbcad32.exe)
0
senadCommented:
There is no x64 version....They are both x32.
0
grayeCommented:
No senad, that's not correct...   yes, they both have "32" in the name, but the one in C:\Windows is indeed the 64-bit version, whereas the one in C:\Windows\SysWow64 is the 32-bit version.
0
senadCommented:
cp..
It’s important to understand which kind of DSN you have. On an x64 system, you can create an ODBC connection(DSN) on the 32-bit side of the system or on the 64-bit side of the system.
32-bit applications will only see ODBC connections created in the 32-bit side, and 64-bits applications will only see ODBC connections from the 64-bit side. Each kind of application has is own registry.To setup DSN for 32-bit application you must use:
%WINDIR%SysWOW64odbcad32.exe
and for 64-bit application you must use:
%WINDIR%System32odbcad32.exe
0
senadCommented:
A 64-bit version of the Microsoft Windows operating system includes the following versions of the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe):
• The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%WindowsSysWoW64 folder.
• The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%WindowsSystem32 folder.
The Odbcad32.exe file displays the following types of data source names (DSNs):
• System DSNs
• User DSNs
0
Beavish1Author Commented:
I have checked that an instances is configured and available.
0
grayeCommented:
So, you can create an ODBC connection using the ODBC Data Sources tool... and you can test this connection, and it works?  Is that correct?   And you can perform these steps using both the 32 and 64 bit versions of this tool... and they both work?
So what kind of application are you using that requires this ODBC connection?
Is the application a 32-bit or 64-bit (or perhaps a .Net hybrid that does both)?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
senadCommented:
if you are doing an application then you access SQL server directly with your connection component (like ADO) and not via ODBC.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows 7

From novice to tech pro — start learning today.