Search Postgresql Archives

Re: OLEDB vs ODBC to access postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux