0040 in ASP giving "Duplicate parameter name" error
Posted on 2005-02-28
I am attempting to upgrade to the latest 126.96.36.199 version of Ora Net Manager and 0040 from 188.8.131.52. We are running IIS on Win2003 connecting to Oracle 184.108.40.206 on Win2003.
Our DB connection string was like this:
Set db = CreateObject("OracleInProcServer.XOraSession"). _
OpenDatabase(DB_CONNECT, DB_ACCOUNT, 0)
now we have the default global.asa from 0040 and
set db = OraSession.getDatabaseFromPool(10)
Some of our ASP pages are generating this error on a second load.
Oracle Automation error '800a01b8'
OIP-04123: Duplicate parameter name, PARAM_ID
The error is caused by: db.Parameters.Add "PARAM_ID" not being removed properly.
1) Is there a way to tell IIS / ASP Parser to ignore these error that doesn't degrade the system? I know an On Error Resume Next may work, but seems to stall page loads.
2) Or, is there a way to loop through all db.Parameters and remove them?
I have unremoved parameters on about 1000 pages, so a simple routine to 'db.Parameters.Remove' all of them would save weeks of coding.
Thank you in advance for any advice.