[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

999.0. "Multi-database access?" by BREAKR::MADDEN () Sat Sep 28 1991 01:08

Hello,

I have a customer who is running 4 applications written with 4 different 
databases:  DBMS, BRITTON LEE, SYBASE, and PROGRESS. all on a VAX exept for 
the Britton Lee.

They would like to write applications that access a combo of the above 
databases.  IE, BRITTON LEE and SYBASE or PROGRESS and BRITTON LEE.  They
have not yet given us any specific requirements we are just looking for ways
to help them.

My question is?  

1. Could someone offer me some advice on how we could 
   access these 4 databases from one application?

   Are there any 3rd party tools available that would allow us access all the
   databases from one application?

   I know that SmartStar allow access for some, but any others out there?

2. Are these databases SQL complient so we could write applications with SQL 
   to access the data?

I am going to do a presentation to this customer next week outlining their
options so your help would be greatly appreciated.  Converting to Rdb 
is not a possibiltiy at this time.

Thanks,
Sue Madden

T.RTitleUserPersonal
Name
DateLines
999.1SQL Access?BROKE::MCGUIREMon Sep 30 1991 17:101
You might want to take a look at SQL Access.  See note 843.19.
999.2CSC32::S_MAUFEgotta get a new personal nameMon Oct 07 1991 23:4010
    
    Mobil(don't remember what arm) have done it. They have 1 image, that
    can access 4 different database types. They first check what database
    software is on the machine, and then only present the available options
    to the user.
    
    They needed to write different callable-interface code for each db
    type, and there was practically no sharing of code...
    
    Simon