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?