Windows Forum

Ask something
Discussion Locked

XP losing database connections

0 helpful
3 replies

by derek

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When switching between users on the same machine or in development - stopping and starting database connections- XP is losing the connections to the database. Even after quitting applications, I am unable to attach to an ODBC source. I am requiredto restart my machine. Is there a patch or setting to remedy this?

3 replies

by quintar51

Hi,

I know that when you switch users, 2000/XP machines will terminate all network connections. I used to have the same problem with my internet connection would always disconnect when switching users.

There is a registry fix for this, butI'm not sure if it would apply here. You can try it, as long as you backup your registry first.

go to start, run, regedit. Choose file, export registry, save it on the desktop. This will save your registry.

Then, go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon

Then right-click the right-hand pane,
select New -> String Value, name the value KeepRasConnections and set it to 1. Reboot.

good luck,

by derek

The fix was to use the named pipes library to connect to sql server instead of tcp/ip. Thank you though.

This discussion is closed to new replies.