Please help with this Database Connection error
458152Oct 4 2005 — edited Nov 14 2005Hi,
there is an asp application related to Invoices that uses RDO object concept to connect to the database. Backend is oracle 10g. Application works fine in retrieving data from several tables except for one part of the application. Here the application needs to display the details of the Invoice once the user puts a checkmark beside the invoice number. The code works in a loop to display each invoice selected.
Problem is that it works upto about 15 continuous selections and after that it displays this error.
error '800a9c42'
IM006: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
This occurs on a line which contains a function that is used to get data from the resultset, which inturn should run a query.
I tried to increase the timeout for the ODBC connection but to no avail. It uses a DSN connection with Microsoft odbc oracle driver.
Can any one suggest please?
Many thanks
Sri