SPT works with ODBC only. You may consider CursorAdapter for ADO connection.
>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 ?
--sb--