Article View: comp.sys.mac.databases
Article #323DAL server with VAX and Oracle
From: Henry K. Yu
Date: Wed, 07 Oct 1992 22:40
Date: Wed, 07 Oct 1992 22:40
57 lines
2242 bytes
2242 bytes
I am new to this group. I have just installed the DAL server on a VAX. The DAL Client 1.3.5 is installed on a Mac IIfx. The exercise is to get to the Oracle database on the VAX via MS Excel 3.0. Could you please help me to determine if the problem is on the VAX side? And, what the problem is? Please. Or refer me to someone. Thanks in advance, hyu Here is a description. Excel will say that it "Can't establish connection". On the VAX server, Oracle is linked with Two-Task because 'netvsn' shows Mail box utility. The demo tables have been installed and can be accessed through SQL*Plus as scott/tiger. However, when I run the 'idal' interactive DAL tester on the VAX with: begin> open oracle dbms; more> go Execution begins... Execution Completed Successfully begin> open oracle database as user "scott" with password "tiger"; more> go Execution begins... <after about eight seconds> Then, it will kick me out of the session. That is all on the server side. The client side has the following diagnositics from the DAL Debugger: Hostname? IbsenADSP Username? hyu Password? Connopts? Atconnect IBSEN.CSC Laurel EtherZone username hyu MPPOpen = 0 DSPCreate = 16 Entity IBSEN:DAL Server:CSC Laurel EtherZone Server Found! Entity name Net:Node:Socket Entity IBSEN:DAL Server:CSC Laurel EtherZone4ef2:89:d9 About to open listener connection ATtxnsnd (10ffbfa, 15, 88) DSPWrite = 23 ATtxnrcv (18000) DSPStatus = 30 ATtxnrcv = 21 response /ffff ffff ffff ffff 7/ DSPClose = 0 scanning ffff ffff ffff ffff 7 Unable to Login ATdisconnect DSPRemove = 0 1: Connection to host 'IbsenADSP' failed. 1: Error #-10632 (0) adsp (IBSEN:DAL Server:CSC Laurel EtherZone) 1: Message: Host error - Server subprocess terminated unexpectedly soon. 1: Disconnected.
Technical Details
Message-ID:
<1992Oct07.224015.29243@eng.umd.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!think.com!sdd.hp.com!zaphod.mps.ohio-state.edu!darwin.sura.net!mojo.eng.umd.edu!hyuShow Full Headers
Complete Article Headers
Newsgroups: comp.sys.mac.databases Path: arc1-ca.pugleaf.net!sparky!uunet!think.com!sdd.hp.com!zaphod.mps.ohio-state.edu!darwin.sura.net!mojo.eng.umd.edu!hyu From: hyu@eng.umd.edu (Henry K. Yu) Subject: DAL server with VAX and Oracle Message-ID: <1992Oct07.224015.29243@eng.umd.edu> Date: Wed, 07 Oct 92 22:40:15 GMT Organization: Project GLUE, University of Maryland, College Park Keywords: DAL server VAX Oracle Lines: 57