I am trying to write a logon form where the form asks the user whether to connect local or remote-client/server.  If remote,  it asks for the IP address and port, then goes out and gets the available databases for that IP address.  Then they pick the database, and then it attempts to connect the user to that database.  I am having a problem getting the correct database names.

I have tried to use GetRemoteDatabaseNames, and it does require a logon to the remote database, but it does not retrieve the available databases from the remote database, it retrieves the names of all TDBISAMDatabase components linked to the session via their SessionName property, specifically the TDBISAMDatabase DatabaseName property.  If I leave that blank, it retrieves nothing.      

I tried to find my answer in the database system utility, but it is way too complicated for me.  

Can anybody shed some light on getting remote database names from a remote server?

On 3/26/2014 6:58 PM, Owen wrote:
> I have tried to use GetRemoteDatabaseNames, and it does require a logon to the remote database, but it does not retrieve the available databases from the remote database, it retrieves the names of all TDBISAMDatabase components linked to the session via their SessionName property, specifically the TDBISAMDatabase DatabaseName property.  If I leave that blank, it retrieves nothing.

That does not sound right.

GetRemoteDatabaseNames is exactly what you should use.

Local attached databases should only be returned by the GetDatabaseNames
function.


> Can anybody shed some light on getting remote database names from a remote server?
This works here. You need 1 dbisam session object called s1 and one memo
control:

 s1.SessionType := stRemote;
 s1.RemoteAddress := '127.0.0.1';
 s1.RemotePort := 12005;
 s1.RemoteUser := 'admin';
 s1.RemotePassword := 'DBAdmin';
 s1.Open;
 s1.GetRemoteDatabaseNames( memo1.Lines );
 s1.Close;

Raul

Raul wrote:

On 3/26/2014 6:58 PM, Owen wrote:
> I have tried to use GetRemoteDatabaseNames, and it does require a logon to the remote database, but it does not retrieve the available databases from the remote database, it retrieves the names of all TDBISAMDatabase components linked to the session via their SessionName property, specifically the TDBISAMDatabase DatabaseName property.  If I leave that blank, it retrieves nothing.

That does not sound right.

GetRemoteDatabaseNames is exactly what you should use.

Local attached databases should only be returned by the GetDatabaseNames
function.


> Can anybody shed some light on getting remote database names from a remote server?
This works here. You need 1 dbisam session object called s1 and one memo
control:

 s1.SessionType := stRemote;
 s1.RemoteAddress := '127.0.0.1';
 s1.RemotePort := 12005;
 s1.RemoteUser := 'admin';
 s1.RemotePassword := 'DBAdmin';
 s1.Open;
 s1.GetRemoteDatabaseNames( memo1.Lines );
 s1.Close;

Raul


Woops - My code had GetDatabaseNames so it works as your describe.