GetServerList() Method

In This Topic

Returns an array of available TNS aliases.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Shared Function GetServerList() As String()

public static string[] GetServerList()

Return Value

An array of available TNS aliases.

Remarks

Use GetServerList() function to read TNS aliases from TNSNAMES.ORA configuration file found in Oracle default home directory.

Example

The following example obtains and then prints list of the servers.

csharp

public void DisplayServerList()
{
  string[] serverList = OracleConnection.GetServerList();
  foreach (string server in serverList)
  Console.WriteLine(server);
}

Visual Basic

Public Sub DisplayServerList()
  Dim serverList As String() = OracleConnection.GetServerList()
  Dim server As String
  For Each server In  serverList
    Console.WriteLine(server)
  Next server
End Sub 'DisplayServerList

Reference

OracleConnection Class
OracleConnection Members
Overload List

Send Feedback