asp.net 2.0 and MySQL, PostgreSQL and Oracle 10g

[Stephen]

I had not needed to reboot or even IIS reset for the others, maybe oracle does need this, but I don't see why it could be different, Initially I did not have the "System.Data.OracleClient.OraclePermission" I just had System.Data.Oracle.OraclePermission, but now it is correct.

 

[Stephen]

Try now, and if is does not work, please send me a PM with a link so I can test without having the delay of the forums here.

 

[SLWK]

The security exception is gone but there's a new one

"System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater."

My mistake. Apparently, there needs to be some software installed on jodohost's servers from oracle. I thought it would all be in the .net framework.

 

[SLWK]

Found something on this:

http://dotnetjunkies.com/WebLog/rtgurskevik/archive/2005/01/19/45958.aspx

Apparently it is not a software installation problem, it is an oracle user authentication/permissions problem -- perculiar to oracle installations on windows

 

[SLWK]

In case you missed the pm I sent you

New error

ORA-12541: TNS:no listener

From http://www.orafaq.com/forum/t/23732/0/ it seems it is a firewall or permissions problem or something like that -- ie, some extra software on the box that is interfering with oracle's running on windows.

 

[Stephen]

Got PM, sending the right direction to see what the problem is here.

 

[shamrox]

Has this been resolved? I have a customer with a problem connecting.