Postgres Pro
Downloads
Home   >   mailing lists

Thread: OLEDB vs ODBC to access postgres

OLEDB vs ODBC to access postgres

From
J Ottery
Date:
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?

Help would be appreciated on this as I have spent a long time
researching what to use for my future commercial projects.

Re: OLEDB vs ODBC to access postgres

From
"Joshua D. Drake"
Date:
-----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-----

Re: OLEDB vs ODBC to access postgres

From
"Merlin Moncure"
Date:
On Mon, Mar 24, 2008 at 10:14 PM, 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?
>
>  Help would be appreciated on this as I have spent a long time
>  researching what to use for my future commercial projects.

The oledb driver PostgreSQL doesn't support Delphi (and a lot of other
things).  My gut feeling is it probably never will...most people who
use the ms stack use the odbc or the .net drivers.

My personal favorite connection library to Delphi is Zeos...it's a
little cranky to set up but extremely fast and powerful.  It has a
client side sql parser that allows very advanced data binding.

merlin