Re: odbc,oracle | GOT IT !!!

To answer my own question got it.
Many Thanks to Rebecca,Richard and Mauro. For all those who want to know or might have some use for it in the future: I run the Oracle Net 8 and made a new connection using tcp/ip.The name of the this latest creation is important as was needed later. Then in System DSN, I added a new connection using the "oracle" driver ( the one from Visigenic). Incredibly (and this might sound "dum") after 3 continuas days of trying, it worked. Feel free to mail me if I can be of any help (and since I don't get the time to frequent here that often).

Farooq

In article <76s5c8$8v9$1_at_nnrp1.dejanews.com>,   fm_at_klaatu.umd.edu wrote:
> 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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 08 1999 - 04:37:12 CET