Problem with Oracle and ASP

From: <gd6502_at_eudoramail.com>
Date: 20 Apr 2006 03:28:19 -0700
Message-ID: <1145528899.287518.152550@i40g2000cwc.googlegroups.com>

Hi everybody, I have a problem with Oracle 9i (and with english, be patient).
I have an ASP page connected to an Oracle 9i database with this string: Provider=ORAOLEDB:Oracle;Data source=pippo;User Id=pluto;Password=paperino

If I open the page from the server it works regularly, from the client not. The error is: OraOleDB error ' 80004005 ' Ora-12154: TNS: can't resolve the service name

I think it doesn't depend by IIS neither by the ASP code; otherwise it would always cause error. Probably something lacks in Oracle installation.
On the server is installed the Oracle server, the IIS server and the Oracle client. Some client PC contains the Oracle client, soime other not, but all PCs go in error the same way. Can someone help me?

Peppe Received on Thu Apr 20 2006 - 05:28:19 CDT