Error: Microsoft OLE DB Provider for SQL Server (SQL 2000)
-
It’s a job that does a snapshot of a database at 1200am once a day. It uses DTS Package. When you right click the DTS package and try to execute, design, schedule you get an error:
SQL 2000
Error:
Microsoft OLE DB Provider for SQL Server
Error Description: [DBNETLIB] [ConnectionRead (WrapperRead().]General network error. Check your network documentation.
I looked this up in Google and you get all kinds of hits, it a general error.
This is the new server we migrated to from an old server; we migrated SQL from the old server then changed the new server name back to the old server.
-
Yeah dude, that's a tough one. You may be having network issues at that time. Do they do regularly scheduled maint at that time or something? Do you have issues with this job at other times of the day?
Basically, I'd nail this down to the type of problem it is first. So is it a problem with the box I'm on, with the box I'm connecting to, with the network, etc... and to do that you'll need to try it at different times of the day and from different boxes. Once you do that, then finding the solution shouldn't be too hard.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
-
The Database is local and any time I try to execute the job I get the error.
Thanks for your reply
-
I know you said it's local, but how are you connecting to it? If you're inside the package itself can you get it to run locally? So in other words if you TS into that box and run the package by hand does it run? Because a package always runs from the box you load it on. So if you're connecting remotely through SQL, then it'll run like it's being kicked off from your local box, but if you TS in, then it'll run like it's kicked off from that server.
So let's nail down the exact cause first. Take the job out of the equation. Try to run the package itself, not the job. If the package itself doesn't run, then look at how you're making the connection. Are you connecting with the DNS name, netbios, IP, etc... then change it to see if you can connect using one of the other methods. That'll tell us a lot about what we're dealing with. Because general network error can be tough, but on a local box it has to be something fairly simple I would imagine.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
-
Job fails and Can't run the DTS Package at all,
-
Can't even edit the package or design.
-
Excellent. Now we're getting somewhere. So what happens when you try to open the package?
Can you open it, or can you just not edit it?
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
-
When I try to do anything with the DTS package I get this error:
Microsoft OLE DB Provider for SQL Server
Error Description: [DBNETLIB] [ConnectionRead (WrapperRead().]General network error. Check your network documentation.
-
I'm intrigued by this. Tell you what... give me a call and let's discuss this a little further if you like.
817-937-6154
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply