Re: oracle,odbc connection

I think the clincher in this is the TNS resolution failure. Heres the solution:

Your TNSNAME.ORA is ok and should contain an entry for "NR424.world", but you may need to run the Network Topology Generator that comes with Oracle7 Server Client tools for Database Administrators (Oracle Enterprise Manager). It creates a TOPOLOGY.ORA from the TNSNAMES.ORA. I dont know how important that it, but it works for me.

Next create a 32bit ODBC User DSN as follows:

1. From Win95 select: Start...Control Panels
2. Double click ODBC 32bit (v. important thats its 32 bit)
3. Press: Add
4. Select: Oracle73

Database Source name: NR424
SQL*Net connect string: NR424

5. Press: OK

6. Press: OK

The database instance "NR424" should now be ready to be used from any ODBC client.

On Sat, 16 Jan 1999 14:00:58 GMT, 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
Received on Thu Jan 21 1999 - 11:08:11 CST