-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Mon, 24 Mar 2008 20:14:18 -0700 (PDT) J Ottery <jottery@xxxxxxxxxxxxxxxxx> wrote: > I am using a grid component (delphi) connected via Postgres ODBC , and > via Datasource - ADOTable - ADOConnection to a postgres database. > All works well. > Tried using the PostgreSQL Native Provider, built a working > connection string. > It connects OK but I have only read access to the data (in the grid I > cannot edit or add any rows). > I have also tried several other OLEDB providers but they all exhibit > the same behaviour. > > Why does ODBC work and PostgreSQL Native Provider (or other OLEDB's) > not work? My guess is that ODBC is better supported and developed. Since you are using Delphi have you considered the .Net driver, I believe Delphi now supports it. Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFH6HHMATb/zqfZUUQRAgtsAJ9LHqY3W2D3mTMyYEQn0np91kRZKACfeQ2F Iqni6oDIeRoe+JHXGrQc+I0= =M564 -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general