"ORA-03114: not connected to ORACLE".

In a windows service (.NET) on unplugging network cable it use to loose
connection to oracle database.
Once the network connection was up it was found that the service was unable
to restore its connection to oracle database.
The conclusion that we drew after doing R&D was that, the connection pool
was keeping the bad connection in connection pool on network disconnection
which resulted in the service to use those bad connection and keep throwing
exception “not connected to Oracle”.
On Microsoft site there is a mention of Hot Fix. Where can we get this?
http://support.microsoft.com/default...b;en-us;830173
Is there any way we can solve this problem without applying the HOT FIX.
Architect
eBusiness & Intranet
You will need to contact Microsoft PSS Developer Support (contact information
is on the kb article you referenced.) There are two versions of the hotfix,
..NET RTM and .NET 1.1 SP1.
"WEB_CMA" wrote:
> In a windows service (.NET) on unplugging network cable it use to loose
> connection to oracle database.
> Once the network connection was up it was found that the service was unable
> to restore its connection to oracle database.
> The conclusion that we drew after doing R&D was that, the connection pool
> was keeping the bad connection in connection pool on network disconnection
> which resulted in the service to use those bad connection and keep throwing
> exception “not connected to Oracle”.
> On Microsoft site there is a mention of Hot Fix. Where can we get this?
> http://support.microsoft.com/default...b;en-us;830173
>
> Is there any way we can solve this problem without applying the HOT FIX.
> --
> Architect
> eBusiness & Intranet
>

"ORA-03114: not connected to ORACLE".

In a windows service (.NET) on unplugging network cable it use to loose
connection to oracle database.
Once the network connection was up it was found that the service was unable
to restore its connection to oracle database.
The conclusion that we drew after doing R&D was that, the connection pool
was keeping the bad connection in connection pool on network disconnection
which resulted in the service to use those bad connection and keep throwing
exception “not connected to Oracle”.
On Microsoft site there is a mention of Hot Fix. Where can we get this'
http://support.microsoft.com/defaul...kb;en-us;830173
Is there any way we can solve this problem without applying the HOT FIX.
Architect
eBusiness & IntranetYou will need to contact Microsoft PSS Developer Support (contact informatio
n
is on the kb article you referenced.) There are two versions of the hotfix,
.NET RTM and .NET 1.1 SP1.
"WEB_CMA" wrote:
> In a windows service (.NET) on unplugging network cable it use to loose
> connection to oracle database.
> Once the network connection was up it was found that the service was unabl
e
> to restore its connection to oracle database.
> The conclusion that we drew after doing R&D was that, the connection pool
> was keeping the bad connection in connection pool on network disconnection
> which resulted in the service to use those bad connection and keep throwin
g
> exception “not connected to Oracle”.
> On Microsoft site there is a mention of Hot Fix. Where can we get this'
> http://support.microsoft.com/defaul...kb;en-us;830173
>
> Is there any way we can solve this problem without applying the HOT FIX.
> --
> Architect
> eBusiness & Intranet
>

"non-trusted connection" what does it mean?

What does it mean when a users is connected but it is a "non-trusted connection". This is showing up in the log file after my users connect. How does this effect the system/user? We have been experiencing speed issues and I was wondering if this might be a possible source of the problem.

Thanks in advance.A "trusted connection" is made using Windoze authentication. A "non-trusted connection" is made using SQL authentication. That is is the only difference that I know of between the two kinds of connections.

-PatP