sql anywhere dropping connection on local machine

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

connection drop tcpip

asked 15 Jun '11, 09:18

visiperl
31●2●2●5
accept rate: 0%

edited 15 Jun '11, 14:59

Graeme Perrow
9.6k●3●79●124

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

(15 Jun '11, 11:32) Martin

flat view

One Answer:

active answers oldest answers newest answers popular answers

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 Perrow
9.6k●3●79●124
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

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "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

learn more about Markdown

Question tags:

connection ×157
tcpip ×13
drop ×9

question asked: 15 Jun '11, 09:18

question was seen: 2,544 times

last updated: 15 Jun '11, 14:59

SAP SQL Anywhere

sql anywhere dropping connection on local machine

Follow this question

Related questions