Recent

Author Topic: The last dated version of 0.9.3.2 to win64 doesn't come with postgres connection  (Read 6325 times)

everton

  • Jr. Member
  • **
  • Posts: 89
The last dated version of 0.9.3.2 to win64 doesn't come with the postgres connection.

Anybody, know something about it?

everton

  • Jr. Member
  • **
  • Posts: 89
I'll try to reinstall.

everton

  • Jr. Member
  • **
  • Posts: 89
I've reinstall but againt the TPQConnection is missing.

Is only here, or have happen also with some friend?

marcov

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 8583
  • FPC developer.
Install the sqldb package.

elidorio

  • Sr. Member
  • ****
  • Posts: 295
I am also having the same problem.
Lazarus and I'm using windows 7 64 09.30.4.
Ja SQLdb reinstalled and still does not appear access to Postgresql.
Can anyone help me.
Lazarus 1.4.4 | FPC 2.6.4 | Windows / Linux Debian

Leledumbo

  • Hero Member
  • *****
  • Posts: 8244
  • Programming + Glam Metal + Tae Kwon Do = Me
In registersqldb.pas, top lines:
Code: [Select]
{$IFNDEF win64}
{$DEFINE HASMYSQL4CONNECTION}
{$DEFINE HASORACLECONNECTION}
{$DEFINE HASPQCONNECTION} // <--
{$DEFINE HASSQLITE3CONNECTION}
{$ENDIF}
So I guess it's not supported somehow. Anyway, I'm using SQLite3 compiled for Win64 (but I use it through tiOPF) and it works. So you might want to try add the define and test yourself.

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Postgresql connector and some other database connectors are disabled on win64 builds.
Recently mssqlconn (MS SQL Server and Sybase ASE) connector was enabled.
IIRC, Oracle is still disabled.

See e.g.
http://www.mail-archive.com/fpc-pascal@lists.freepascal.org/msg28003.html
and
http://www.mail-archive.com/fpc-pascal@lists.freepascal.org/msg28025.html

Edit: I found the same entries in registersqldb.pas things as Lacak...
Perhaps you can just enable it and use a 64 bit posgresql client (see one of the threads I quoated above). If it works, you can easily submit a patch to the bug tracker...
« Last Edit: April 10, 2012, 02:42:48 pm by BigChimp »
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

marcov

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 8583
  • FPC developer.
Note that these components were not enabled because never has tested them.

If you want to see them enabled, search for an appropriate 64-bit clientlib and then test. If the test is succesful, rapport your findings to the bugtracker (in a way that can be easily reproducable), and we'll see about enabling them.

With mssql it went that way. First disabled, then enabled when it was shown that it worked.

elidorio

  • Sr. Member
  • ****
  • Posts: 295
How do I enable the connection to Postgresql?
Lazarus 1.4.4 | FPC 2.6.4 | Windows / Linux Debian

marcov

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 8583
  • FPC developer.
How do I enable the connection to Postgresql?

Just compile it manually or edit the list of OSes per database in packages/fcl-db/fpmake.pp (2.7.1/trunk) and rebuild.

 

TinyPortal © 2005-2018