Re: Accessing VFP9 data from Perl/JSP pages being served from Apache/Linux?

There is a dbi driver for ADO, you might be able to use that to get to VFP
via ADO, but I can't imagine it being all that robust. There is also an odbc
driver for dbi, that is also worth trying. Unfortunately, there is no VFP
driver (dbi for VFP? Come on, be real lol....).

If your data access needs aren't realtime, you might want to have your VFP
app export your data into a dbi compatible format on a regular basis, as
there are dbi drivers for many different data formats.



"William Fields" <Bill_Fields@xxxxxxxxxxxxxxxx> wrote in message
news:uRnCHEuPGHA.456@xxxxxxxxxxxxxxxxxxxxxxx
I don't think VFP9 data can be accessed via ODBC any longer - the VFP ODBC
driver has not been updated in years (don't even think it's available for
download). And I'm really certain that stored procedure access via ODBC is
either non-existent, or so limited to the extent of being unusable.

Anyone else?

--
William Fields
Code Contortionist
MCSD - Microsoft Visual FoxPro
US Bankruptcy Court
Phoenix, AZ

".dll hell - .rpm hell - whatever.
The grass is always greener"





"swdev2" <wsanders@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:u1EqTJoPGHA.3408@xxxxxxxxxxxxxxxxxxxxxxx
Does it need to be oledb? If not - there is a nice perl library that
uses
odbc IN linux for Apache.
Yer PerlGeeks know about it. I've got an url floating around somewhere.

OTOH - if you want to make a bridge with oledb - it can be done - and
it's
not a trivial thing - you'll have to purchase
the bridge drivers for the linux box and also for the machine that will
hang
off the novell server to make the bridge.
I've got the info from a previous client somewhere floating about - I'll
post it as I find it (rsn).
regards [Bill]

--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"William Fields" <Bill_Fields@xxxxxxxxxxxxxxxx> wrote in message
news:#pV6nFlPGHA.1696@xxxxxxxxxxxxxxxxxxxxxxx
Is the VFP9 OLEDB provider able to be used under Apache/Linux? We have a
mission critical Linux app that we'd like to have direct access to our
data
(living on a Novell server), but I have no idea how to accomplish that.

Thanks.

--
William Fields
Code Contortionist
MCSD - Microsoft Visual FoxPro
US Bankruptcy Court
Phoenix, AZ

".dll hell - .rpm hell - whatever.
The grass is always greener"









.

Relevant Pages

  • Re: VB.NET Insert Error into old version of Foxpro
    ... BEcause of the fact that the ODBC or OLEDB driver is of VFP, ... Date and datetime fields can be specified in multiple manners: ... > Dim cmdFox As New OleDb.OleDbCommand ...
    (microsoft.public.fox.programmer.exchange)
  • Re: DBI and character sets (yet again)
    ... I don't really want the DBI to be involved in any recoding ... When selecting data from the database the driver should: ... - return strings which have a unicode character set as UTF8. ... - return strings with other character sets as-is on ...
    (perl.dbi.users)
  • DBD::ODBC make test fails
    ... I installed DBI ... this looks like a unixodbc type of driver manager. ... Undefined subroutine &main::BAILOUT called at t/02simple.t line 23. ... ok 2 - use ODBCTEST; ...
    (perl.dbi.users)
  • RE: ORACLE DRIVER
    ... DBI - is the perl module to handle all the request of the database, connecting, disconnecting, routing the database request to proper driver. ... DBD::Oracle - is the Oracle driver that DBI can use to handle oracle request. ...
    (perl.dbi.users)
  • RE: Trouble linking files in Vista
    ... actual VFP driver. ... were shipped with the Visual FoxPro ODBC Driver version 1.00.02.00. ... must download and install the latest VFP ODBC driver. ... We have an Access 2000 database which uses linked Visual FoxPro (VFP) ...
    (microsoft.public.data.odbc)