Article View: comp.sys.next.programmer
Article #2135Linking to SPARC based ORACLE using DBKit ?
From: Sheep T. Iconoclast
Date: Fri, 18 Dec 1992 18:02
Date: Fri, 18 Dec 1992 18:02
53 lines
2583 bytes
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!newsShow 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