SqlException: Unknown error.

3 Sep 2005 12:51 AM

Lloyd

I have some code doing a very simple select "select bonusid from game where
gameid=@gameid" that works about 98% of the time, but somewhere around two
percent of the time it throws an exception. If I go through the sqlerror's
in the exception all it has is the following:

Index #0
Message: Unknown error.
LineNumber: 0
Source: .Net SqlClient Data Provider
Procedure:

Not very interesting is it. I've checked that the input is valid and I have
no problems running the same query manually. I also have yet to find a
consistent way to recreate this error but my clients are having no problems
doing it fairly frequently with no rhyme or reason that I can tell.

Although there are many clients simultaneously using the server they share
one database connection but I am very careful to only use the connection
through a wrapper class that Lock()'s the database connection. I'm really
lost on this one, has anyone else seen this? I could find next to nothing
on google/google groups.

Lloyd Christopher
SLOW30

3 Sep 2005 4:05 PM

Eamon Straughn

try the following select bonusid from game where gameid = @gameid

"Lloyd" <lloydspamsodoff@slow30.com> wrote in message

news:rs6Se.361224$s54.344830@pd7tw2no...
Show quote

> I have some code doing a very simple select "select bonusid from game
where
> gameid=@gameid" that works about 98% of the time, but somewhere around two
> percent of the time it throws an exception. If I go through the
sqlerror's
> in the exception all it has is the following:
>
> Index #0
> Message: Unknown error.
> LineNumber: 0
> Source: .Net SqlClient Data Provider
> Procedure:
>
> Not very interesting is it. I've checked that the input is valid and I
have
> no problems running the same query manually. I also have yet to find a
> consistent way to recreate this error but my clients are having no
problems
> doing it fairly frequently with no rhyme or reason that I can tell.
>
> Although there are many clients simultaneously using the server they share
> one database connection but I am very careful to only use the connection
> through a wrapper class that Lock()'s the database connection. I'm really
> lost on this one, has anyone else seen this? I could find next to nothing
> on google/google groups.
>
> Lloyd Christopher
> SLOW30
>
>
>

4 Sep 2005 11:28 PM

Lloyd

Thank you for the reply. I'll give this a try, but why would that make a
difference?

Show quote

"Eamon Straughn" <blackmanvan***@aol.com> wrote in message
news:eZk14EKsFHA.2604@TK2MSFTNGP14.phx.gbl...
> try the following select bonusid from game where gameid = @gameid
>
>
>
> "Lloyd" <lloydspamsodoff@slow30.com> wrote in message
> news:rs6Se.361224$s54.344830@pd7tw2no...
>> I have some code doing a very simple select "select bonusid from game
> where
>> gameid=@gameid" that works about 98% of the time, but somewhere around
>> two
>> percent of the time it throws an exception. If I go through the
> sqlerror's
>> in the exception all it has is the following:
>>
>> Index #0
>> Message: Unknown error.
>> LineNumber: 0
>> Source: .Net SqlClient Data Provider
>> Procedure:
>>
>> Not very interesting is it. I've checked that the input is valid and I
> have
>> no problems running the same query manually. I also have yet to find a
>> consistent way to recreate this error but my clients are having no
> problems
>> doing it fairly frequently with no rhyme or reason that I can tell.
>>
>> Although there are many clients simultaneously using the server they
>> share
>> one database connection but I am very careful to only use the connection
>> through a wrapper class that Lock()'s the database connection. I'm
>> really
>> lost on this one, has anyone else seen this? I could find next to
>> nothing
>> on google/google groups.
>>
>> Lloyd Christopher
>> SLOW30
>>
>>
>>
>
>