Data Access Error

rbuser

Hi...

I am using Delphi-6 with RB7 Enterprise.
Connected to an Oracle-9i Database using a DOA session.
On one PC only when I try to run the "Query Wizard" instead of seeing a list
of all accessible tables in Oracle9 I am getting
"List Index Out Of Bounds (0)" !!!???

The same programme, accessing the same Oracle-9i database, on other PCs
works fine.

What's could be causing this?
The rest of the application (also using the DOA components) works ok. Just
report builder cannot connect to the data?


Many Thanks

Shahine
Compucorp Ltd.
Shahine@Compucorp.co.uk

digitalmetaphors

You probalby have everything configured correctly if your other machines and
users can connect. Does this problematic machine/user have access rights to
the tables? Perhaps there are no tables that this user can access? Create a
small test application that only sends a query that returns the table names
on a list control in a TForm. It should be able to perform this operation
if the user can connect. The SQL which DADE uses to retrieve the tables
names is located in the daDOA.pas file in the method
TdaDOASession.GetTableNames. Use the same username and password and
database for this test app that you are trying to use in your full app when
you connect.

It should not show list index out of bounds. Once you can prove that the
user can connect and that the table names are returned then we can see why
the plugin or DADE is failing to use these table names.

Cheers,

Jim Bennett
Digital Metaphors

rbuser

Hi Jim,

This machine/user connects to Oracle using DOA components ok.
I can add,query,update,insert,etc.., through the application.
All the Delphi data forms are linked to the same DOA session that RBuilder
uses.
It's only in RBuilder, when I try to connect I get this error.
And only on this one machine. Logging in as the user "system" or "sys" makes
no difference either.

This Oracle database has a large number of tables/view (100+).
I wrote a test application + test database with 5 tables and RBuilder worked
OK ???
So is it the number of tables/views that is causing the problem?
but then why does it work on other machines ok?

Incidentally - Can I modify DADE to only get the tables from a given Schema?

Many Thanks


Shahine
Compucorp Ltd.
-------------------------

nardmoseley

All of the DOA code is locatd in daDOA.pas. The code is fairly simple and
straight forward. See the DADE thread of the tech tips newsgroup for an
overview of the architecture. You could easily customize the
Session.GetTableNames method to do whatever you want.


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