From Access to Oracle

From: rdf <deficis_at_show.it>
Date: Wed, 25 Oct 2000 13:31:48 +0200
Message-ID: <8t6ggc$6vs$1@nslave3.tin.it>

Hallo, I hope in your help.

I installed Oracle 8i server, building the same Access data structure
(tables, trigger ecc.).

The problem is when I try to use a simple system dsn from ASP script, in this two modes:

with a connectionstring using OLE DB for ODBC (Provider=MSDAORA;Data Source=OracleC27J;User ID=scott;Password=tiger) and receiving: "ORA-12154: TNS:could not resolve service name"
with a connectionstring calling a simple dsn
(dsn=OracleC27J;uid=scott;pwd=tiger;) and receiving:
"Catastrophic failure"

It's necessary SQL*Net or similary ??
Thanks for your time. Received on Wed Oct 25 2000 - 06:31:48 CDT