Re: Foxpro + PostgreSQL

I have not had problems with integers but I am using a VFP class for SQL
server backends that was written by someone else. Best thing is to try it
yourself. If you need support sign up for the psql-general list. They're a
good resource and have subscribers from all platforms.

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

Mike Copeland <mike(at)ggisoft(dot)com>
09/07/2006 11:06 AM
Please respond to
mike(at)ggisoft(dot)com

To
MargaretGillon(at)chromalloy(dot)com
cc

Subject
Re: Foxpro + PostgreSQL

Margaret,

It helps a lot! Now all I have to do is figure out why another guy wrote
me back saying that he had struggled with using PostgreSQL for 2 years and
recently switched to MySQL (along with buying licenses for his customers)
and, in his words, "it was a breath of fresh air!"

From the rest of what he wrote, he indicates that PostgreSQL is a pain to
manage...as in adding users, etc. I think I'll try PGADMIN III as you
recommended below.

Do you recall running into any weird data type problems with the ODBC
connection? With MySQL, there's a weird thing with whole Integers versus
decimal place number field types...I don't recall the exact problem but I
do remember it drove me up the wall last year before I figured it out.
Turned out to be an ODBC bug that no one has any desire to fix since
there's a workaround.

Thanks again and thanks for any feedback.

Mike

MargaretGillon(at)chromalloy(dot)com wrote:

Hi Mike,

I have been using Visual FoxPro with Postgresql for two years. Currently
my front end is Visual Foxpro 9. I do not have the Postgresql on a Windows
server, I am on a Linux server that is running RedHat 9. I upgraded my
Postgresql two months ago and I am on version 8.1.4. My clients connect
with the Postgresql ODBC driver for Windows . I haven't had any problems
with this combination. I handle most of the access rights in the VFP
application. To access the server data I am using SQLCONNECT and then
SQLEXEC to send queries. The program I use to manage the databases is
PGADMIN III on Windows.

There are other VFP programmers on the pgsql-general maillist and some of
them work with both Postgresql and MySql (Windows and LInux). They have
helped me before when I hit snags. Many of them have been using this combo
since VFP 6. There are programmers on the www.UniversalThread.com which
use this combo too.

Hope this helps.

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

Mike Copeland <mike(at)ggisoft(dot)com>
09/07/2006 12:27 AM

Please respond to
mike(at)ggisoft(dot)com

To
MargaretGillon(at)chromalloy(dot)com
cc

Subject
Foxpro + PostgreSQL

Margaret,

I found a post of yours on the PostgreSQL website. It didn't look like
you had ever gotten a response so I am writing to ask if you have
pursued the Foxpro+PostgreSQL combo, or not.

I have years of Foxpro (currently on 9) experience, and began using
MySQL as a backend a couple of years ago. Now that I'm getting close to
rolling out an application I wrote (Foxpro frontend, MySQL backend) I'm
getting nervous about the licensing issues with MySQL. So, I'm looking
into switching from MySQL to PostgreSQL.

All that to ask, did you have any success in your attempts to use this
combo?

I've been using the sqlstringconnect function in Foxpro 9, but is that
possible with PostgreSQL? There seems to be a dearth of info available
about using FP9 as a frontend to PostgreSQL...everyone seems to focus on
which is better, blah blah blah.

Thanks for any and all feedback!

Mike Copeland
Genesis Software Group