RE: ADO support

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm.poure@freesurf.fr]
> Sent: 08 May 2001 16:00
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] ADO support
>
>
> Hello all,
>
> I seems that ADODB is not fully implemented in PostgreSQL odbc driver.
>
> When working in VB, it is possible to create a connection, query the
> database and retrieve field names.
> But I did not succeed in retrieving indexes and types (need
> to use ADO?).
>
> Has anyone enquired how difficult it is to allow PostgreSQL
> odbc driver to
> work in conjunction with odbc OLEDB provider?
>
> Greetings from Jean-Michel POURE, Paris, France
> PgAdmin team

Hi Jean-Michel,

You might want to run questions like this over the pgadmin-hackers list
first/as well (if it's in VB we've proably looked at it!) :-)

Microsoft don't really support db schema type stuff in ADO - instead they
have written ADOX which is specifically there to provide info about the
structure of the connected db (I assume they started integrating it then
realised it was better in a separate object model). ADOX is used in
frmMigration.frm (in pgAdmin for others), and is documented in the MS Data
Access SDK 2.6.

Regards, Dave.