Lazarus Data Desktop - Postgres connection missing
lazarus / 16-Databases

----------------------------------------------------------------------
Stan17 · 2022-07-06 05:28

Installed Lazarus 2.2.2 x64 Windows7; compiled project LazDataDesktop;
when trying to add a connection the only available types in the list
are :DBase, MicrosoftSQL, ODBC connection, SQLite3.
README.txt from \tools\lazatadesktop claims
Quote- Connect to
  DBase
  Firebird/Interbase
  MySQL 4.0, 4.1, 5.0
  PostGreSQL
  Oracle
  SQLite
I need Postgres connection - why it is not available?

----------------------------------------------------------------------
Stan17 · 2022-07-06 06:06

After looking into reglddfeatures.pp:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i procedure
registerengines; begin{$ifndef win64}  RegisterFBDDEngine; 
RegisterMySQL40DDEngine;  RegisterMySQL41DDEngine; 
RegisterMySQL50DDEngine;  RegisterMySQL51DDEngine; 
RegisterMySQL55DDEngine;{$ifdef HAVEMYSQL5657CONN} 
RegisterMySQL56DDEngine;  RegisterMySQL57DDEngine;{$endif} 
RegisterOracleDDEngine;  RegisterPostgreSQLDDengine;{$endif} 
RegisterSQLite3DDEngine;  RegisterODBCDDengine;{$IFDEF HAVEMSSQLCONN} 
RegisterMSSQLDDEngine;{$ENDIF}end;Is it because Postgres and Oracle
are not supported on Win 64?

----------------------------------------------------------------------
Jonvy · 2022-07-08 09:02

Yes,I also find this issue, I hope to connected to postgres also.

----------------------------------------------------------------------
wp · 2022-07-08 09:25

I am not sure if this code is up-to-date, I do have a PostgreSQL
installation on my Win64, and it is working correctly. Please file a
bug report so that the responsible developer can see this issue. But
even if it can be fixed, be warned: much of the code is in the FCL,
and thus it will take quite some time until is finds its way into an
FPC release.

Why don't you build a 32-bit application? I tested it, and Postgres is
displayed...

----------------------------------------------------------------------
Stan17 · 2022-07-19 19:48

Because I have WIN64 sytem with Postgres 64 installed, obviously.

----------------------------------------------------------------------
LacaK · 2022-07-23 09:31

Yes, there is no reason, that PostgreSQL connection is not enabled for
Win64 nowadays.
It must be remainer from old times ... this define shold be removed.
(also in registersqldb.pas there is no limitation on PostgreSQL
connection)

I can fill bug report instead of you if you are not interested ...?

See: https://gitlab.com/freepascal.org/lazarus/lazarus/-/issues/39836