Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

corruption of sqloledb.dll?

Status
Not open for further replies.

WDfog

Programmer
Oct 16, 2000
26
US
I have a SQL 7 server that references another linked SQL 7 server in SQL statements, that runs in a job once an hour. Job ran fine for awhile and suddenly started failing. When running the code manually I receive the following error:

Server: Msg 7399, Level 16, State 1, Line 4
OLE DB provider 'SQLOLEDB' reported an error. The provider ran out of memory.

Checking the linked server for user/password and server type (SQL Server) showed to be fine, but clicking on the tables under the linked server in Ent.Manager gave the following error:

Error 7399: OLE DB provider 'UNKNOWN' reported an error. The provider ran out of memory.

Ok- first time this happened, I copied the sqloledb.dll file in from another SQL server. Worked like a charm. The problem is that this is now beginning to occur every few days. The job will run for a couple days, and then suddenly fail everything, resulting in the above errors. My first guess is something is corrupting the dll file. I only have one application on that server as it is a human resources application. There is nothing in the event log that is giving me any clues either.

Any ideas?

Thank you for your insight!
WTDuke
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top