February 4, 2004 at 2:08 pm
We connect to a mainframe database using EDAOLEDB.1 provider. It has worked for a few years for us with a few small problems. A couple of weeks ago we a developer wrote a simple query to extract all data from a table and insert it into Sql Server 2000.
February 4, 2004 at 2:14 pm
Sorry, I gueas I shouldn't hit enter. -- anyway the query is something like select column1,column2 from openquery(EDACONN,'select column1,column2 from table') We can run it, it returns 78000 records. We can run it about 3 - 4 times then we'll get an error ... OLE DB provider 'EDAOLEDB.1' reported an error. The provider ran out of memory. Eventually if I keep trying to run this query I can start a bunch of memory errors in Sql Server. HAs anyone come across this before??? Thanks
July 22, 2011 at 6:54 am
Hello, I was wondering if you hd fix your error? I running into the same one and can't figure out how to fix it. Thanks for your help
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply