Oracle Developer and Ingres
Date: Fri, 03 Dec 1999 14:28:52 GMT
Message-ID: <828k2v$6db$1_at_nnrp1.deja.com>
Hi,
We at the University of Wales Bangor have just started a trial of Developer 2000 release 6.0 and Oracle8i. One of the objectives of our trial is to see if we can develop applications using Form builder with an Ingres back end (All our existing
databases are Ingres) using the Oracle open client Adapter. I'm attempting to create a small master/detail app using the dept and emp tables found in the scott/tiger db supplied with Oracle. These are the steps I've taken.
1.Duplicated the two tables on Ingres. 2.Run the ingvubld.sql script to setup the data dictionary. 3.Created an odbc data source. 4.Created a master detail form with form builder. 5.Compiled and run the form.
All the above worked smoothly. My problems start when I execute the
query.
The first time the query is run it returns the first master (dept)
record and the associated detail(emp) records, which is what I want.
However, when I then click on the next record arrow, only the master
record is returned. The detail records remains blank.
The error it returns is
"OCA - 30021:error preparing/executing sql statement
(CA)OpenIngres ODBC driver (OpenIngres) Error message corresponding to
2716(a9c) not found in Ingres error file."
The ODBC driver is CA-OpenIngres Ver. 2.80.00.21 and is configured to
use cursors
Client is running on Windows 95
Ingres is version 6.4/06 running on Digital Unix 5.0
Can anyone out there help? Or at least point me at a reference source.
Has anyone succesfully created any applications using the above combination.
I'd be grateful if any responses could be e-mailed to the address below as well as posted to the group as our news feed does not carry this group.
Thank You,
Kevin
-- J. Kevin Hughes j.k.hughes_at_bangor.ac.uk Administrative Computing University of Wales Bangor Sent via Deja.com http://www.deja.com/ Before you buy.Received on Fri Dec 03 1999 - 15:28:52 CET