Skip site navigation (1) Skip section navigation (2)

Re: Bug with version 08.01.0100 ?

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 (view raw or flat)
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.


pgsql-odbc by date

Next:From: noreplyDate: 2005-11-07 11:05:11
Subject: [ psqlodbc-Bugs-1000412 ] Server Side Prepare doesn't work
Previous:From: Thomas ChabaudDate: 2005-11-07 10:38:36
Subject: Bug with version 08.01.0100 ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group