Oracle Error

[al_paso]

We hav been getting an error with the MS Oracle ODBC Driver. It says:
"Maximim no of processess exceeded."
This is from a web app on IIS 4.0 and ASP.
All connections are being closed and destroyed in all the pages and connection pooling is on at the ODBC level (ODBC 3.0).

One more thing the documentation for turning on connection pooling in ASP says that you have to modify a registry key in h_key_local_machine/software/.../ASP/parameters/startconnectionpooling. But when I go into the registry for the web server the startconnectionpooling key is not there and the value says: "for backward compatibility" !!!!How do I set the connection pooling for ASP ??

Appreciate any help on this..
Thanks

Neil

Hi
This could be because the connections created are not getting released.
If you are using disconnected recordsets, you have to expicitly set the recordset and connection object to nothing in your client.
cheers
Jacob

[al_paso]

Like I said ....
I am destroying (setting all objects to nothing) in ths ASPs. ADO 2.0 ensures anyway that all objects below the hierarchy of the Connection object get destroyed once the connection is detroyed.

Thanks for the reply any other clues will be appreciated..

You could try using OLEDB instead of ODBC. I use this method and I never have had any of these problems. Just look in the MSDN to find out how to use it. The only difference is in your connection string. You have to specify the provider=MSDAORA along with your username, password and database alias (in oracle) This should work.