Re: ASP.NET connection fails (ORA-12154)

Users don't need to see the Oracle directory on the server. As a matter of fact they should NOT have any access to those files. I would see if you can get an example of a connection. It is probably a syntax error or a parameter not configured correctly in your code. Jim
"Marius Krogh" <makro(remove)_at_online.no> wrote in message news:vMdv9.530$_O4.8293_at_news2.ulv.nextra.no...
> Hi!
> I'm developing an ASP.NET application where I've want to connect to an
> Oracle DB. I've installed the Oracle DB, configured the tnsnames.ora file,
> I'm able to connect via SQL*Plus, I can connect to the DB with the Server
> Explorer in VS.NET and list all tables and views. But when I try to
 connect
> to the DB with an OleDBConnection in ASP.NET I get the ORA-12154 error
> (saying it can't find the TNS name). The connection-string I use is the
 one
> that VS.NET generates. I've made the web page use the admin-user as the
> anonymous user. I've tried to put
> SQLNET.AUTHENTICATION_SERVICES = (none)
> SQLNET.AUTHENTICATION = (none)
> in the sql.ora file.
>
> So what can be wrong? I know the tnsnames.ora file is correct, I've
 granted
> read permissions to all user in the oracle directory.
> The oracle DB (v 8.1.6) is on the same computer as the .Net Framework.
> When every other appl. is able to connect to the DB why can't ASP.NET?
>
> I hope somone out there have any suggestions on how to solve this problem.
>
> Marius Krogh
>
>
Received on Tue Oct 29 2002 - 03:11:16 CET