[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:DEC Rdb against the World
Moderator:HERON::GODFRIND
Created:Fri Jun 12 1987
Last Modified:Thu Feb 23 1995
Last Successful Update:Fri Jun 06 1997
Number of topics:1348
Total number of notes:5438

609.0. "Access to "remote" Oracle DB?" by OSPREY::TAYLOR (SWAS Scotland) Wed Apr 04 1990 11:29

    	A customer I have recently become involved with now appears to be
    realising the cost implications of Oracle licenses. He has Oracle
    running on a VAX, and would like to access this database from another
    system on the LAN without having to buy another Oracle license.
    
    I suspect his options are limited, but is there anything that we can do
    which will allow him to write, for instance, SQL queries targetting the
    remote Oracle database? I don't necessarily want to re-open the "VIDA
    for Oracle" discussion that was aired in note 382, but all suggestions
    will be welcome - e.g. of potential third party (4GL?) solutions.
    
    I realise it may well be that Oracle have him truly stitched up and his
    only option is to buy umpteen SQL*products, but if there are
    alternatives then please let me know.
T.RTitleUserPersonal
Name		DateLines
609.1TRIFOXSRFSUP::LANGSTONRelational db for the nineties.Thu Apr 05 1990 01:171
    See note 438 in the old Rdb30b conference.  (RE:TRIFOX)
609.2still no joyOSPREY::TAYLORSWAS ScotlandThu Apr 05 1990 11:117
    Re .1 above I've tried the BANZAI::RDB_OLD and BANZAI::RDB30B
    conferences, but note 438 in both conferences is unrelated to my query.
    I've also tried 'dir/title=oracle' and 'dir/title=trifox' in both
    conferences but again there is nothing that appears to be relevant.
    
    Am I missing something or is there another conference that I should be
    looking at ?
609.3SmartStarCLYPPR::BOOTHWhat am I?...An Oracle?Thu Apr 05 1990 14:294
    Your customer might install SmartStar. That would let the customer do
    remote queries to Oracle. It would also "commodotize" the database.
    
    ---- Michael Booth
609.4KBEAR::STENOISHDBS WestThu Apr 05 1990 19:181
    try note 438 in THIS conference...
609.5They're stuck ... and bad !MAIL::DUNCANGGerry Duncan @KCO - DTN 452-3445Fri Apr 06 1990 20:1113
    Think of this in Rdb terms.  In order for a user on one node (A) to
    access an Rdb database on another node (B), the Rdb runtime and DECnet 
    must be installed on both nodes.  Oracle has a similar requirement.
    
    I can't think of anything that will allow a user on node A (where
    Oracle is NOT installed) to access an Oracle db on node B.  In order
    for this to work, Oracle dbms, SQL*plus, SQL*net, and Oracle DECnet 
    driver must be installed on node A AND node B.  
    
    Oh, I forgot, there in one thing that would work.... a deep pocketbook
    !!!
    
    -- gerry
609.6Notes> SEARCH "brain"SRFSUP::LANGSTONRelational db for the nineties.Fri Apr 06 1990 20:278
�    < Note 609.4 by KBEAR::STENOISH "DBS West" >


�    try note 438 in THIS conference...
    
    
    Of course, that's what I *meant*. ;-)