Solved

Cannot create ODBC connection over the network

Posted on 2013-12-08
3
1,240 Views
Last Modified: 2013-12-16
I am using SQL Anywhere 7 and trying to create an ODBC connection from a client computer over the network to the Server running the SQL Anywhere Database.

I Cannot create an ODBC connection over the network (client to server) but same ODBC connection works fine locally on server.

SQL Anywhere server TCP/IP: Win7 32bit

IP:   192.168.1.201
SM:  255.255.255.0
DG:  192.168.1.1
DNS: 192.168.1.1

Client trying to access TCP/IP: Win 7 64 bit

IP:   192.168.1.200
SM:  255.255.255.0
DG:  192.168.1.1
DNS: 192.168.1.1

3. Windows firewall is turned off on both computers
4. I cannot telnet into the server SQL Anywhere port from the client like this:

telnet 192.168.1.201 2638

note (I CAN telnet into the server when telnet string shown above is called FROM the server computer)

5. ODBC to the SQL Anywhere DB works from the server computer but WILL NOT work  from the client computer to server computer. Note. I am using the 32 bit ODBC on the client since the server is a 32 bit installation.

Can anyone see what may be going on here?
0
Comment
Question by:Saxitalis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 30

Accepted Solution

by:
Britt Thompson earned 500 total points
ID: 39704619
Is it possible you have a firewall built-in to the antivirus that's still on? Or, av could be blocking the connection. I'm assuming you can access other resources on this server from the other machine? IE, a file share.
0
 

Author Comment

by:Saxitalis
ID: 39704701
Dang - that was a good idea...

AVG was installed on the server so I removed it. I also uninstalled Malwarebytes (the only other antivirus program)

1. Now there are NO antivirus programs running on the server (Also Windows firewall turned off)
2. The only computers on the network now are the SQLAnywhere Server  and one client (to connect via ODBX to SQLAnywhere server)
3. Other network communication between client and server (like ping network share mapping etc.) is good.
4. Still cannot telnet (telnet 192.168.1.201 2638) to the SQLAnywhere port on server from client over the network.
5. Telnet (telnet 192.168.1.201 2638) will open the SQLAnywhere port on server when run locally on the server.
6. I ran an ARP  -a from the client  and there are is only one entry for the mac address of the server and it is  the correct IP address

ODBC still does not work from over the network but still works locally on the server.

Am really stumped here...

Any other ideas?
0
 

Author Closing Comment

by:Saxitalis
ID: 39722333
It was Windows Firewall!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
On some Windows 7 (SP1) computers, Windows Update becomes super slow even the computer is reasonably fast.  There's one solution that seemed to have worked well for me (after trying a few other suggested solutions).
This Micro Tutorial will give you basic overview of the control panel section on Windows 7. It will depth in Network and Internet, Hardware and Sound, etc. This will be demonstrated using Windows 7 operating system.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question