Recent

Author Topic: Lazarus Data Desktop - Postgres connection missing  (Read 1155 times)

Stan17

  • Newbie
  • Posts: 6
Lazarus Data Desktop - Postgres connection missing
« 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?

Stan17

  • Newbie
  • Posts: 6
Re: Lazarus Data Desktop - Postgres connection missing
« Reply #1 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?

Jonvy

  • Jr. Member
  • **
  • Posts: 90
Re: Lazarus Data Desktop - Postgres connection missing
« Reply #2 on: July 08, 2022, 11:02:14 am »
Yes,I also find this issue, I hope to connected to postgres also.

wp

  • Hero Member
  • *****
  • Posts: 11856
Re: Lazarus Data Desktop - Postgres connection missing
« Reply #3 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...

Stan17

  • Newbie
  • Posts: 6
Re: Lazarus Data Desktop - Postgres connection missing
« Reply #4 on: July 19, 2022, 09:48:22 pm »
Because I have WIN64 sytem with Postgres 64 installed, obviously.

LacaK

  • Hero Member
  • *****
  • Posts: 691
Re: Lazarus Data Desktop - Postgres connection missing
« Reply #5 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
« Last Edit: July 28, 2022, 10:02:21 am by LacaK »

 

TinyPortal © 2005-2018