Thread: [ 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
> 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. I tested my both repros with driver vers. 105 Errors did not occur. Andrus.
> > 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. > > I tested my both repros with driver vers. 105 > Errors did not occur. Thanks a lot Andrus. Please could you take a look at pgsql-admin mail archive? One man has problem with VFP and ODBC there. Thanks, Luf
> Thanks a lot Andrus. Please could you take a look at pgsql-admin > mail archive? One man has problem with VFP and ODBC there. Luf, I send a reply to him. Andrus.
> > Thanks a lot Andrus. Please could you take a look at pgsql-admin > > mail archive? One man has problem with VFP and ODBC there. > > Luf, > > I send a reply to him. Thanks a lot. Could you send copy here? So people could find solution in mail archive in the future. Thank you again Luf
> Thanks a lot. Could you send copy here? So people could find solution
> in mail archive in the future.
Luf,
I posted a sample VFP 9 code which callas Postgres ODBC:
cConnString ="DRIVER={PostgreSQL Unicode};DATABASE=postgres;"+ ;
"SERVER=127.0.0.1;PORT=5432;UID=postgres;PWD=aaaa;B9=0"
nconnh=SQLSTRINGCONNECT(cconnstring)
IF nconnh<=0
LOCAL laerror[1]
AERROR(laError)
MESSAGEBOX( laerror[1,2])
RETURN
ENDIF
TEXT TO csql
CREATE temp table test ( test char(1));
insert into test values ('');
select 0 as foo, 1 as bar from test
ENDTEXT
oCadapter = CREATEOBJECT('cursoradapter')
oCadapter.DataSource= nconnh
oCadapter.DataSourceType ="ODBC"
oCadapter.SelectCmd = csql
oCadapter.CursorFill()
BROWSE
Andrus.