July 28, 2004 at 8:34 pm
Dear All,
we am using DTS in vb.net. we are uploading data from CSV file (size 35kb) to Oracle database in production. All the while it was working fine (more than 10 months) and suddenly last 2 days we are hitting this problem. there was a move in production but nothing touched in this part of vb file. its using webservice to run this dll. if we restart the webservice then its working fine and next time it again hits this error and need to restart webservice. its kinda urgent. pls get back to me. Thanks a lot in advance.
Rgds,
Ravi
Errorcode >> -2147467259
Errorsource >> Microsoft OLE DB Provider for ODBC Drivers
Errordescription >> [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (Microsoft OLE DB Provider for ODBC Drivers (8007000e): [Microsoft][ODBC Text Driver] System resource exceeded.)
August 2, 2004 at 8:00 am
This was removed by the editor as SPAM
August 13, 2004 at 1:27 pm
When you say that there was a "move in production", does that mean the server was physically moved or the database was moved to a different server or that there was some other change?
Have you checked to see if there is something new that may be taking up a lot of resources on the Web server? If something new is there it may have a memory leak and isn't releasing resources on the server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply