ODBC ODBC ODBC ODBC UGHHHHHHH!!!!!

  Here is our situation:

HP9000 Oracle7 TCP/IP SQL*Net 2.0 SID=admis

************Our TNSNAMES.ORA file*******************

# Sample tnanames.ora file.
# This is a sample file for the client side.
# This file should be changed appropriately for any given
network/machine.
# It is only inteded to be a prototype model to aid porters.

local_host = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1601)(HOST=node_d))

             (CONNECT_DATA=(SID=admis)))

host_V2 = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1601)(HOST=node_d))

             (CONNECT_DATA=(SID=admis)))

host_V1=T:node_d:admis
***************End

On client side:

Win 3.1, TCP/IP s/w, ODBC driver for Oracle7 for Win 3.1, we created a data source with connect string '128.236.201.2admis' (tried 128.236.201.2:admis, also).

Installed Oracle products:
GUI common files, installer, net manager, required support files, SQLNet 2.0.15.0.3, and tools and utilities.

What can we do to get a working ODBC connection? This shouldn't be rocket science...we are totally frustrated and me personnally our DBAs no nothing about ODBC connections (or Oracle admin, for that matter). I have received some help but to no avail. I'm beginning to think this is an impossibiity but I know it works because one of our personnel did it with SQLnet 1.1 to Oracle6.

Help Received on Tue Oct 31 1995 - 00:00:00 CET