Devart Forums

Hi,

the GetServerList procedure, of TUniConnectDialog does not list PostgreSQL Linux servers, only Windows servers.

Why?


If I try execute GetDatabaseNames of TUniConnection with users other than "postgres" the following error occurs:

---------------------------
Project1
---------------------------
Cannot connect to database
---------------------------
OK
---------------------------

UniConnection.ProviderName := 'PostgreSQL';
UniConnection.Server := 'ServerName';
UniConnection.Username := 'test_user';
UniConnection.Password := '123456';

UniConnection.GetDatabaseNames(ListDataBase);


How can I fix this problem?

Thanks!

Hello,

This problem is connected with the fact that we are using the standard WinApi function to look for servers, and this function cannot see Linux servers.

But the GetDatabaseNames method works correctly.
I have created a new "simple" user like

CREATE ROLE test LOGIN
NOINHERIT
VALID UNTIL 'infinity';

and I got a list of avaliable databases without any errors using the GetDatabaseNames method.

Hello AlexP,

you will also implemented a search for Linux servers?

Thanks!

Hello,

It's likely that we will not implement such functionality. It's connected with the fact that third-party tools should be used to define PostgreSQL servers on Linux, or we should check all possible ports on all computers with Linux.