Re: From Access to Oracle

In article <8t6ggc$6vs$1_at_nslave3.tin.it>,   "rdf" <deficis_at_show.it> wrote:
> 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.

Generally, you'll need to have the Oracle client installed for an ODBC driver to connect.

--
Justin Cave - Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of
Oracle Corporation.


Sent via Deja.com http://www.deja.com/
Before you buy.