Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Data Access Error

edited October 2002 in End User
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

Comments

  • edited October 2002
    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

  • edited October 2002
    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.
    -------------------------




  • edited October 2002

    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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.