Visual FoxPro 9 ODBC errors

"Is anyone else having problems with 9? "

I use VFP 9 + Postgres 8.1 on XP + 105 version of Postgres Unicode ODBC
driver without problems.

Andrus.

2006/1/3, MargaretGillon@chromalloy.com <MargaretGillon@chromalloy.com>:

"Alejandro D. Burne" <alejandro.dburne@gmail.com> wrote on 01/01/2006

04:37:10 PM:

2005/12/30, MargaretGillon@chromalloy.com <MargaretGillon@chromalloy.com
:

I am writing an application in Visual Foxpro 9 (running on Windows
2000) but I get errors when VFP9 tries to write data to my
Postgresql server (Linux Redhat 9). I know the syntax on the insert
statement is good because I can run the statement in pgAdmin and the
row is created without problems. I searched the mailing lists and I
see messages about errors with VFP9 but I can't read them, I believe
they're in Spanish.

I know there are Visual FoxPro developers on this list. Is anyone
else having problems with 9? If there are problems with VFP9 are the
problems in VFP8 as well? I am trying to build this application in
the most current version of VFP possible but it must be compatible
with Postgresql.

Please reply to me as well as the list, I get the digest version.

Thank you,

Hi, I'm a vfp (6.0) developer, what's wrong with vfp and postgres?
What kind of connection sqldirect / sqlpasstrough?
ODBC Version?

Alejandro

I am using Postgresql ODBC driver version 8.00.01.02
Connection is with SQLCONNECT command, then SQLEXEC statements. I was able
to use this ODBC driver with Visual Foxpro 7 with no problems. That is why I
am wondering if something changed with version 9, and if the change was
between 7 and 8 or between 8 and 9.

*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
*** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297

Ok, I can't test vfp 9 right now; but you can't connect? or you can't query?
With "? message()" after sqlexec you can see message error. Tell us more.

Alejandro

2006/1/3, MargaretGillon@chromalloy.com <MargaretGillon@chromalloy.com>:

"Alejandro D. Burne" <alejandro.dburne@gmail.com> wrote on

01/01/2006 04:37:10 PM:

2005/12/30, MargaretGillon@chromalloy.com <

MargaretGillon@chromalloy.com>:

I am writing an application in Visual Foxpro 9 (running on Windows
2000) but I get errors when VFP9 tries to write data to my
Postgresql server (Linux Redhat 9). I know the syntax on the insert
statement is good because I can run the statement in pgAdmin and the
row is created without problems. I searched the mailing lists and I
see messages about errors with VFP9 but I can't read them, I believe
they're in Spanish.

I know there are Visual FoxPro developers on this list. Is anyone
else having problems with 9? If there are problems with VFP9 are the
problems in VFP8 as well? I am trying to build this application in
the most current version of VFP possible but it must be compatible
with Postgresql.

Please reply to me as well as the list, I get the digest version.

Thank you,

Hi, I'm a vfp (6.0) developer, what's wrong with vfp and postgres?
What kind of connection sqldirect / sqlpasstrough?
ODBC Version?

Alejandro

I am using Postgresql ODBC driver version 8.00.01.02
Connection is with SQLCONNECT command, then SQLEXEC statements. I
was able to use this ODBC driver with Visual Foxpro 7 with no
problems. That is why I am wondering if something changed with
version 9, and if the change was between 7 and 8 or between 8 and 9.

*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
*** *** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297

Ok, I can't test vfp 9 right now; but you can't connect? or you can't

query?

With "? message()" after sqlexec you can see message error. Tell us

more.

Alejandro

I can connect and I can query, what I can't do is write. In VFP7 I could
update with no problem. Any update commands sent from VFP9 fail.
Margaret Gillon

2006/1/3, MargaretGillon@chromalloy.com <MargaretGillon@chromalloy.com>:

2006/1/3, MargaretGillon@chromalloy.com <MargaretGillon@chromalloy.com>:

"Alejandro D. Burne" <alejandro.dburne@gmail.com> wrote on

01/01/2006 04:37:10 PM:

2005/12/30, MargaretGillon@chromalloy.com <

MargaretGillon@chromalloy.com>:

I am writing an application in Visual Foxpro 9 (running on Windows
2000) but I get errors when VFP9 tries to write data to my
Postgresql server (Linux Redhat 9). I know the syntax on the insert
statement is good because I can run the statement in pgAdmin and the
row is created without problems. I searched the mailing lists and I
see messages about errors with VFP9 but I can't read them, I believe
they're in Spanish.

I know there are Visual FoxPro developers on this list. Is anyone
else having problems with 9? If there are problems with VFP9 are the
problems in VFP8 as well? I am trying to build this application in
the most current version of VFP possible but it must be compatible
with Postgresql.

Please reply to me as well as the list, I get the digest version.

Thank you,

Hi, I'm a vfp (6.0) developer, what's wrong with vfp and postgres?
What kind of connection sqldirect / sqlpasstrough?
ODBC Version?

Alejandro

I am using Postgresql ODBC driver version 8.00.01.02
Connection is with SQLCONNECT command, then SQLEXEC statements. I
was able to use this ODBC driver with Visual Foxpro 7 with no
problems. That is why I am wondering if something changed with
version 9, and if the change was between 7 and 8 or between 8 and 9.

*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
*** *** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297

Ok, I can't test vfp 9 right now; but you can't connect? or you can't

query?

With "? message()" after sqlexec you can see message error. Tell us

more.

Alejandro

I can connect and I can query, what I can't do is write. In VFP7 I could
update with no problem. Any update commands sent from VFP9 fail.
Margaret Gillon

Please, send message error to help. Alejandro

I see that one can add a new column to an existing
table. The documentation was not clear on how
efficient this operation would be.

Does PostgreSQL make a copy of the entire table when
adding a new column? Or does it simply use extra
space in the data blocks to add the new column?

__________________________________________
Yahoo! DSL � Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com

Alejandro,
I cannot build the list of errors because I am on another project right
now that is rush. I will trace and post the error(s) as soon as I can.
Margaret.

P G <pgress5@yahoo.com> writes:

I see that one can add a new column to an existing
table. The documentation was not clear on how
efficient this operation would be.
Does PostgreSQL make a copy of the entire table when
adding a new column? Or does it simply use extra
space in the data blocks to add the new column?

If the new column has no default expression (ie, default null) then
adding a column doesn't touch the table at all, only some catalog
entries.

Inserting data into the column is expensive, of course, since you
have to update every row in the table to put it there. This is
not different from any other UPDATE operation.

regards, tom lane

There is an ODBC problem with Visual Foxpro 9. According to a Visual
FoxPro maillist:

Since VFP caches a common statement handle that it reuses, it has to call
SQLFreeStmt(SQL_UNBIND) and SQLFreeStmt(SQL_RESET_PARAMS) to make sure the
cached statement handle is in a cleared state before reusing it. VFP
indeed calls these functions when all goes well, but when an error occurs
in SQLExecuteDirect it just calls SQLCancel and then returns from
SQLEXEC...... At least for me this is a bug in VFP, which is caused by the
fact that it caches a common statement handle but doesn't reset it
correctly when an error occurs.

A thread does exist for the problem on the pgsql-odbc list under
Subject: Re: [ODBC] Access violation C5 error on Visual FoxPro SQLEXEC()
call after error

*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
*** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297

This e-mail message and any attachment(s) are for the sole use of the
intended recipient(s) and may contain proprietary and/or confidential
information which may be privileged or otherwise protected from
disclosure. Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient(s), please contact the
sender by reply email and destroy the original message and any copies of
the message as well as any attachment(s) to the original message.

Thisis fixed this in December 2005.
Recent development snapshot does not have this problem.

This problem occurs only when Postgres returns error and VFP application
executes next statement i.e. in rare cases.

Andrus.

There is an ODBC problem with Visual Foxpro 9. According to a Visual
FoxPro maillist:

Since VFP caches a common statement handle that it reuses, it has to call
SQLFreeStmt(SQL_UNBIND) and SQLFreeStmt(SQL_RESET_PARAMS) to make sure the
cached statement handle is in a cleared state before reusing it. VFP indeed
calls these functions when all goes well, but when an error occurs in
SQLExecuteDirect it just calls SQLCancel and then returns from
SQLEXEC...... At least for me this is a bug in VFP, which is caused by the
fact that it caches a common statement handle but doesn't reset it
correctly when an error occurs.

A thread does exist for the problem on the pgsql-odbc list under

Subject: Re: [ODBC] Access violation C5 error on Visual FoxPro SQLEXEC()
call after error