This seems to be a problem which has developed only recently. Using SQL Anywhere version 11 build 2308 32 bit, on two separate customer sites (one using Windows 7 computers and one using XPs), I have had to add a HOST=xxx.xxx.xxx.xxx statement in the ODBC configuration to get the client computer to connect to the server. Then everything functions fine. These are simple two or three computer peer-to-peer networks. dblocate on the client can't find any servers but I can ping the server's IP address and connect with the HOST parameter. Windows Firewalls are on, and I have put entries to allow dbsrv11.exe both inbound and outbound. Any help would be appreciated. Thanks. |
The server discovery mechanism relies on UDP packets being propagated between servers and clients - if your firewall rules or network configuration do not permit broadcast UDP messages, the dblocate mechanism will fail to find any servers. Check to see if you can transmit UDP packets between the database clients and hosts. If you can't, you may be required to set up the Broadcast Repeater Utility (dbns11) across the networks in order to propagate server names. Otherwise, specifying the direct "HOST=" address would also resolve the issue. |
We've had that issue with a lot of client's PCs, solved it the way you did. It's possibly Win7 blocking UDP broadcasts used by the server engine to advertise it's service. We didn't bother delving into network and firewall details because applying HOST parameter did the trick easily. |
i've also found that if the db engine is on a different subnet, the host parameter is required |
It sounds like you've added the HOST parameter and everything is working. If dblocate cannot find the servers, then the HOST parameter is likely required. You seem to have solved the problem yourself. Can you confirm what problem you are still having?
Thanks all for the replies. That gives me something to look at. We want to avoid the HOST= parameter if at all possible as it requires our installations and updates to be user specific and a "generic" installation CD won't work.