[ 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=10004 81&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=10004 81&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: [ psqlodbc-Bugs-1000481 ] VFP and SQLCancel

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



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: [ psqlodbc-Bugs-1000481 ] VFP and SQLCancel

> > 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: [ psqlodbc-Bugs-1000481 ] VFP and SQLCancel

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



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: [ psqlodbc-Bugs-1000481 ] VFP and SQLCancel

> > 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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: [ psqlodbc-Bugs-1000481 ] VFP and SQLCancel

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



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster