Re: PostgreSQL and Delphi 6

    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/