* Ada and SQL on a Sparc
@ 1996-07-30 0:00 Bill Hensley
1996-07-31 0:00 ` Chad Bremmon
` (2 more replies)
0 siblings, 3 replies; 5+ messages in thread
From: Bill Hensley @ 1996-07-30 0:00 UTC (permalink / raw)
I have been tasked to develop a set of Web pages that are hosted on a Sparc.
I would like to use Ada GNAT to accomplish the CGI side of this. The only
thing that holds me back is the Ada interface to the Oracle SQL database that
is to be used as the data repository for the Web site. While I have developed
Oracle-interfacing CGI using 4GL tools (Sapphire/Web) and with C, I'd rather
use Ada. 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.
Thanks, Bill
Bill_Hensley@smtp.rc.trw.com
http://ourworld.compuserve.com/homepages/Bill_Hensley/
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: Ada and SQL on a Sparc
1996-07-30 0:00 Ada and SQL on a Sparc Bill Hensley
@ 1996-07-31 0:00 ` Chad Bremmon
1996-07-31 0:00 ` William W Pritchett
1996-07-31 0:00 ` Brad Balfour
2 siblings, 0 replies; 5+ messages in thread
From: Chad Bremmon @ 1996-07-31 0:00 UTC (permalink / raw)
Bill Hensley wrote:
>
> I have been tasked to develop a set of Web pages that are hosted on a Sparc.
> I would like to use Ada GNAT to accomplish the CGI side of this. The only
> thing that holds me back is the Ada interface to the Oracle SQL database that
> is to be used as the data repository for the Web site. While I have developed
> Oracle-interfacing CGI using 4GL tools (Sapphire/Web) and with C, I'd rather
> use Ada. 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.
>
> Thanks, Bill
>
> Bill_Hensley@smtp.rc.trw.com
> http://ourworld.compuserve.com/homepages/Bill_Hensl
ey/
We have had relatively good success with the
Ada-Connect ODBC product. We are using Gnat
with Sybase, but the Airfields project used Oracle
with the ODBC drivers. Ada-Connect is based on the
Intersolv ODBC technology, and provides Ada95
access for Gnat and potentially any other Ada95
compiler. Please contact me if you would like more
information about getting those drivers.
bremmon@acm.org
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: Ada and SQL on a Sparc
1996-07-30 0:00 Ada and SQL on a Sparc Bill Hensley
1996-07-31 0:00 ` Chad Bremmon
1996-07-31 0:00 ` William W Pritchett
@ 1996-07-31 0:00 ` Brad Balfour
1996-08-01 0:00 ` Wayne R. Lawton
2 siblings, 1 reply; 5+ messages in thread
From: Brad Balfour @ 1996-07-31 0:00 UTC (permalink / raw)
In article <n1373396961.54880@smtp.rc.trw.com>, Bill Hensley
<Bill_Hensley@SMTP.RC.TRW.COM> 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**
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: Ada and SQL on a Sparc
1996-07-30 0:00 Ada and SQL on a Sparc Bill Hensley
1996-07-31 0:00 ` Chad Bremmon
@ 1996-07-31 0:00 ` William W Pritchett
1996-07-31 0:00 ` Brad Balfour
2 siblings, 0 replies; 5+ messages in thread
From: William W Pritchett @ 1996-07-31 0:00 UTC (permalink / raw)
The only way I know of to access Oracle using GNAT is through ODBC. Objective
Interface Systems sells an ODBC product for Ada which I've used with GNAT on 2
projects. Oracle's ProAda product, to my knowledge, hasn't been ported to GNAT.
ProAda has many compiler dependencies and making it GNAT-friendly isn't easy
(I've tried). ODBC, however, is very easy to use. Plus it's vendor independent.
Hope this helps,
Bill Pritchett
Bill Hensley (Bill_Hensley@SMTP.RC.TRW.COM) wrote:
: I have been tasked to develop a set of Web pages that are hosted on a Sparc.
: I would like to use Ada GNAT to accomplish the CGI side of this. The only
: thing that holds me back is the Ada interface to the Oracle SQL database that
: is to be used as the data repository for the Web site. While I have developed
: Oracle-interfacing CGI using 4GL tools (Sapphire/Web) and with C, I'd rather
: use Ada. 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.
: Thanks, Bill
: Bill_Hensley@smtp.rc.trw.com
: http://ourworld.compuserve.com/homepages/Bill_Hensley/
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: Ada and SQL on a Sparc
1996-07-31 0:00 ` Brad Balfour
@ 1996-08-01 0:00 ` Wayne R. Lawton
0 siblings, 0 replies; 5+ messages in thread
From: Wayne R. Lawton @ 1996-08-01 0:00 UTC (permalink / raw)
Greetings,
I worked with Brad Balfour and Bill Pritchett on the Airfields
effort (hi guys) and can readily second (third?) their endorsement of
the OIS AdaConnect package.
However, IF the goal is _simply_ to connect Oracle to a web page,
and not necessarily to demonstrate a successful usage of Ada, then why
not simply pull down Netscapes server with Oracle support?
The technology works. It is in place and operational. I cannot
discuss the specific implementation site publicly. The company I am
working for is a Netscape partner and the server may be alpha/beta. We
are currently implementing a series of database
add/update/delete/modify/report applications for the same commercial
customer.
If Ada is required/desired then I strongly support OISs entire product
line.
Regards,
Wayne R. Lawton
WLawton@servtech.com
^ permalink raw reply [flat|nested] 5+ messages in thread
end of thread, other threads:[~1996-08-01 0:00 UTC | newest]
Thread overview: 5+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
1996-07-30 0:00 Ada and SQL on a Sparc Bill Hensley
1996-07-31 0:00 ` Chad Bremmon
1996-07-31 0:00 ` William W Pritchett
1996-07-31 0:00 ` Brad Balfour
1996-08-01 0:00 ` Wayne R. Lawton
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox