asked on

ODBC ? OO4O error

On my web site I am accessing an oracle database using oo4o and ODBC through ASP

I keep getting this message

Unable to make connection, ORA-00020: maximum number of processes (30) exceeded

Can anyone advise.

I have messed about with the connection pooling in the global.asa file for oo4o and with connection pooling in ODBC but to no avail.

I am using oracle version 8.0.6

Paul

nigelrowe

What version of Oracle are you using?

plovett

ASKER

using oracle 8.0.6

nigelrowe

I use 8.1i and have seen this message. It concerned the DB configuration. There is a DB variable which you can change to increase this number, but I can't remember which one (there are several). Maybe you could ask your DB administrator to check this out.

plovett

ASKER

Thanks nigel..

There is a connection pooling setting in the global.asa file when using oo4o

I have tried to increase this but to no avail. I will follow your advice thanks.

Paul

ASKER CERTIFIED SOLUTION

omerfarooque

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

plovett

ASKER

Thanks Omer

I am going to give it a whirl now.

Paul

lavinder

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this

question is:
Accept a comment - omarfarooque
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

lavinder
EE Cleanup Volunteer