Hello All, I'm would like to connect to a remote PostgreSQL database using the PG OLEDB provider, I've achieved this using ADO but would prefer SQL pass through, the connection string I've successfully used with ADO is this:

ConnectionString = "Provider=PostgreSQL.1;data source=12.0.34.89;location=mydatabase;User ID=myid;Password=mypassword"

however if I use this with

han = SQLStringConnect(ConnectionString)

I get the dialogue box prompting me for a DSN, any ideas ? is this possible ?