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

[ psqlodbc-Bugs-1010735 ] Error on method Fields using client side recordset

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1010735 ] Error on method Fields using client side recordset
Date: 2009-12-04 23:36:27
Message-ID: 20091204233627.13B9310749AE@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Bugs item #1010735, was opened at 2009-11-30 14:54
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010735&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Gregory Fernandez (lgringo)
Assigned to: Nobody (None)
Summary: Error on method Fields using client side recordset

Initial Comment:
Hi,

I got "Multiple-step operation generated errors. Check each status value." when I try to assign a field, using a recordset with client side property set.

Visual Basic code :
01 Dim cx As New  ADODB.Connection
02 Set cx = ADODB.Connection
03 cx.Open "Driver={PostgreSQL Unicode};Server=127.0.0.1;Database=mydb;UID=XXX;PWD=XXX;"
04 Dim rds As new ADODB.Recordset
05 rds.CursorLocation = adUseClient
06 rds.Open "SELECT * FROM bug", cx, adOpenDynamic, adLockOptimistic
07 rds.AddNew
08 rds.Fields("id") = 1
09 rds.Fields("texte") = "texte"
10 rds.Update
11 rds.Close
12 cx.Close

Version 8.03.04.00 works fine.
Version 8.04.01.00 gives the error ("Multiple-step operation generated errors ...").

Server used : PostgreSQL 8.3.8



----------------------------------------------------------------------

>Comment By: Hiroshi Inoue (hinoue)
Date: 2009-12-04 23:36

Message:
Could you please try the drivers on testing for 8.4.0101 at
    http://www.geocities.jp/inocchichichi/psqlodbc/index.html
? 

----------------------------------------------------------------------

Comment By: Gregory Fernandez (lgringo)
Date: 2009-11-30 14:58

Message:
NB: Removing line 05 solves my problem for this test but my
main application needs adUseClient.

----------------------------------------------------------------------

You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010735&group_id=1000125

pgsql-odbc by date

Next:From: Craig RingerDate: 2009-12-05 02:28:28
Subject: Re: Hi!
Previous:From: Hiroshi InoueDate: 2009-12-04 23:27:07
Subject: Re: declare/fetch problem with pgpool 2.2.3; Postgres 8.4; ODBC 8.03.04.00

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