Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
Solved
Cannot create ODBC connection over the network
Posted on 2013-12-08
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?
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?
[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
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.
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?
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?
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
When you start your Windows 10 PC and got an "Operating system not found" error or just saw "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing. You will be panic as there are no back…
While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"!
Step 1: Open a new google tab
Step 2: Go to the left hand upper corn…
Suggested Courses
Course of the Month8 days, 18 hours left to enroll
721 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.