Re: oracle,odbc connection

You have at least two problems in your posting. THe ORA-12154 implies that your 'dbserv.csc' is not in either your local host file or your net DNS.

The second is an ordinary invalid user id/password.

Consider trying TNSPING (or TNSPING80, depending on release) to check your SQL*NET connection. THis is a command line utility. You would enter 'tnsping nr424' on the command line. THis will tell you if your SQL*NET is ok.

In article <76s5k9$9ab$1_at_nnrp1.dejanews.com>,   fm_at_klaatu.umd.edu wrote:
> I hope I am not violating posting rules by posting to multiple groups. Let me
> know if this is so. NOW to the real issue. I am trying to write a Visual C++
> application that will connect to a remote oracle database (called
> dbserv.csc.umd.edu which worked fine from a java application) from a windows
> environment. I have used the server name as stated in the tnsnames.ora file
> on the oracle side. I have also installed oracle 8.0.4 I am guessing the
> client only (since it does not give me any server options). This I got to get
> the SQL*Net Client. I have NO idea how to set up the ODBC part to get the
> connection to working. Over a week, I have had various erros amoung which
> some are: - ORA-12154:TNS Could not resolve service name.Driver's
> SQLSetConnectAttr failed. - [Microsoft][ODBC driver for
> Oracle][Oracle]ORA-01017:invalid username/password;logon denied
> [Microsoft][ODBC Driver Manager]Driver's SQLSetConnetAttr failed
>
> and many others.
>
> This is what is in the tnsnames.ora file:
> NR424 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(Key = NR424))
> (ADDRESS = (PROTOCOL = TCP)(HOST = dbserv.csc)(PORT = 1521))
> )
> (CONNECT_DATA = (SID = NR424))
> )
>
> How to I get here using what, in ODBC Admin, what information should I put
> in user DSN, System DSN, File DSN ......?
> Which Driver should I choose, Microsoft ODBC for Oracle, Oracle, Oracle ODBC,
> Oracle ODBC driver for RDB
>
> Could anyone PLEASE tell me how to get this connection to work. Please note I
> have windows NT workstation, SLQ*Net Client (which I don't know how to use).
> Please e-mail me at fm_at_klaatu.umd.edu.
> Farooq
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 18 1999 - 07:44:45 CST