Re: Access ODBC in Win-OS2, SQL*NET OS/2, to HP Unix

Stan Towianski wrote:
>
> 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Þfault;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=1.world;DSNÞfault;UID=user;PWD=xxx
>
> -------------------------------------------------------------------
> c:\Autoexec.bat
>
> _at_ECHO OFF
> SET MGA=\MGA\OS2
> ECHO.
> PROMPT $i$p$g
> REM SET DELDIR=\DELETE,512;D:\DELETE,512;E:\DELETE,512;
> PATH=\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=\
> REM LOADHIGH DOSKEY FINDFILE=R /A /S /B $*
> REM DOSKEY EDIT=ASIC/EDITOR $*
> REM SET DIRCMD=
> SET TEMP=\TMP
> SET ETC=\tcpip\dos\etc
> D:\ORAOS2\XBIN\SQLVDM.EXE
>
> stantow_at_ibm.net

Try the following:
DSN="Data Source Name";DBQ=t:hp1;UID=user;PWD=xxx where "Data Source Name" = your ODBC driver Data Source (ie. DSN=Oracle7 1.11.1.5;DBQ=t:hp1;UID=user;PWD=xxx) Received on Mon Sep 09 1996 - 00:00:00 CEST