Recent

Author Topic: Can't connect to database (URGENT)  (Read 6978 times)

Nunovsky

  • Newbie
  • Posts: 4
Can't connect to database (URGENT)
« on: May 24, 2011, 10:04:40 pm »
Hi guys and girls,

I have a problem..
I am using a TPQConnection on a form and when i put the Connected option on the Property box on 'True', appears a box with the following error:

PQConnection1: Connection to database failed(PostgreSQL:fe_sendauth: authentication type 5 not supported)
 
can somebody help me? Please?

I have postgresql installed on my machine and i am trying to connect to a database locally...

All answers are very welcome

davesimplewear

  • Sr. Member
  • ****
  • Posts: 319
    • Davids Freeware
Re: Can't connect to database (URGENT)
« Reply #1 on: May 25, 2011, 09:04:01 am »
what version of postgres do you have installed as it sounds like a version conflict
All things considered insanity seems the best option

Nunovsky

  • Newbie
  • Posts: 4
Re: Can't connect to database (URGENT)
« Reply #2 on: May 25, 2011, 10:05:20 am »
I've installed the 2.2.4 version of Free Pascal...

JD

  • Hero Member
  • *****
  • Posts: 1848
Re: Can't connect to database (URGENT)
« Reply #3 on: May 25, 2011, 10:11:16 am »
I've installed the 2.2.4 version of Free Pascal...

What version of Postgres? Version 8.x, 9.x? You have to be specific.
Windows - Lazarus 2.1/FPC 3.2 (built using fpcupdeluxe),
Linux Mint - Lazarus 2.1/FPC 3.2 (built using fpcupdeluxe)

mORMot; Zeos 8; SQLite, PostgreSQL & MariaDB; VirtualTreeView

Nunovsky

  • Newbie
  • Posts: 4
Re: Can't connect to database (URGENT)
« Reply #4 on: May 25, 2011, 10:37:16 am »
It´s the 9.0.4-1 windows version of postgreSQL

eny

  • Hero Member
  • *****
  • Posts: 1634
Re: Can't connect to database (URGENT)
« Reply #5 on: May 25, 2011, 11:53:15 am »
I've installed the 2.2.4 version of Free Pascal...
It would be a good idea to upgrade to the latest stable Lazarus vesion (0.9.30 with FPC 2.4.2).
All posts based on: Win10 (Win64); Lazarus 2.0.10 'stable' (x64) unless specified otherwise...

JD

  • Hero Member
  • *****
  • Posts: 1848
Re: Can't connect to database (URGENT)
« Reply #6 on: May 25, 2011, 12:33:11 pm »
It´s the 9.0.4-1 windows version of postgreSQL

Like eny said, update your version of Lazarus & try to connect to your database again.
Windows - Lazarus 2.1/FPC 3.2 (built using fpcupdeluxe),
Linux Mint - Lazarus 2.1/FPC 3.2 (built using fpcupdeluxe)

mORMot; Zeos 8; SQLite, PostgreSQL & MariaDB; VirtualTreeView

 

TinyPortal © 2005-2018