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

[ psqlodbc-Bugs-1000481 ] VFP and SQLCancel

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000481 ] VFP and SQLCancel
Date: 2005-12-19 17:07:24
Message-ID: 20051219170724.32D3511250B7@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Bugs item #1000481, was opened at 2005-12-14 01:06
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000481&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: Accepted
Priority: 3
Submitted By: Ludek Finstrle (luf)
Assigned to: Ludek Finstrle (luf)
Summary: VFP and SQLCancel

Initial Comment:
Visual FoxPro program has problem with psqlodbc. It use SQLCancel without
FreeStmt(SQL_Close) and FreeStmt(SQL_RESET_PARAMS) as usually. It fails in next SQLExecDirect call somtimes (data_at_exec parameter).

Andrus reports this behaviour two times in mailing list. I think it needs new configuration option for it as patch for this problem break ODBC specification.

I attach DLLs (based on 8.01.0104 dev snapshot) which may fix this problem.

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

Comment By: Andrus Moor (kobruleht)
Date: 2005-12-19 17:07

Message:
I verified that my both repros do not cause errors and installed dlls to a small production system.
It is interesting that 16.12 file sizes are exactly the same as previous, 14.12.5 versions:

16.12.2005  18:23           331_776 psqlodbcw.dll
16.12.2005  18:22           323_584 psqlodbca.dll

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

Comment By: Ludek Finstrle (luf)
Date: 2005-12-18 10:26

Message:
I added better fix for this into psqlodbc 8.01.0105 development snapshot. Please test it and drop me a note in pgsql-odbc mailing list.
If it's ok I'll close this bug report.

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

Comment By: Ludek Finstrle (luf)
Date: 2005-12-16 16:29

Message:
I hope I have good information for you ;-)
I go another way and I find better solution for this problem. I remove Dave's patch and the first test suite from Andrus works :-)
There is new DLLs attached. Please try and report.

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

Comment By: Ludek Finstrle (luf)
Date: 2005-12-14 01:12

Message:
I forgot attach diff againist CVS.

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

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

Responses

pgsql-odbc by date

Next:From: AndrusDate: 2005-12-19 18:58:56
Subject: Re: [ psqlodbc-Bugs-1000481 ] VFP and SQLCancel
Previous:From: Campbell, GregDate: 2005-12-19 15:28:35
Subject: Re: insert and update in vb.net

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