Board index » delphi » Getting additional Alias info about an Oracle 7.3 database

David Saracin

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Getting additional Alias info about an Oracle 7.3 database

Hello All,

How can you get all of the information about a BDE alias that's pointing to
an Oracle 7.3 database?  I know that the "driver" information is stored in
the Registry, but it appears that the actual alias info is stored in the
IDAPI32.cfg.  Specifically, if my application (via TDatabase) cannot connect
to Oracle, I want to be able to log a bunch of information to a file so that
the client can send it to me (and I don't have to spend a bunch of time on
the phone).  It would be very helpful, if I could get the "SERVER NAME"
information from the BDE.

NOTE: if you do a dbiGetDatabaseDesc for an Oracle database, szPhyName is
empty.

Hope someone can help.

Best Regards,

David Saracini

 
Neil Poulto

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Getting additional Alias info about an Oracle 7.3 database


David,

Have a look at TSession.GetAliasParams

Neil

Quote
"David Saracini" <sarac...@mtrack.com> wrote in message

news:39ca55b0_2@dnews...
Quote
> Hello All,

> How can you get all of the information about a BDE alias that's pointing
to
> an Oracle 7.3 database?  I know that the "driver" information is stored in
> the Registry, but it appears that the actual alias info is stored in the
> IDAPI32.cfg.  Specifically, if my application (via TDatabase) cannot
connect
> to Oracle, I want to be able to log a bunch of information to a file so
that
> the client can send it to me (and I don't have to spend a bunch of time on
> the phone).  It would be very helpful, if I could get the "SERVER NAME"
> information from the BDE.

> NOTE: if you do a dbiGetDatabaseDesc for an Oracle database, szPhyName is
> empty.

> Hope someone can help.

> Best Regards,

> David Saracini

Other Threads

1. Getting additional Alias info about an Oracle 7.3 database

2. Problems using BDE 5.01 and Oracle 8 drivers reading Oracle 7.3 databases

3. Oracle 7.3 - Delphi 3.0 Getting Dataset from a SP

4. Problem with oracle 7.3 database when deleting records

5. D3 Oracle 7.3 External exception on database component connect

6. Oracle 7.3 database with character set WE8PC850

7. Delphi Applications Issues When Migrating from Oracle 7.3 to Oracle 8.0

8. Problems with float and Oracle 7.3 and Oracle ODBC 2.5

9. Delphi Applications Issues When Migrating from Oracle 7.3 to Oracle 8.0

10. How to get info about database related to alias