Lazarus

Installation => Windows (32/64) => Topic started by: everton on November 10, 2011, 09:17:44 pm

Title: The last dated version of 0.9.3.2 to win64 doesn't come with postgres connection
Post by: everton on November 10, 2011, 09:17:44 pm: The last dated version of 0.9.3.2 to win64 doesn't come with the postgres connection.

Anybody, know something about it?
Title: Re: The last dated version of 0.9.3.2 to win64 doesn't come with postgres connection
Post by: everton on November 11, 2011, 03:22:22 pm: I'll try to reinstall.
Title: Re: The last dated version of 0.9.3.2 to win64 doesn't come with postgres connection
Post by: everton on November 11, 2011, 03:28:49 pm: I've reinstall but againt the TPQConnection is missing.

Is only here, or have happen also with some friend?
Title: Re: The last dated version of 0.9.3.2 to win64 doesn't come with postgres connection
Post by: marcov on November 11, 2011, 04:08:26 pm: Install the sqldb package.
Title: Re: The last dated version of 0.9.3.2 to win64 doesn't come with postgres connection
Post by: elidorio on April 10, 2012, 01:39:34 pm: 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.
Title: Re: The last dated version of 0.9.3.2 to win64 doesn't come with postgres connection
Post by: Leledumbo on April 10, 2012, 02:27:44 pm: 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.
Title: Re: The last dated version of 0.9.3.2 to win64 doesn't come with postgres connection
Post by: BigChimp on April 10, 2012, 02:40:35 pm: 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 (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 (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...
Title: Re: The last dated version of 0.9.3.2 to win64 doesn't come with postgres connection
Post by: marcov on April 10, 2012, 04:44:10 pm: 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.
Title: Re: The last dated version of 0.9.3.2 to win64 doesn't come with postgres connection
Post by: elidorio on April 11, 2012, 04:50:20 am: How do I enable the connection to Postgresql?
Title: Re: The last dated version of 0.9.3.2 to win64 doesn't come with postgres connection
Post by: marcov on April 11, 2012, 07:17:03 am: Quote from: elidorio on April 11, 2012, 04:50:20 am
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.