I have an ODBC Connection set up from a client to a DB Server on the same network and it works fine.
It works fine until I change the subnet of the network that is...
1. If I have the client and Server set up on this network:
My ODBS Connects just fine but if I change to this network:
The ODBS Connection fails with this error:
SQLSTATE = 08001
[Sybase][ODBC Driver][SQLAnywhere]Database not found
**I can ping, remote into and browse files to each computer from the other so I know there is communication.
The weird thing is if I switch back to the first subnet (198.168.0.x), the ODBC works fine again! The only Difference is that the 192.168.4.x subnet is on the LAN side of a SOPHOS firewall (oth clients are on the LAN side of the firewall)
Does anyone know what is going on here?