🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.next.programmer
Article #2135

Linking to SPARC based ORACLE using DBKit ?

#2135
From: Sheep T. Iconoclast
Date: Fri, 18 Dec 1992 18:02
53 lines
2583 bytes
Hi we just upgrade to Next Step 3.0 , and I noticed this pretty funky
DBKit. We have some nothing but ORACLE running on a SPARC is
possible people in another deparment working on a collaboartive project.

I wanted to show off the Next Step by linking to there own database from 
our next machines (both on the Internet why not ?). As far as I understand 
you begin by createing a DBModel using the DBModeler. 

Stage 1. in DBModeler do new and Select the Adaptor. 
Ok Select ORACLE
Stage 2. Fill in the link information
SERVER ID, Hostmachine,Login, Password.
for SERVER ID I used the setenv ORACLE_SID value let's say ualoracle
for hostmachine i used fish (I tested and can ping fish ok).
for login I used patric (they only have one user on the DB)
for the password I used flatfish (the only password for the only user) 

I press the OK button and the same dialog box returns.
QUESTION What's missing ? What's wrong ?

The RTFM says "In general, if you can connect with Sybase's isql or  
Oracle's sqlplus, then you should be able to connect from DBModeler".
OK I want to get this straight. Does this mean that 
a) you cannot link to a remote machine running SQL ie if you
want to use the adapter then you must perchase Oracle first.
b) You cannot link to a remote non next machine running Oracle 
ie you can only link to Oracle on  remote Next. 

I have problems with this because they can talk to the Oracle 
server from some Macs they have in there department.

As far as DBModeler goes why is there not any error messages. Networking 
with other machines is really really difficuly, error messages must come  
up
to help work out who's at fault. I think this is a fundermental fault of 
client server computing. 

Will the DB modler link not go beyond the local gateway (they are in a  
diffrent 
department).
We know the wacky symbols to type in like the 
"scott/tiget@T:alexandra:sjOracle"
but cannot get to the Login string stage (shown later in the DBModeler 
documentation).

I'm looking for help finding out what's going wrong. I know I get
some Input/output packets at the first attempt but after that nothing.

All help gratefully accepted 
sheep.

Ps 
happy Xmas ! 
Technical Details
Message-ID: <1992Dec18.180203.4193@bas-a.bcc.ac.uk>
Path: arc1-ca.pugleaf.net!sparky!uunet!mcsun!uknet!bcc.ac.uk!news

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!mcsun!uknet!bcc.ac.uk!news
From: sheep@tankgirl (Sheep T. Iconoclast)
Newsgroups: comp.sys.next.programmer
Subject: Linking to SPARC based ORACLE using DBKit ?
Keywords: DBkit ORACLE
Message-ID: <1992Dec18.180203.4193@bas-a.bcc.ac.uk>
Date: 18 Dec 92 18:02:03 GMT
Organization: Bloomsbury Computing Consortium
Lines: 53