Lazarus

Programming => Databases => Topic started by: Stan17 on July 06, 2022, 07:28:13 am

Title: Lazarus Data Desktop - Postgres connection missing
Post by: Stan17 on July 06, 2022, 07:28:13 am
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?
Title: Re: Lazarus Data Desktop - Postgres connection missing
Post by: Stan17 on July 06, 2022, 08:06:15 am
After looking into reglddfeatures.pp:
Code: Pascal  [Select][+][-]
  1. procedure registerengines;
  2.  
  3. begin
  4. {$ifndef win64}
  5.   RegisterFBDDEngine;
  6.   RegisterMySQL40DDEngine;
  7.   RegisterMySQL41DDEngine;
  8.   RegisterMySQL50DDEngine;
  9.   RegisterMySQL51DDEngine;
  10.   RegisterMySQL55DDEngine;
  11. {$ifdef HAVEMYSQL5657CONN}
  12.   RegisterMySQL56DDEngine;
  13.   RegisterMySQL57DDEngine;
  14. {$endif}
  15.   RegisterOracleDDEngine;
  16.   RegisterPostgreSQLDDengine;
  17. {$endif}
  18.   RegisterSQLite3DDEngine;
  19.   RegisterODBCDDengine;
  20. {$IFDEF HAVEMSSQLCONN}
  21.   RegisterMSSQLDDEngine;
  22. {$ENDIF}
  23. end;
Is it because Postgres and Oracle are not supported on Win 64?
Title: Re: Lazarus Data Desktop - Postgres connection missing
Post by: Jonvy on July 08, 2022, 11:02:14 am
Yes,I also find this issue, I hope to connected to postgres also.
Title: Re: Lazarus Data Desktop - Postgres connection missing
Post by: wp on July 08, 2022, 11:25:52 am
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...
Title: Re: Lazarus Data Desktop - Postgres connection missing
Post by: Stan17 on July 19, 2022, 09:48:22 pm
Because I have WIN64 sytem with Postgres 64 installed, obviously.
Title: Re: Lazarus Data Desktop - Postgres connection missing
Post by: LacaK on July 23, 2022, 11:31:52 am
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
TinyPortal © 2005-2018