sql anywhere dropping connection on local machine

[Former Member]

We have a client that is running our application on the same machine that dbsrv11.exe is running on. She is getting disconnected frequently from the server ONLY on this machine. The other machines on the network continue to operate fine. I was unable to find any internet security that would conflict (ie norton / mcafee). She is running XP with Antivir and the OS firewall with the exceptions for sql anywhere. It seems to happen several times a day. This is not the first time I've seen this particular phenomena. Has anyone else seen this and if so, found a solution?

Thanks, Ken

[MCMartin]

Have you tried to connect via shared memory on this machine, instead of TCP/IP?

[graeme_perrow]

Add -z -o server.out to the server's start line then check the server.out file when it happens. There may be something in that file that will tell you why the connection was dropped.

If that doesn't show you anything, you can try adding ;LOG=client.out to the client's connection string, and then check the client.out file.

Remember to remove the extra server switches / connection parameters later!

[Former Member]

Thank you, we will test over the next day or so to see what happens with these parameters.