Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Developer 2000 and Ingres 6.4/06
Hi,
We at the University of Wales Bangor have just started a trial of Developer
2000 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 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. Compile 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 record 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?
Thanks,
Kevin
--
J. Kevin Hughes j.k.hughes_at_bangor.ac.uk
Administrative Computing
University of Wales
Bangor
Received on Thu Dec 02 1999 - 06:22:08 CST