intermitent connection failure

We have written a thread to monitor whether the database connection is still
alive or not.
This monitoring thread executes a stored procedure, sp_TestDB, with ADO
_CommandPtr every 3 seconds.
Most of the time we have no problems executing it. However, we receive the
following error randomly:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite
(WrapperWrite()). Msg:Unspecified error
We are convinced that the machine where the database server is installed is
definitely alive as we ping it all the time and there is no request time out
.
We want to know what other problems could cause this error to happen randoml
y?
The development language we use is Visual C++.
The database server we use is :
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
ScottHi Scott,
Since this is an unspecified error on the client side, In this case, please
try to use SQL profiler to start a trace to see what is actually happening
on the server. The trace log might show more information on this error.
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."|||Excuse me, but I have the same problem, could you tell me how can I fix ?
I will appreciate it.
Thanks
Bruno Martinez
MCDBA
BMartinez@.cosapisoft.com.pe
"scottrm" <scottrm@.newsgroup.nospam> escribi en el mensaje
news:AD41E055-5B53-4015-B73E-88086A949CE4@.microsoft.com...
> We have written a thread to monitor whether the database connection is
> still
> alive or not.
> This monitoring thread executes a stored procedure, sp_TestDB, with ADO
> _CommandPtr every 3 seconds.
> Most of the time we have no problems executing it. However, we receive the
> following error randomly:
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite
> (WrapperWrite()). Msg:Unspecified error
> We are convinced that the machine where the database server is installed
> is
> definitely alive as we ping it all the time and there is no request time
> out.
> We want to know what other problems could cause this error to happen
> randomly?
> The development language we use is Visual C++.
> The database server we use is :
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
>
>
> --
> Scott

intermitent connection failure

We have written a thread to monitor whether the database connection is still
alive or not.
This monitoring thread executes a stored procedure, sp_TestDB, with ADO
_CommandPtr every 3 seconds.
Most of the time we have no problems executing it. However, we receive the
following error randomly:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite
(WrapperWrite()). Msg:Unspecified error
We are convinced that the machine where the database server is installed is
definitely alive as we ping it all the time and there is no request time out.
We want to know what other problems could cause this error to happen randomly?
The development language we use is Visual C++.
The database server we use is :
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Scott
Hi Scott,
Since this is an unspecified error on the client side, In this case, please
try to use SQL profiler to start a trace to see what is actually happening
on the server. The trace log might show more information on this error.
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
|||Excuse me, but I have the same problem, could you tell me how can I fix ?
I will appreciate it.
Thanks
Bruno Martinez
MCDBA
BMartinez@.cosapisoft.com.pe
"scottrm" <scottrm@.newsgroup.nospam> escribi en el mensaje
news:AD41E055-5B53-4015-B73E-88086A949CE4@.microsoft.com...
> We have written a thread to monitor whether the database connection is
> still
> alive or not.
> This monitoring thread executes a stored procedure, sp_TestDB, with ADO
> _CommandPtr every 3 seconds.
> Most of the time we have no problems executing it. However, we receive the
> following error randomly:
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite
> (WrapperWrite()). Msg:Unspecified error
> We are convinced that the machine where the database server is installed
> is
> definitely alive as we ping it all the time and there is no request time
> out.
> We want to know what other problems could cause this error to happen
> randomly?
> The development language we use is Visual C++.
> The database server we use is :
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
>
>
> --
> Scott
sql

Intercept SQL : Spy / Driver-level / SQL Server Log...

Hello all,
We need to reverse engineer a very large application written in
PowerBuilder / SQL Server to port to .NET.
We have only binaries of application not source code.
What are tools / log facilitites / spy appliations that shall allow us
to see exact SQL that is being carried by driver to SQL server ? Can
we see that in the ASCII form before it gets complied at Server end?
Thanks for your time.
- KA"Kedar Agarkar" <ideas2050@.math.net> wrote in message
news:6e80e9e2.0310080343.48c8a818@.posting.google.com...
> We need to reverse engineer a very large application written in
> PowerBuilder / SQL Server to port to .NET.
> What are tools / log facilitites / spy appliations that shall allow us
> to see exact SQL that is being carried by driver to SQL server ? Can
> we see that in the ASCII form before it gets complied at Server end?
Use the Profiler, unless it's 6.5, in which case us the Trace facility. Good
luck in your project.
Kind Regards, Howard

Intercept SQL : Spy / Driver-level / SQL Server Log...

Hello all,

We need to reverse engineer a very large application written in
PowerBuilder / SQL Server to port to .NET.

We have only binaries of application not source code.

What are tools / log facilitites / spy appliations that shall allow us
to see exact SQL that is being carried by driver to SQL server ? Can
we see that in the ASCII form before it gets complied at Server end?

Thanks for your time.

- KA"Kedar Agarkar" <ideas2050@.math.net> wrote in message
news:6e80e9e2.0310080343.48c8a818@.posting.google.c om...
> We need to reverse engineer a very large application written in
> PowerBuilder / SQL Server to port to .NET.
> What are tools / log facilitites / spy appliations that shall allow us
> to see exact SQL that is being carried by driver to SQL server ? Can
> we see that in the ASCII form before it gets complied at Server end?

Use the Profiler, unless it's 6.5, in which case us the Trace facility. Good
luck in your project.

Kind Regards, Howard

interacting with C++ as programming language and SQL SErver as DB

Is SQL Server capable of interacting with C++ written programs /Java written
programs (all non microsoft products). If yes, how would you do it from the
language?
ThanksSQL Server can use "extended stored procedures", these are native mode
DLLs typically written in C/C++.
AFAIK for Java, no easy way.