Ado with PostgreSQL?

[MartinTeefy]

Hi,

I'm accessing Access, MSSQL, MYSQL & SQLite in a windows server via a dcom link for my helpdesk system offering clients the database of their choice.

Forgive my ignorance here as i know nothing about postgreSQL but i'd like to add it as a supported database for my helpdesk system.

Does postgreSQL run on windows?

Can ADO access PostgreSQL, if so can some-one point me in the direction of a driver etc.

I'd like to replicate the following ADO code:

' Restrictions:array(PK_TABLE_CATALOG, PK_TABLE_SCHEMA, FK_TABLE_CATALOG, FK_TABLE_SCHEMA, FK_TABLE_NAME)
Set GetADORelations = Cnn.OpenSchema(adSchemaForeignKeys, Array(Empty, Empty, Empty, Empty, Empty))

where GetADORelations is an ADO recordset.

Is there a way to do this with PostgreSQL i.e. get the relationships between tables for primary & foreign keys?

Thanks
Martin

[seawolf]

I use Postgresql on WinXp, even though i use Zeos to connect with it.
Anyway googling "Ado Postgresql" you find several howtos