X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 669995282C for ; Thu, 16 Jun 2005 09:32:24 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30272-07 for ; Thu, 16 Jun 2005 12:32:13 +0000 (GMT) Received: from mail.idilis.net (mail.idilis.net [217.156.85.2]) by svr1.postgresql.org (Postfix) with ESMTP id E9B5852942 for ; Thu, 16 Jun 2005 09:32:09 -0300 (ADT) Received: from [82.76.228.65] (helo=adi) by mail.idilis.net with asmtp id 1DitXI-0001Na-00; Thu, 16 Jun 2005 15:31:56 +0300 To: "Postgres Admin" Cc: dedy , "PostgreSQL - SQL" Subject: Re: PostgreSQL and Delphi 6 References: <42B0F6C9.7020008@productivitymedia.com> <42B16C14.80301@productivitymedia.com> Message-ID: Date: Thu, 16 Jun 2005 15:31:27 -0700 From: Din Adrian Organization: OMC Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <42B16C14.80301@productivitymedia.com> User-Agent: Opera M2/7.54 (Win32, build 3929) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.687 tagged_above=0 required=5 tests=AWL, DATE_IN_FUTURE_06_12 X-Spam-Level: X-Archive-Number: 200506/184 X-Sequence-Number: 21785 Yes, the client must have the psqlodbc driver and mdac at least 2.6. (Mdac2.5 is verry buggy - attention win2000 and win9x must be upgraded if you need mdac for your app). When using server side cursors for a dataset the update and delete functions act 'strange' as not refreshing corect the affected rows or by showing ony ane record for 20 times instead of 20 different records ... (this test was done with psqlodbc8.0 - postgresql DB 8.0 - I think my colegs didn't test it with 8.1 yet !! ). So we are using client side cursors - slower then server side cursors, but we are satified with the results (we are developing a big ERP app for two years - it also works over internet on 2-3 clients with relative slow net connections : 56-128 Kb/s). Adrian Din, Om Computer & Software, Bucuresti,Romania On Thu, 16 Jun 2005 08:09:56 -0400, Postgres Admin wrote: > So you installed psqlodbc 8 on the client machine with Delphi installed, > correct? What problems did you have with cursors? Any other > suggestions? > > Thanks a lot for the help! > J > > Din Adrian wrote: >> we are using postgresql8 +psqlodbc8+ delphi7 ... the only problem is >> the server side cursor = doesn't work properly ... so we are using >> client side for datasets .... :) >> >> > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/