Subject Re: [firebird-support] 10035 error
Author Helen Borrie
At 08:48 AM 30/01/2007, you wrote:
>I hope someone will be able to help me, I am getting no help from Napa
>Trac support. After installing XP SP2 on the computer hosting our
>FireBird database, we are receiving random error 10035 when doing
>testing. Connection refused.
>
> >TCP/IP Communication Test Failed!
>Found service 'tracs_DB' at port '3050'
> >Failed to connect to host 'x.
> >
> >TCP/IP Communication Test Failed!
>
>Every one in a great while, I can get it to connect, but it does not
>last. I know this has something to do with the WSAEWOULDBLOCK socket
>and tcp communications, but can find nothing on how to resolve.

Error 10035 is socket error WSAEWOULDBLOCK, it's true, and it means
that the socket is unavailable because a resource is not
available. That could be that something else has grabbed port 3050
but there could be other reasons why the connection request has to be refused.


>Thanks for any help...I have already upgraded to the latest version of
>Firebird.

You wrote:
"...installing XP SP2..."

What is the name of the database? If it has the suffix ".gdb" then
you have found the source of the problem. XP has a background
process called "SystemRestore" that targets files with the .gdb
extension. Whenever a request comes to open the file, XP immediately
locks the file and takes a disk image of it and stores it
somewhere. If the database file can't be renamed, you will have to
disable SystemRestore on the partition where the DB file resides.

Just as a reality check, did you uninstall the previous
version? Firebird 2 is a full release, not a point upgrade....many
changes....I have no idea what "Napa Trac" is but if it's some
software product with a Firebird backend, surely their support people
can't refuse to tell you whether it's certified to run with Firebird 2.x....

./heLen