Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

restorig original TCP IP dll

Sep 15, 2007 2:20AM PDT

I have troubles with a database server (sql anywhere) over Vista Home Premium. When it starts a socket error occurs, it seems that the socket cannot be created and a never ending loop runs. The log file reports Error 10057 setting SO_UPDATE_ACCEPT_CONTEXT many times.
I would try to restore original dlls of TCP IP that are probably be overwritten by a Netgear Wireless Adapter.
How to do that?
Or there's another way to solve such a problem?

Discussion is locked

- Collapse -
MySQL running. However...
Sep 16, 2007 5:34AM PDT

I had to kill UAC and configure the firewall. Have you done that?

Bob

- Collapse -
MySQL running. However...
Sep 16, 2007 5:19PM PDT

Yes, Firewall and UAC was stopped before install of software. The SQL Anywhere server console reports:


Running Windows Vista Build 6000 on X86 (X86_64)
Server built for X86 processor architecture
2048K of memory used for caching
Minimum cache size: 2048K, maximum cache size: 1491064K
Using a maximum page size of 8192 bytes
Starting database "servoy_repository" (C:\Program Files\Servoy\database\servoy_repository.db) at Mon Sep 17 2007 09:04
Database recovery in progress
Last checkpoint at Mon Sep 17 2007 03:09
Checkpoint log...
Performance warning: Database file "C:\Program Files\Servoy\database\servoy_repository.db" consists of 47 disk fragments
Transaction log: servoy_repository.log...
Rollback log...
Checkpointing...
Starting checkpoint of "servoy_repository" (servoy_repository.db) at Mon Sep 17 2007 09:04
Finished checkpoint of "servoy_repository" (servoy_repository.db) at Mon Sep 17 2007 09:04
Recovery complete
Database "servoy_repository" (servoy_repository.db) started at Mon Sep 17 2007 09:04
Database server started at Mon Sep 17 2007 09:04
Trying to start SharedMemory link ...

SharedMemory link started successfully

Trying to start TCPIP link ...

Starting on port 2638

--------


So the database is open but the TCP IP connection stucks, the CPU goes to 100% usage and nothing more appens.
The same thing with the developer edition of SQL Anywhere, not only with Servoy.
I also tried to change the port, but still the same error.
If I tell to server not to use TCPIP the starting process goes to the end, but is not possible to connect to database.
So it seems that the problem is the socket creation, but why?

- Collapse -
I can't answer.
Sep 16, 2007 11:40PM PDT

Why? I don't have that issue here. I noticed you "stopped" the firewall rather than configure it. There is that Norton (and others?) firewall that keeps working when stopped. I wonder if you have one of those.

Bob

- Collapse -
Security
Sep 16, 2007 11:53PM PDT

I've a Netgear firewall that is configurated to assure security to all PCs on my LAN, and NOD32 for viruses.

- Collapse -
To me...
Sep 17, 2007 1:47AM PDT

It appears you don't have a full grip on the firewall issue. You noted the one in the router but don't respond about how you configured the UAC or the machine's firewall.

Sadly I don't think I can help you since you seem a little unfocused.

Bob

- Collapse -
firewall
Sep 18, 2007 4:42PM PDT

Firewall is a separate hardware. The UAC is down, as Windows firewall.
What is unfocused?

- Collapse -
Unfocused as in...
Sep 19, 2007 12:35AM PDT

You are not trying it the way others have found it to work. Since you are doing it your way and not configuring the firewall I can't compare notes.

Maybe you should try a newsgroup that is for MySQL as well.

It's like a formula. You change the formula and the results may not be the same.

Bob

- Collapse -
Unfocused as in...
Sep 21, 2007 3:19AM PDT

I unistalled SQL Anywhare, I activated Windows firewall, UAC and all security stuff, as are default. So I've installed sql Anywhare and the proplem still exactly the same.
I don't understand what should I ask in a mySQL forum, my problem is with sybase.

- Collapse -
Which is not what I did.
Sep 21, 2007 3:21AM PDT

Sorry I feel I can't help you. While my setups work you may need someone with similar experiences to do the configuration for you.

Sorry, but you can read on your Sybase groups about this issue with firewalls and more. I've noted it but you may need someone to adjust it for you since my hints are not enough.

Bob

- Collapse -
back to first question...
Sep 22, 2007 1:46AM PDT

Ok, but... do you know how to restore original tcpip dlls?

- Collapse -
In the case of Vista...
Sep 22, 2007 2:07AM PDT

Reinstall the OS if http://support.microsoft.com/kb/929833 and it's use of SFC /SCANNOW does not replace the DLL.

I find it sad that you are struggling here and can't duplicate or "try it my way." I have a bad feeling that you may end up with a Geeksquad receipt.

Bob