Обсуждение: FoxPro in WINE to Postgresql on LINUX?

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