🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac.databases
Article #323

DAL server with VAX and Oracle

#323
From: Henry K. Yu
Date: Wed, 07 Oct 1992 22:40
57 lines
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!hyu

Show 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