From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | <tc(at)geosys(dot)com>, <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Bug with version 08.01.0100 ? |
Date: | 2005-11-07 10:54:43 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC3983@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> -----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.
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2005-11-07 11:05:11 | [ psqlodbc-Bugs-1000412 ] Server Side Prepare doesn't work |
Previous Message | Thomas Chabaud | 2005-11-07 10:38:36 | Bug with version 08.01.0100 ? |