Re: Bug with version 08.01.0100 ? - Mailing list pgsql-odbc

From Dave Page
Subject Re: Bug with version 08.01.0100 ?
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC3983@ratbert.vale-housing.co.uk
Whole thread Raw
In response to Bug with version 08.01.0100 ?  (Thomas Chabaud <tc@geosys.com>)
List pgsql-odbc

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Thomas Chabaud
> Sent: 07 November 2005 10:39
> To: pgsql-odbc@postgresql.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.


pgsql-odbc by date:

Previous
From: Thomas Chabaud
Date:
Subject: Bug with version 08.01.0100 ?
Next
From: "Dave Page"
Date:
Subject: Re: Bug with version 08.01.0100 ?