Re: ODBC Win NT

Is this all on one machine, or more than one?

Don't you have to install and configure sqlnet (net8?) before you can make an ODBC to Oracle8?

I'm not using Oracle8x yet, but from the errors, it looks like you have some kind of sqlnet/net8 installed, but maybe not configured properly (or the sqlnet/net8 on the server is not configured properly).

If not, look for net8 on the Oracle8 client install. Otherwise (sqlnet v2x) you may need to get one of the older Oracle client install medias.

eg, if you have either a lot of time, or a high bandwidth IP connection, you could download the trial version of Dev6(i?), or something similar, from

  http://technet.oracle.com/software/index.htm (free registration),

and install sqlnet from that. hopefully there are other options for getting free oracle client software media that are less wasteful of bandwidth (&disk space!).

beware that some older oracle install media are *not* Y2K compliant.

you can download a Y2K compliant installer from Oracle's FTP site.

  ftp://oracle-ftp.oracle.com/dev_tools/patchsets/Installer/32bit/

Run that FIRST, then use it to install (*.prd file) from any older install media that you need to use.

regards,
ep

Date sent:      	Thu, 10 Aug 2000 04:57:07 -0800
To:             	Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
From:           	"Yustiono" <tekait11_at_bni.co.id>
Subject:        	ODBC Win NT

> I run Oracle8i v.8.1.6 on NT 4.0 machine. I set up ODBC 32bit (from v816
> client installlation) on client (Win 98) but has never succeeded.
> The error that I received is:
> "SQLSTATE: NA000
> Native Error Coe: 12514
> Driver Message: [Microsoft][ODBC Driver for Oracle][Oracle]ORA-12514:
> TNS:listener could not resolve SERVICE_NAME given in connect descriptor".
>
> When I look at the help page, the possiblility is the SQL*Net setting. Where
> can I get or download the SQL*NET v2 from?
Received on Thu Aug 10 2000 - 12:33:08 CDT