Re: From Access to Oracle

You have to configure tnsnames.ora in \ora81\network\admin

SAMPLE.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = MYHOSTNAME)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = SAMPLE.WORLD)
    )
  )

Be sure the listener service started correctly.

Also have a look at listener.ora and insert your Protocol and Hostname there.

bye, Andre

rdf schrieb:
>
> 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 - 09:45:30 CDT