FoxPro in WINE to Postgresql on LINUX?
I know that there are some Visual FoxPro developers on this list who use
PostgreSQl as their back-end. My question to them is...
VFP will run in WINE up to VFP version 8. But the people I talk to that
are doing this are using VFP's native tables. Does anyone know if it's
possible to run VFP8 in WINE and connect to Postgresql on a Linux server?
I think part of the question here is how would WINE emulate the ODBC to
get to the Postgresql server.
The reason for this strange question is that our corporation has
standardized all custom development to be done in VFP. We need a stable
back-end and some of us are now using Postgresql as our database server.
It would be really nice if we could run our client apps on Linux as well.
Thanks,
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
*** ***
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.
http://www.paulmcnett.com/articles.php has a white paper
White Paper: Running Visual FoxPro on Linux Using Wine (October 2003)
which describes using ODBC drivers from Linux.
Andrus.
<MargaretGillon@chromalloy.com> wrote in message news:OF4A0182D2.CFF2E1F9-ON882570A4.00638256-882570A4.0063DC3A@CHROMALLOY.COM...
I know that there are some Visual FoxPro developers on this list who use PostgreSQl as their back-end. My question to them is...
VFP will run in WINE up to VFP version 8. But the people I talk to that are doing this are using VFP's native tables. Does anyone know if it's possible to run VFP8 in WINE and connect to Postgresql on a Linux server? I think part of the question here is how would WINE emulate the ODBC to get to the Postgresql server.
The reason for this strange question is that our corporation has standardized all custom development to be done in VFP. We need a stable back-end and some of us are now using Postgresql as our database server. It would be really nice if we could run our client apps on Linux as well.
Thanks,
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
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.
MargaretGillon@chromalloy.com wrote:
VFP will run in WINE up to VFP version 8. But the people I talk to that
are doing this are using VFP's native tables. Does anyone know if it's
possible to run VFP8 in WINE and connect to Postgresql on a Linux
server? I think part of the question here is how would WINE emulate the
ODBC to get to the Postgresql server.
I can confirm FoxPro running under Wine/Linux can access Postgres via
ODBC and performs nearly comparable to FoxPro under Windows. I got 90%+
performance on some of my data processing programs. Where you do get
really slow is accessing DBFs over the network because NFS is so
inefficient.
It doesn't work with UnixODBC so you need to install the Postgres
Windows ODBC driver under WINE. Double-click on the ODBC installer, then
type: wine odbcad32.exe to launch the config file.
Is it possible to create zero config installation by using connecton string
and simply including odbc dll files (odbc32.dll, odbcint.dll, odbccp32.dll )
with application ?
This is a lot simpler for end user, no manual config required.
"William Yu" <wyu@talisys.com> wrote in message
news:djjdl7$rl8$1@news.hub.org...
Show quoted text
MargaretGillon@chromalloy.com wrote:
VFP will run in WINE up to VFP version 8. But the people I talk to that
are doing this are using VFP's native tables. Does anyone know if it's
possible to run VFP8 in WINE and connect to Postgresql on a Linux server?
I think part of the question here is how would WINE emulate the ODBC to
get to the Postgresql server.I can confirm FoxPro running under Wine/Linux can access Postgres via ODBC
and performs nearly comparable to FoxPro under Windows. I got 90%+
performance on some of my data processing programs. Where you do get
really slow is accessing DBFs over the network because NFS is so
inefficient.It doesn't work with UnixODBC so you need to install the Postgres Windows
ODBC driver under WINE. Double-click on the ODBC installer, then type:
wine odbcad32.exe to launch the config file.
Here's what I do. Once I get a good config, I just tarball my .wine dir
and untarball it for any Linux/WINE box I need to get running.
For users already running WINE w/ their own app configs already, then
copying the files manually into the appropriate dirs and then appending
the necessary text into the various config files will also work. WINE
doesn't store registry settings in Windows' binary registry format.
Instead, it's all flat text so installs are scriptable.
Andrus wrote:
Show quoted text
Is it possible to create zero config installation by using connecton string
and simply including odbc dll files (odbc32.dll, odbcint.dll, odbccp32.dll )
with application ?This is a lot simpler for end user, no manual config required.
"William Yu" <wyu@talisys.com> wrote in message
news:djjdl7$rl8$1@news.hub.org...MargaretGillon@chromalloy.com wrote:
VFP will run in WINE up to VFP version 8. But the people I talk to that
are doing this are using VFP's native tables. Does anyone know if it's
possible to run VFP8 in WINE and connect to Postgresql on a Linux server?
I think part of the question here is how would WINE emulate the ODBC to
get to the Postgresql server.I can confirm FoxPro running under Wine/Linux can access Postgres via ODBC
and performs nearly comparable to FoxPro under Windows. I got 90%+
performance on some of my data processing programs. Where you do get
really slow is accessing DBFs over the network because NFS is so
inefficient.It doesn't work with UnixODBC so you need to install the Postgres Windows
ODBC driver under WINE. Double-click on the ODBC installer, then type:
wine odbcad32.exe to launch the config file.
Can you use Postgres savepoints from VFP ?
sqlexec('ROLLBACK TO mysavepoint') and even sqlexec('ROLLBACK') cause C5
error.
Andrus.
"William Yu" <wyu@talisys.com> wrote in message
news:djl51k$2paa$1@news.hub.org...
Show quoted text
Here's what I do. Once I get a good config, I just tarball my .wine dir
and untarball it for any Linux/WINE box I need to get running.For users already running WINE w/ their own app configs already, then
copying the files manually into the appropriate dirs and then appending
the necessary text into the various config files will also work. WINE
doesn't store registry settings in Windows' binary registry format.
Instead, it's all flat text so installs are scriptable.Andrus wrote:
Is it possible to create zero config installation by using connecton
string and simply including odbc dll files (odbc32.dll, odbcint.dll,
odbccp32.dll ) with application ?This is a lot simpler for end user, no manual config required.
"William Yu" <wyu@talisys.com> wrote in message
news:djjdl7$rl8$1@news.hub.org...MargaretGillon@chromalloy.com wrote:
VFP will run in WINE up to VFP version 8. But the people I talk to that
are doing this are using VFP's native tables. Does anyone know if it's
possible to run VFP8 in WINE and connect to Postgresql on a Linux
server? I think part of the question here is how would WINE emulate the
ODBC to get to the Postgresql server.I can confirm FoxPro running under Wine/Linux can access Postgres via
ODBC and performs nearly comparable to FoxPro under Windows. I got 90%+
performance on some of my data processing programs. Where you do get
really slow is accessing DBFs over the network because NFS is so
inefficient.It doesn't work with UnixODBC so you need to install the Postgres Windows
ODBC driver under WINE. Double-click on the ODBC installer, then type:
wine odbcad32.exe to launch the config file.
Andrus wrote:
Can you use Postgres savepoints from VFP ?
sqlexec('ROLLBACK TO mysavepoint') and even sqlexec('ROLLBACK') cause C5
error.
I have no experience w/ savepoints yet. However, I will say that
sometimes ODBC will hijack your commands and alter them so you may want
to try turning off all possible options.
I have found that using SPT to send a simple rollback like
SQLEXEC('ROLLBACK')
causes C5 error in VFP.
"William Yu" <wyu@talisys.com> wrote in message
news:djtrl7$31ir$1@news.hub.org...
Show quoted text
Andrus wrote:
Can you use Postgres savepoints from VFP ?
sqlexec('ROLLBACK TO mysavepoint') and even sqlexec('ROLLBACK') cause
C5 error.I have no experience w/ savepoints yet. However, I will say that sometimes
ODBC will hijack your commands and alter them so you may want to try
turning off all possible options.