Recent

Author Topic: postgres 9 ? (Zeos)  (Read 8400 times)

TurboRascal

  • Hero Member
  • *****
  • Posts: 672
  • "Good sysadmin. Bad programmer."™
postgres 9 ? (Zeos)
« on: February 05, 2011, 01:53:17 am »
I've tried to access a PostgreSQL 9.0.2 database server, both using TPSQLConnection (from Lazarus version 0.28.2) and using ZeosDBO 6.6.6. (tried protocol 'postgres' since 'postgres7' and 'postgres8' obviously wouldn't work), but both failed to load postgres client DLL (on Windows). Tried it on the same machine where postgres is installed, so any missing DLL's should't be a problem.

So the question is, is there a way I can connect to the postgres 9?
« Last Edit: February 09, 2011, 12:41:51 pm by marcov »
Regards, ArNy the Turbo Rascal
-
"The secret is to give them what they need, not what they want." - Scotty, STTNG:Relics

Marc

  • Administrator
  • Hero Member
  • *
  • Posts: 2512
Re: postgres 9 ?
« Reply #1 on: February 05, 2011, 04:34:22 pm »
why is it obviously that a postgres8 connection won't work ? Did you try ?
//--
{$I stdsig.inc}
//-I still can't read someones mind
//-Bugs reported here will be forgotten. Use the bug tracker

TurboRascal

  • Hero Member
  • *****
  • Posts: 672
  • "Good sysadmin. Bad programmer."™
Re: postgres 9 ?
« Reply #2 on: February 05, 2011, 06:27:21 pm »
Uhm, I just assumed so, because there exist different protocols for different versions.  :-[

I'm not sure if it is an issue though, both controls complained about problem with client DLL, not connection...?
Regards, ArNy the Turbo Rascal
-
"The secret is to give them what they need, not what they want." - Scotty, STTNG:Relics

Marc

  • Administrator
  • Hero Member
  • *
  • Posts: 2512
Re: postgres 9 ?
« Reply #3 on: February 06, 2011, 02:04:31 am »
iirc a postgres 8 client can connect to a postgres 9 database

but a v9 client might have v9 specific dlls (which don't have the v8 name)
//--
{$I stdsig.inc}
//-I still can't read someones mind
//-Bugs reported here will be forgotten. Use the bug tracker

TurboRascal

  • Hero Member
  • *****
  • Posts: 672
  • "Good sysadmin. Bad programmer."™
Re: postgres 9 ?
« Reply #4 on: February 06, 2011, 02:41:03 am »
So I guess I could connect by supplying v8 client dll to the program...

I wonder when will v9 client dlls be supported by Lazarus components...
Regards, ArNy the Turbo Rascal
-
"The secret is to give them what they need, not what they want." - Scotty, STTNG:Relics

TurboRascal

  • Hero Member
  • *****
  • Posts: 672
  • "Good sysadmin. Bad programmer."™
Re: postgres 9 ?
« Reply #5 on: February 08, 2011, 10:36:13 pm »
I managed to identify the problem in the meantime.

Another DLL upon which the client DLL depends was missing, obviously it simply refused to load without it. The message about missing DLL which was really present confused me.
Regards, ArNy the Turbo Rascal
-
"The secret is to give them what they need, not what they want." - Scotty, STTNG:Relics

Marc

  • Administrator
  • Hero Member
  • *
  • Posts: 2512
Re: postgres 9 ?
« Reply #6 on: February 09, 2011, 12:25:21 am »
so you were able to connect using v9 client dlls ?
//--
{$I stdsig.inc}
//-I still can't read someones mind
//-Bugs reported here will be forgotten. Use the bug tracker

TurboRascal

  • Hero Member
  • *****
  • Posts: 672
  • "Good sysadmin. Bad programmer."™
Re: postgres 9 ?
« Reply #7 on: February 09, 2011, 12:58:45 am »
Yes, both by using the TPQConnection and TZConnect (set simply to "postgres" protocol). Accessing it via TZTable provoked a crash though, I'm not sure if it is due to problems with pg 9 or maybe the OS being Win7 x64... That worked fine on another machine with WinXP and pg 8.4.

BTW another question, TZQuery locks up on both machines, although I only did a "select * ..." which works fine with the builtin TSQLQuery and the same  worked fine with TZTable (on XP + pg 8.4). Why might that happen?
Regards, ArNy the Turbo Rascal
-
"The secret is to give them what they need, not what they want." - Scotty, STTNG:Relics

 

TinyPortal © 2005-2018