From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=0.2 required=5.0 tests=BAYES_00,INVALID_MSGID, REPLYTO_WITHOUT_TO_CC,T_FILL_THIS_FORM_SHORT autolearn=no autolearn_force=no version=3.4.4 X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 103376,d12b3481c28cff16 X-Google-Attributes: gid103376,public From: bbalfour@std.caci.com (Brad Balfour) Subject: Re: Ada and SQL on a Sparc Date: 1996/07/31 Message-ID: #1/1 X-Deja-AN: 171233308 references: organization: CACI, Inc. reply-to: bbalfour@std.caci.com newsgroups: comp.lang.ada Date: 1996-07-31T00:00:00+00:00 List-Id: In article , Bill Hensley wrote: >I'd like to know if GNAT supports a SQL interface, and if there are >any "gotchas" or war stories. If there is not too much negative commentary I >will be able to go to my management and make a strong case to use Ada. It certainly can be done. The Airfileds project was successful in creating an MIS application that connected Ada 95 software (compiled with GNAT) with the Oracle DBMS. (see various issues of the AdaIC newsletter on http://sw-eng.falls-church.va.us). In doing this, they discovered that the Oracle Pro*Ada software is Ada 83 speicifc and compiler specific and will *not* work. What did work, however, was some marvelous ODBC software from Objective Interface Systems (OIS) of Reston VA. Their AdaConnect 95 product was used successfully to talk to Oracle from Ada on a Sun/Sparc running Solaris. One advantage of using ODBC is that you can change DBMS without modifying the software. You can contact OIS at: Objective Interface Systems, Inc. 1892 Preston White Drive Reston, Virginia 22091 tel: (703) 264-1900 fax: (703) 264 1721 email: info@ois.com WWW: http://www.ois.com -- Brad Balfour SIGAda WWW Server CACI, Inc. http://www.acm.org/sigada/ 703/277-6767 and also try: bbalfour@std.caci.com http://lglwww.epfl.ch/Ada/ bbalfour@sw-eng.falls-church.va.us bbalfour@acm.org **new address: 3930 Pender Drive * Fairfax, VA 22030 * 703/277-6767**