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
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