TPQConnection
lazarus / 16-Databases

----------------------------------------------------------------------
notebook · 2011-08-05 19:25

Does TPQConnection work with postgresql 9.x?

I can't try.


How I can set port for postgresql database if I use TPQConnection 
component?

----------------------------------------------------------------------
BigChimp · 2011-08-05 19:41

Why can't you try? What documentation have you looked at? What went
wrong?

My crystal ball is broken...

----------------------------------------------------------------------
goodname · 2011-08-05 19:49

Yes. If your on windows use the following dll files that comes with
PostgreSQL 9. The Version 9 dll's will connect to 8.4 databases. Do
not know the exact files required if your using Mac or Linux.

libpq.dll, ssleay32.dll,libeay32.dll,libintl-8.dll,libiconv-2.dll"

Port
http://wiki.lazarus.freepascal.org/Lazarus_DB_Faq#PostgreSQL

----------------------------------------------------------------------
notebook · 2011-08-05 20:06

Quote from: BigChimp on August 05, 2011, 09:41:20 pmWhy can't you try?
What documentation have you looked at? What went wrong?

My crystal ball is broken...

On linux I have postgresql 8.x.
On win 7 I have postgresql 9.x, but in lazarus there isn't
TPQConnection component on win 7.

----------------------------------------------------------------------
Leledumbo · 2011-08-05 21:55

QuoteOn win 7 I have postgresql 9.x, but in lazarus there isn't
TPQConnection component on win 7.Well... do you have SQLdb package
installed?

----------------------------------------------------------------------
notebook · 2011-08-06 07:07

Quote from: Leledumbo on August 05, 2011, 11:55:10 pmQuoteOn win 7 I
have postgresql 9.x, but in lazarus there isn't TPQConnection
component on win 7.Well... do you have SQLdb package installed?

YES, I do.

----------------------------------------------------------------------
jacem · 2011-08-08 20:11

Are you running the 32 or 64 bit version of fpc/lazarus.  I found that
most of dbconnectors do not appear on 64 bit version.  I switched down
to 32 bit and they were all there.  If anyone knows how to get the
mysql 4.0, 4.1 or postgres connectors and sqlite3 to compile in the
win64 bit version of lazarus please make a very loud shout out.


jonathan