Обсуждение: Delphi 2005 & ZEOS Lib
Hi, I read a lot of good reviews regarding Delphi and ZEOS Lib, and I'm testing during 30 days. Was anyone able to use ZEOS latest version (6.5.1 alpha) with Delphi 2005 in order to Access Postgresql 7.4 / 8.0? I'm sorry this forum is normally for ODBC only, but... Thanks ---------------------------------- Philippe Lang
> Hi, > > I read a lot of good reviews regarding Delphi and ZEOS Lib, and I'm > testing during 30 days. > > Was anyone able to use ZEOS latest version (6.5.1 alpha) with Delphi > 2005 in order to Access Postgresql 7.4 / 8.0? I'm sorry this forum is > normally for ODBC only, but... Yes. 6.5.1 is ok. Some of the non pg drivers (especially ado) are a little buggy. The zeoslib.net site is coming back very soon...you should be able to go there for better info. Merlin
Hi, thanks for your answer, I made one or two quick tests, and yes, this works pretty fine. The installation caused me some problems, but everythingis running fine since then. Is there anything we should be aware of when using Delphi and ZEOS with Postgresql 8.0, compared to ODBC, for example? Likea limitation or anything like this? I have seen PG 7.4 protocol support in ZEOS, but correct me if I'm wrong, the PG8.0 protocol is similar, right? Thanks Philippe -----Message d'origine----- De : pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] De la part de Merlin Moncure Envoyé : vendredi, 6. mai 2005 15:58 À : Philippe Lang Cc : pgsql-odbc@postgresql.org Objet : Re: [ODBC] Delphi 2005 & ZEOS Lib > Hi, > > I read a lot of good reviews regarding Delphi and ZEOS Lib, and I'm > testing during 30 days. > > Was anyone able to use ZEOS latest version (6.5.1 alpha) with Delphi > 2005 in order to Access Postgresql 7.4 / 8.0? I'm sorry this forum is > normally for ODBC only, but... Yes. 6.5.1 is ok. Some of the non pg drivers (especially ado) are a little buggy. The zeoslib.net site is coming back very soon...you should be able to go there for better info. Merlin ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
> I made one or two quick tests, and yes, this works pretty fine. The > installation caused me some problems, but everything is running fine since > then. > > Is there anything we should be aware of when using Delphi and ZEOS with > Postgresql 8.0, compared to ODBC, for example? Like a limitation or > anything like this? I have seen PG 7.4 protocol support in ZEOS, but > correct me if I'm wrong, the PG 8.0 protocol is similar, right? Zeos 6.1.x and 6.5.x are a built around libpq 7.4. The last major protocol revision in pg was 7.3 IIRC. The pg support of Zeos is pretty good, I personally worked on testing and fixes for the pg driver during for Zeos 6.0 and 6.1. The earlier versions had problems with arrays, not sure about the newer ones since I don't happen to be doing anything with Zeos at this particular moment. In your other mail you asked about Crystal Reports. I've never actually used CR with Delphi, but I'm assuming it makes its own independent connection to the database. In this case, yes it will require the ODBC driver but you should not have too many problems...you are not using the BDE. If there is some sort of reliance on the BDE dataset objects (TDataset, TTable), then I'd suggest dumping CR and picking up Ace Reporter. You have looked at Ace Reporter, right? :-). Merlin
Hi, I have just looked at Ace Reporter. Yes, it can use an ZEOS connection to Delphi, but I wasn't very lucky, because aftera few minutes, I got a stack overflow with Ace Reporter.... I think I'll use CR with ODBC, that's not too bad actually... -----Message d'origine----- De : pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] De la part de Merlin Moncure Envoyé : lundi, 9. mai 2005 14:29 À : Philippe Lang Cc : pgsql-odbc@postgresql.org Objet : Re: [ODBC] Delphi 2005 & ZEOS Lib > I made one or two quick tests, and yes, this works pretty fine. The > installation caused me some problems, but everything is running fine since > then. > > Is there anything we should be aware of when using Delphi and ZEOS with > Postgresql 8.0, compared to ODBC, for example? Like a limitation or > anything like this? I have seen PG 7.4 protocol support in ZEOS, but > correct me if I'm wrong, the PG 8.0 protocol is similar, right? Zeos 6.1.x and 6.5.x are a built around libpq 7.4. The last major protocol revision in pg was 7.3 IIRC. The pg supportof Zeos is pretty good, I personally worked on testing and fixes for the pg driver during for Zeos 6.0 and 6.1. Theearlier versions had problems with arrays, not sure about the newer ones since I don't happen to be doing anything withZeos at this particular moment. In your other mail you asked about Crystal Reports. I've never actually used CR with Delphi, but I'm assuming it makes itsown independent connection to the database. In this case, yes it will require the ODBC driver but you should not havetoo many problems...you are not using the BDE. If there is some sort of reliance on the BDE dataset objects (TDataset,TTable), then I'd suggest dumping CR and picking up Ace Reporter. You have looked at Ace Reporter, right? :-). Merlin ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend