Re: [SQL] PostgreSQL and Delphi 6

2005-07-07 Thread Mathew Winters
I am a bit late posting, I use Zeos DBO controls, they can be found on sourceforge.. I actually use the V5 of the components with some bug fixes I done myself, but my project is too far along to change to the newer components.. They are free and all source provided.. :) Postgres Admin wrote:

Re: [SQL] PostgreSQL and Delphi 6

2005-06-16 Thread grupos
Hi Adrian! Yes, the user have to wait until the refresh finishes... That's a problem but we didn't found any other solution... Regards, Rodrigo Carvalhaes Din Adrian wrote: I am sorry - I don't understand (or my english is bad or I don't know what you mean). What we did was include one

Re: [SQL] PostgreSQL and Delphi 6

2005-06-16 Thread Din Adrian
I am sorry - I don't understand (or my english is bad or I don't know what you mean). What we did was include one "refresh" button and inserted one configuration that after x seconds the component refresh the screen (query). So: When the user push the 'post' button the driver automatical

Re: [SQL] PostgreSQL and Delphi 6

2005-06-16 Thread grupos
Hi Adrian, You're right. What we did was include one "refresh" button and inserted one configuration that after x seconds the component refresh the screen (query). If you find a better solution, please inform me. Regards, Rodrigo Din Adrian wrote: We tested also (pgExpress Driver) - is fa

Re: [SQL] PostgreSQL and Delphi 6

2005-06-16 Thread Din Adrian
We tested also (pgExpress Driver) - is faster then psqlodbc but we have a problem with it: it does requery (or refresh? - I don't remember exactly) after every post in database.(for us this is a problem - if you have more then 10.000 in current dataset loaded when you add a new record and pos

Re: [SQL] PostgreSQL and Delphi 6

2005-06-16 Thread grupos
Hi J! We use here vitavoom from Steve Howe (www.vitavoom.com). It's a very good and native alternative. It's paid but not expensive and you will have a very good and qualified technical supporte. Regards, Rodrigo Carvalhaes Postgres Admin wrote: I have a client who wants to use Delphi as

Re: [SQL] PostgreSQL and Delphi 6

2005-06-16 Thread Din Adrian
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

Re: [SQL] PostgreSQL and Delphi 6

2005-06-16 Thread Postgres Admin
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 = doe

Re: [SQL] PostgreSQL and Delphi 6

2005-06-16 Thread Din Adrian
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 :) On Wed, 15 Jun 2005 23:49:29 -0400, Postgres Admin <[EMAIL PROTECTED]> wrote: I have a client who wants to use Delphi

[SQL] PostgreSQL and Delphi 6

2005-06-15 Thread Postgres Admin
I have a client who wants to use Delphi as a front end to a Database, I would like to use PostgreSQL over MSSQL and have been looking at the psqlodbc project. Will psqlodbc connect with Delphi 6? Basically, I'm wondering if anyone has experience with it? Any help will be appreciated. Thanks, J