Access ODBC in Win-OS2, SQL*NET OS/2, to HP Unix
Date: 1996/09/10
Message-ID: <512b5k$1tsi_at_news-s01.ny.us.ibm.net>#1/1
I am trying to access the Oracle 7.3.2.1 database on our HP unix server thru sql*net 2.2 for OS/2, thru win-os2! I am trying to use Access 2.0 and/or the oracle ODBC test program.
It won't work! Does anyone know what's wrong?
I have sql*net for OS/2 working. I can connect by either: sqlplus user/xxx_at_hp1.world
OR
sqlplus
Enter user-name: user
Enter password: xxx_at_hp1.world
Thanks.
Error 1.) from ODBC Tester by Oracle: (sometimes I get this one)
SQLSTATE: S1000
Native Error Code:12154
Driver Message:[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-12154
TNS:could not resolve service name.
Error 2.) from ODBC Tester by Oracle: (lately I get this one)
SQLSTATE: S1000
Native Error Code:6260
Driver Message:[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-06260
NETNTT:cannot write to remote process.
Oracl7 ODBC Setup - Oracle7 1.11.1.5 for windows
Data Source Name: hp1.world
Description: oracle access
SQL*Net connect string: DSN=Default;DBQ=t:hp1;UID=user;PWD=xxx
Where hp1 is the hostname of the unix box. dbq: t: stands for using tcpip
I don't know what to put for DSN
d:\oraos2\xbin\SQLVDM.exe is started
ODBC Driver for OS/2 Setup for VisPro/REXX
Connect String: SRVR=hp1.world;DSN=Default;UID=user;PWD=xxx
c:\Autoexec.bat
_at_ECHO OFF
SET MGA=C:\MGA\OS2
ECHO.
PROMPT $i$p$g
REM SET DELDIR=C:\DELETE,512;D:\DELETE,512;E:\DELETE,512;
PATH=D:\ORAOS2\BIN;C:\OS2;C:\OS2\MDOS;C:\OS2\MDOS\WINOS2;C:\;c:\tcpip\dos\bin;
d:\cmds;
LOADHIGH APPEND C:\OS2;C:\OS2\SYSTEM
SET TMP=C:\
REM LOADHIGH DOSKEY FINDFILE=DIR /A /S /B $*
REM DOSKEY EDIT=QBASIC/EDITOR $*
REM SET DIRCMD=/A
SET TEMP=d:\TMP
SET ETC=c:\tcpip\dos\etc
D:\ORAOS2\XBIN\SQLVDM.EXE
stantow_at_ibm.net
Received on Tue Sep 10 1996 - 00:00:00 CEST