Error: -2147467259 (80004005); Provider Error: 0 (0)

Hi,
I have a couple of DTS job that runs daily. However, for the past three days
a different job has failed every night with very similar looking error
messages that are listed below. When I re-run the job after it fails it runs
fine and completes successfully. Any information to resolve this will be
highly appreciated.
Error: -2147467259 (80004005); Provider Error: 11 (B)
Error string: [DBNETLIB][ConnectionRead (recv()).]General network error.
Check your network documentation.
Error source: Microsoft OLE DB Provider for SQL Server
Error: -2147467259 (80004005); Provider Error: 11 (B)
Error string: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General
network error. Check your network documentation.
Error source: Microsoft OLE DB Provider for SQL Server
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: Timeout expired
Error source: Microsoft OLE DB Provider for SQL ServerI think there used to be an issue like this due to something related to
connection pooling, and IIRC the workaround was to disable connection
pooling. Not sure if this is the same issue tho.
Did you try doing a search on support.microsoft.com?
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:21211FD0-C372-436A-9A53-FB5F0B631447@.microsoft.com...
> Hi,
> I have a couple of DTS job that runs daily. However, for the past three
> days
> a different job has failed every night with very similar looking error
> messages that are listed below. When I re-run the job after it fails it
> runs
> fine and completes successfully. Any information to resolve this will be
> highly appreciated.
> Error: -2147467259 (80004005); Provider Error: 11 (B)
> Error string: [DBNETLIB][ConnectionRead (recv()).]General network
> error.
> Check your network documentation.
> Error source: Microsoft OLE DB Provider for SQL Server
>
> Error: -2147467259 (80004005); Provider Error: 11 (B)
> Error string: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General
> network error. Check your network documentation.
> Error source: Microsoft OLE DB Provider for SQL Server
>
> Error: -2147467259 (80004005); Provider Error: 0 (0)
> Error string: Timeout expired
> Error source: Microsoft OLE DB Provider for SQL Server
>
>
>|||Have see dozens of these, and almost everytime it was hardware or
connectivity driver related...not SQL Server
Stress test the network with NetMon running. Sorry I can't help on the
Netmon side. The stress test can be as simple as copying a HUGE file from
point A to point B.
I've seen corrupt/mismatched drivers, bad router ports and even crimped
cables cause this.
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:21211FD0-C372-436A-9A53-FB5F0B631447@.microsoft.com...
> Hi,
> I have a couple of DTS job that runs daily. However, for the past three
> days
> a different job has failed every night with very similar looking error
> messages that are listed below. When I re-run the job after it fails it
> runs
> fine and completes successfully. Any information to resolve this will be
> highly appreciated.
> Error: -2147467259 (80004005); Provider Error: 11 (B)
> Error string: [DBNETLIB][ConnectionRead (recv()).]General network
> error.
> Check your network documentation.
> Error source: Microsoft OLE DB Provider for SQL Server
>
> Error: -2147467259 (80004005); Provider Error: 11 (B)
> Error string: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General
> network error. Check your network documentation.
> Error source: Microsoft OLE DB Provider for SQL Server
>
> Error: -2147467259 (80004005); Provider Error: 0 (0)
> Error string: Timeout expired
> Error source: Microsoft OLE DB Provider for SQL Server
>
>
>