Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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

asked 15 Jun '11, 09:18

visiperl's gravatar image

accept rate: 0%

edited 15 Jun '11, 14:59

Graeme%20Perrow's gravatar image

Graeme Perrow

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

(15 Jun '11, 11:32) Martin

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!

permanent link

answered 15 Jun '11, 12:53

Graeme%20Perrow's gravatar image

Graeme Perrow
accept rate: 54%

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

(15 Jun '11, 14:58) visiperl
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 15 Jun '11, 09:18

question was seen: 2,863 times

last updated: 15 Jun '11, 14:59