🚀 go-pugleaf

On Fri, 27 Apr 2001 09:50:55 -0500, "Nirmal Shrestha" <nirmals@flowcal.com>
wrote:

>Thank you for your response. But I think the real problem is  BDE is not
>registering  the Oracle tables. When I try to see the list of tables from
>BDE Explorer, It does not show me the tables. For example, I have table
>named Owner.System. And I can see list of tables Owner.S, Owner.Sy,
>Owner.Sys, Owner.Syst, Owner.Syste, Owner.System, where there should only be
>a table named Owner.System.  I can Query against the table using TQuery
>object in the program or in Enter Sql window in BDE Explorer, but I can't
>open the tables. When I double click on table name it says invalid table
>name.
>
>What do I need to do to see the Tables in BDE Explorer? Is there different
>way to register database in BDE Explorer?  Is this known issue with Oracle?

Try upgrading your ODBC drivers.  I had seen the exact same problem you
describe using Oracle v8.0.4.0 ODBC drivers,  and the problems were
resolved with an upgrade to Oracle v8.0.4.4 ODBC drivers.  I was able to
determine my problem was with the Oracle ODBC drivers by enabling the ODBC
tracing functionality and reading through the large (about 20MB) trace file
it created.  If you upgrade your ODBC driver,  your problems might be
resolved as well...

Jerry Bloomfield (TeamB)
-- 
http://www.teamb.com                                      JersWork@wwa.com
Please do *NOT* send private e-mail without prior permission (my anti-spam 
filters will probably just delete it anyway <g>)