General information
Title:
ODBC 'Insufficient Memory' Error
If someone could point me in the right direction with this error message I would be very grateful.
I am inserting records from a text file through a remote view into a SQL Server table. The SQL Table has an insert trigger which updates other files from the inserted record's values.
I get through a little more than 30,000 records (out of more than 150,000 total) before I get this error message:
"Connectivity Error:[Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient memory to run this query."
I have 256 megs on the Server (which is dedicated to run SQL) and mine is the only database on the server.
Anyone have any ideas on how I can work around this?
Any suggestions would be greatly appreciated.
Thanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only