Aargh = Oracle_Windows_ODBC + SQLNet_2 + Oracle_7 ;

I'm having trouble configuring Oracle's ODBC driver for Oracle 7 atop SQL*Net version 2 - could be my configuration error, could be a code problem. Anybody out there done this? Details follow:

Oracle version: 7.0.16 on SunOS 4.1.3
SQL*Net version: 2, running on Windows via TCP/IP Winsock ODBC version: SQORA7.DLL version 1.11.0002

I've got SQL*Net running and can connect to my test instance from the PC using Oracle's nettest. I've downloaded the most recent Oracle 7 ODBC driver from Compuserve; it installed just fine. I tried connecting with MS Query through ODBC and it failed. Error message was "ORA-12203: TNS: Unable to connect to destination" which, upon further digging,

      interprets loosely to, "Don't mess with Oracle's proprietary API unless you know what you're doing." Running a trace on the PC at level 16 gives me a *big* file when I successfully connect using nettest. Running the same trace while trying to connect via ODBC yields *no* file at all. I'm guessing that I'm not even getting through the SQL*Net API, so there's no TNS network activity.

I've been dinking with DOS environment variables, and the c:\windows\oracle.ini assuming my tnsnames.ora is correct.

I can be reached at lme_at_gomez.stortek.com . Received on Tue Feb 28 1995 - 02:28:55 CET