Re: OLEDB vs ODBC to access postgres

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Mon, 24 Mar 2008 20:14:18 -0700 (PDT)
J Ottery <jottery@becsystems.com.au> 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-----