Microsoft SQL Server forum - SOLVED: [dbnetlib] connectionread (recv()) error

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SOLVED: [dbnetlib] connectionread (recv()) error

Alex Linthicum

2005-06-09, 8:23 pm

I have an Access application that connects to a SQL Server 2000
instance.

Every other time I start my application, I receive a nasty
[DBNETLIB]& #91;ConnectionRead(r
ecv()).]General network error. Then I close
my application, open it up, and the error doesn't appear.

I've been searching on and off for a few weeks for a solution, and
though I found a few suggestions (namely setting the connectiontimeout
property of my connection object to a number greater than 0), I
couldn't a solution.

FINALLY today, on an obscure message board, I found a reference to the
following microsoft kb article:

http://support.microsoft.com/defaul...4&Product=sql2k

Apparently you can't use resource pooling when connecting to sql server
using an application role. This article explains further and tells you
how to disable it.

Hopefully this post will help someone :)

Alex

Sponsored Links