SECTION 4 -- THIRD-PARTY SOFTWARE
<> 04.002 Can I use ODBC?
ODBC is Microsoft's implementation of the Call Level Interface
specification defined by the SQL Access Group. INGRES can act as
an ODBC server.
The INGRES driver is a Level 1 ODBC driver. This provides MS-Windows
applications with transparent access to INGRES databases. The ODBC
driver and the MS Driver Manager are available at no charge for the
INGRES/Net product for MS-Windows but must be EXPLICITLY requested .
The CA-INGRES ODBC driver is NOT bundled with INGRES/NET.
Refer to Jon Machtynger's INGRES ODBC FAQ at ftp.naiua.org /pub/ingres
for full information on using ODBC with INGRES.
See also the ODBC FAQ maintained by Microsoft, which you can FTP from
ftp.microsoft.com in /bussys/sql_odbc/odbc/faq.doc
Suggested site for a compendium of information about ODBC (performance
info, ODBC Hall of Fame, links to articles, ODBC vendor info, benchmarks,
myths and facts, database conference presentations and workshops, etc.):
http://ourworld.compuserve.com/homepages/Ken_North
Follow the Data Access Roadmap to the ODBC-related pages. This site also
includes JDBC and OLE DB info.
<> 04.003 What is Grafsman?
GRAFSMAN, an OpenIngres third-party application, lets developers add
graphics to their applications on any of 35 platforms, ranging from
DOS, to Windows, OS/2, UNIX, and VMS. Output can be directed to
character terminals, X, DOS E/VGA, DEC REGis, Tektronix mono/color,
Epson dot matrix, HP LaserJet, or PostScript, among many others.
GRAFSMAN can be built into OpenIngres/ABF, OpenIngres/Vision, and
OpenROAD applications. On UNIX and VMS platforms, it is also
possible to embed calls to GRAFSMAN in text files (such as reports
produced with Report Writer) which can be interpreted by a suppplied
filter before printing.
There is also a version of Grafsman for the web.
See http://www.soft-tek.com for more information.
<> 04.004 What is GQL?
GQL is a third-party graphical query language that has support for
OpenIngres (among many others). There is a read-only version called
GQL/User and a read/write version called GQL/Update.
Each site also needs at least a single copy of the GQL/Admin module
to control the client GQLs.
GQL/Design assists with database design and table definition.
GQL is capable of accessing all the popular database management systems
as well as OpenIngres, and a future version is expected to be able to
join tables from disparate systems.
The vendor has established a Gopher/FTP site for product support and
information.
The relevant info:
FTP: bbs.andyne.on.ca (IP:198.96.20.209)
Gopher: bbs.andyne.on.ca
BBS: (613)548-1032 2400bps/14.4kbps/N,8,1
WWW: http://bbs.andyne.on.ca/
<> 04.005 Can I use JDBC (Java connectivity)?
JDBC provides Java applications and applets with access to databases
in much the same way that ODBC does. For information on JDBC consult:
http://splash.javasoft.com/jdbc
At the time of writing there are three vendors of JDBC drivers for
OpenIngres.
Caribou Lake Software, Inc.
http://www.cariboulake.com
Intersolv (DataDirect Java JDBC solutions)
http://www.intersolv.com
Openlink Software
http://www.openlinksw.com
All these sites offer downloadable demo versions of the respective
vendor's products. Caribou Lake specializes in Java/OpenIngres
solutions.