Re: From Access to Oracle

From: <pvinnakota_at_my-deja.com>
Date: Mon, 30 Oct 2000 21:12:46 GMT
Message-ID: <8tko85$7hs$1@nnrp1.deja.com>

Hi,
If the installation went through without any hitch, at the end NET8 Config. Assistant will do all the work for you, by creating requisite entries in your TNSNAMES.ORA and SQLNET.ORA. It also tells if the listener is started successfully or not. It also tests the connectivity. Hope all these have been observed in your case. Otherwise, do another install, provided it is possible to do so now. Another thing I noted when creating tables using Access is, the table and column names come through exactly, and as long as you have these tables all such table and column names have to be enclosed in double quotes, which becomes a pain very soon.
Bye,
In article <8t748k$k1j$1_at_nnrp1.deja.com>,   jocave_at_my-deja.com wrote:
> 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.

>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 30 2000 - 15:12:46 CST