Question Re: sql anywhere dropping connection on local machine in Technology Q&A

sql anywhere dropping connection on local machine

Former Member — Wed, 15 Jun 2011 09:18:19 GMT

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

Re: sql anywhere dropping connection on local machine

MCMartin — Wed, 15 Jun 2011 11:32:02 GMT

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

Re: sql anywhere dropping connection on local machine

graeme_perrow — Wed, 15 Jun 2011 12:53:50 GMT

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!

Re: sql anywhere dropping connection on local machine

Former Member — Wed, 15 Jun 2011 14:58:13 GMT

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