Re: Bug with version 08.01.0100 ?

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Thomas Chabaud
> Sent: 07 November 2005 10:39
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] Bug with version 08.01.0100 ?
>
> I have installed the new version of the Postgre ODBC driver
> with the msi
> installer provided, but I have a Visual Basic abnormal error
> when I try
> to open a recordset.
>
> The conn.open works without problem, the error happens only when I try
> to open the recordset with the following code :
>
>
> Dim rs As New ADODB.Recordset
> Dim sqlStr as String
>
> sqlStr = "SELECT * FROM tUsers"
> rs.Open sqlStr, dbConn, adOpenStatic, adLockOptimistic, adCmdText
>
> - My conn.ConnectionString is :
>
> Provider=MSDASQL.1;Extended Properties="DRIVER={PostgreSQL-libpq};

^^^^^^^^^^^^^^^^

That is an old snapshot of the driver - you should be using either:

DRIVER={PostgreSQL ANSI}

Or

DRIVER={PostgreSQL Unicode}

I've tried your connection string (modified for my local server of
course) and rs.Open (but with pg_class), and it does seem that only
adOpenForwardOnly and adOpenDynamic work as expected :-(. I'll open a
tracker about this.

Regards Dave.