RB7, Oracle, and DBExpress

rbuser

I'm using the sample project located in "Demos\4. EndUser
Databases\Oracle 8\2. dbExpress" and I'm experiencing some problems.

When I delete a report, I get the following exceptions
"Record not found or changed by another user"
"Unable to find record. No key specified"
"Record not found or changed by another user"
"Unable to find record. No key specified"
"Record not found or changed by another user"
"Unable to find record. No key specified"
"sdsItem: Must apply updates before refreshing data"

The sample project has not been changed in any way, except:
- the TSQLConnection.ConnectionName has been changed from IBLocal to
our own connection name.
- the table and field names have been changed to reflect our own
naming convention

Any ideas on how to resolve this?

If I use the same project, and change the "Trim Chars" to true in the
TSQLConnection's Params property, then I don't get the above exceptions,
but I do get an AV error at "...address 4DAE5215 in module
'midas.dll'..." when I attempt to delete a report. This exception is
raised at line 1105 in ppDBPipe:
Result := FDataLink.DataSet.Locate(aFieldName, aKeyValue,
lLocateOptions);

I'm using RB Server 7.01 with Delphi 7.

Your help would be appreciated on this. I've attempted to use D5 with
the BDE, but have run into problems with the BDE's handling of BLOB
fields; ReportBuilder, ADO and Oracle don't work together; and now I'm
having problems with D7, DBExpress, and Oracle.

Thanks in advance,

Ed Vander Hoek

nardmoseley

The examples located in RBuilder\Demos\4. EndUser Databases\Oracle 8 include
BDE, dbExpress, and DOA (Direct Oracle Access). Each example contains a
ReadMe.doc that explains the configuration. There is a
CreateEndUserTables.sql script that contains the sql to create the end-user
tables for Oracle. You must use this script to create the tables. The script
contains the code to define the necessary indices and autoincrement fields.

I recommend that you evaluate a DOA (Direct Oracle Access). Based upon
feedback from our customers and our own limited experience it is the best
data access component set to use when connecting Delphi to Oracle.

The BDE blob problems can be solved by increasing the MaxBlobSize and
BlobsToCache settings for the connection. These are BDE settings, they do
not apply to other connectivity solutions.




Cheers,

--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com