Recent

Author Topic: TPQConnection  (Read 11847 times)

notebook

  • New Member
  • *
  • Posts: 21
TPQConnection
« on: August 05, 2011, 09:25:51 pm »
Does TPQConnection work with postgresql 9.x?

I can't try.


How I can set port for postgresql database if I use TPQConnection  component?
« Last Edit: August 05, 2011, 09:38:32 pm by notebook »

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: TPQConnection
« Reply #1 on: August 05, 2011, 09:41:20 pm »
Why can't you try? What documentation have you looked at? What went wrong?

My crystal ball is broken...
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

goodname

  • Sr. Member
  • ****
  • Posts: 297
Re: TPQConnection
« Reply #2 on: August 05, 2011, 09:49:15 pm »
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

  • New Member
  • *
  • Posts: 21
Re: TPQConnection
« Reply #3 on: August 05, 2011, 10:06:18 pm »
Why 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.
« Last Edit: August 05, 2011, 10:10:13 pm by notebook »

Leledumbo

  • Hero Member
  • *****
  • Posts: 8836
  • Programming + Glam Metal + Tae Kwon Do = Me
Re: TPQConnection
« Reply #4 on: August 05, 2011, 11:55:10 pm »
Quote
On 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

  • New Member
  • *
  • Posts: 21
Re: TPQConnection
« Reply #5 on: August 06, 2011, 09:07:06 am »
Quote
On 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

  • New Member
  • *
  • Posts: 16
Re: TPQConnection
« Reply #6 on: August 08, 2011, 10:11:39 pm »
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

 

TinyPortal © 2005-2018