Re: odbc,oracle , HELP !!!

Hi

There are a number of components involed here, but I always take it in steps.

1. Verify the network i.e ping host
2. Install the Oracle client software i.e SQL*Net (at least version2 ) and SQL*Plus to test
3. Run the SQL*Net easy config utility to setup the sqlnet.ora and tnsnames.ora files. Get the oracle SID from your DBA
4. Test the oracle connection to the database by invoking SQL*Plus, and using the alias you created in easy config. If this connect to a valid user you are 2/3 there.
5. Install the latest ODBC driver for Oracle. Normally on the client CD
6. Run 32-bit ODBC admin. All it really needs is the alias from you tnsnames.ora file. The user and password are entered at runtime.
7. Run ODBCtst32 to test the datasource.

Run throught this list, you can e-mail me at work.

RPlatt_at_w-c-s.co.uk

Regards Richard Platt
fm_at_klaatu.umd.edu wrote in message <76s5c8$8v9$1_at_nnrp1.dejanews.com>...
>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
Received on Wed Jan 06 1999 - 01:23:37 CET