From: Din Adrian <adrian.din@easynet.ro>
To: Postgres Admin <postgres@productivitymedia.com>
Cc: dedy <slackman@unika.ac.id>
Cc: PostgreSQL - SQL <pgsql-sql@postgresql.org>
Subject: Re: PostgreSQL and Delphi 6
Date: Thu, 16 Jun 2005 15:31:27 -0700
Message-ID: <opsshh6pxpawcxfg@adi> (raw)
In-Reply-To: <42B16C14.80301@productivitymedia.com>
References: <42B0F6C9.7020008@productivitymedia.com>
<opssg3c3qrawcxfg@adi>
<42B16C14.80301@productivitymedia.com>
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
<postgres@productivitymedia.com> 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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adrian.din@easynet.ro, postgres@productivitymedia.com, slackman@unika.ac.id
Subject: Re: PostgreSQL and Delphi 6
In-Reply-To: <opsshh6pxpawcxfg@adi>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox