[ psqlodbc-Bugs-1000481 ] VFP and SQLCancel

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_execparameter). 

Andrus reports this behaviour two times in mailing list. I think it needs new configuration option for it as patch for
thisproblem 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-odbcmailing 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
Andrusworks :-) 
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