Need help bad

[robert]

We are connecting from a PC using the oracle .net client to a oracle database.

We have 2 pc's that work fine on this connection, but one (the server we need it to run on) is giving us the error below

"Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached"

We changed the max pool size from 50 to 100 to 200 to 10000, but still get the same error.

Can anyone lead us in a direction that we can understand why one pc is giving us this error. Can we see anything more specific somewhere else by doing a trace?

We are using the oracle 9i .net client to attach to oracle 8 database.

Thanks so much, hoping we can figure this thing out this century.

bob

 

[Kalpesh Shah]

Just check whether you are able to ping to Oracle server using TNSPING
utility. I hope you know how to use TNSPING

Or check whether you are able to connect to Oracle from SQL Plus
& what connection string you are using ?

If you are on client, you need to specify Server = name of the oracle
server. But , if you are running it on the Oracle server, you need to
ignore the server property

If you still have problems, post it to newsgroup, with code sample

HTH
Kalpesh