[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1493
  • Last Modified:

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.
0
Beavish1
Asked:
Beavish1
  • 5
  • 3
  • 3
  • +2
3 Solutions
 
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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
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
 
senadCommented:
if you are doing an application then you access SQL server directly with your connection component (like ADO) and not via ODBC.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 5
  • 3
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now