Getting a list of SIDs

[jpickup]

Is there anyway of getting a list of available SIDs using the DOA components?

I'm looking for somthing similar to BDE's Session.GetAliasNames.

This is clearly done internally in the login component...

Thanks,
John.

 

[Marco Kalter]

In version 3.4 you can call the OracleAliasList function:

From the User's Guide:
function OracleAliasList: TStringList;

Returns a TStringList instance with database aliases as defined in the tnsnames.ora file. Don't free this list, it is used internally by the TOracleSession.LogonDatabase property and the TOracleLogon dialog. This function first initializes OCI by calling InitOCI, because it needs to know if Net8 is used.

------------------
Marco Kalter
Allround Automations

 

[jpickup]

Thanks!