Adaptor errors

[mullrich24]

I keep getting the following two errors very randomly
The error:

ORA12560 TNS: protocol adaptor error

develops into

ORA12500 TNS: Listener failed to start a dedicated server process

I have created a number of asp pages that draw data from and write to an oracle database. the asp pages work fine until out of nowhere these errors occur. After a few times hitting the refresh button on Internet Explorer the error goes away and the page renders as intended.

The errors consistently point to asp lines of the following format:

recordsetname.ActiveConnection = ...

This really irritates me as the pages themselves seem to work fine. Any idea? I am running oracle 8i personal and Microsoft Personal Web Server on the same machine for testing.

Please help
Marc

[gpsingh]

Check whether the correct adapters are linked to oracle executable:

$> adapters oracle

Also try using MTS instead of dedicated connection.

[mullrich24]

I am pretty new to oracle and database development. Where and how do I do this? I am using a dsn connection string:

dsn=name;uid=userid;pwd=password;

to connect.

Thanks

[mullrich24]

could this be a web server problem rather than a database problem?