Delphi DA Server - Example Needed that has multiple DB connections


(is2software) #1

For Delphi DA, is there an example anywhere that shows how to have multiple databases running at the same time.

In our case, all databases will be the same - Sybase ASA.

Our client app will login to our System database, determine if login is successful, and then provide a list of possible database for which they have rights for access.

So the login would provide the database list, and then the client would choose which database.

Most clients only have one database to access.

But as administrators, we would want to access any database available on that server.

We have this now which we have had operating for over a decade. But want to build Rem DA servers for our IOS development and then future Windows rewrites of our Windows clients.

Thanks ahead of time.
Bill


Using events in Relativity Server to change ConnectionName
(EvgenyK) #2

you can use standard MultiDbLoginService or MultiDbLoginServiceV5 service as ancestor for your Login service.

as a result, it adds for MultiDbLoginService

function Login(const aUserID: UTF8String; const aPassword: UTF8String; 
    const aConnectionName: UTF8String; out aUserInfo: UserInfo): Boolean;

or for MultiDbLoginServiceV5

function Login(const aUserID: UTF8String; const aPassword: UTF8String; 
    const aConnectionName: UTF8String; out aUserInfo: UserInfo): Boolean;
function GetConnectionNames: StringArray;
function GetDefaultConnectionName: UTF8String;

methods that can be used by client.

by other hand, you can create own replica of these methods and return list of connections and default connection only for given or logged user.