Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Linux ODBC for VFP
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00634413
Message ID:
00634786
Vues:
23
Yes Leland,
just jumping in ..

I use samba as well, but with PHP (its sort of like asp for apache web server,) and the odbc connection with php seems based on their docs seem very limited indeed

So if you are looking to have a vfp app on the web with php pages, and a desktop version, might I suggest that you look in migrating your dbf's over to Postgresql, or Mysql and use that as a data source for your vfp desktop app's and then you have a perfect datasource ---- the same one which is already working for your php requirements.

Dbf's with php have just too functions avail to make it a viable soltuion.

From the PHP manual
'We recommend that you do not use dBase files as your production database. Choose any real SQL server instead; MySQL or Postgres are common choices with PHP. dBase support is here to allow you to import and export data to and from your web database, because the file format is commonly understood by Windows spreadsheets and organizers.'


Here is the refrence


http://www.php.net/manual/en/ref.dbase.php


>Hi,
>
>I use a service called samba that makes directories on my linux machine available to my windows network. Once samba is set up the linux box will appear in the network neiborhood in the windows machines. Also, it is possible to browse the linux samba directories just like you can browse a windows directory. You can copy to or from the samba directories just like to windows machine in a network.
>
>The samba directories can handle any VFP DBC or free tables equally well. It's been three or four years aga, but at that time an article in one of the tech magazines benchmarked a linux samba file system as a much more efficient file server than a windows NT box was in server its own windows clients (e.g. at 10 user the window NT box began to experience degradation whereas this didn't occur on the linix samba server until thirty users). At that time in order to run the linux samba file system you would need a windows NT box to handle the authentication. I think now you can use a linux box as a primary domain server in a window network, but I don't think linux can be used as a backup domain server to a primary windows domain server.
>
>Under this arrangement it is not necessary to use an ODBC. Just simply supply the fully qualified path to the linux directory like:
>
>select A && Remember set up work area to hold arcur
>use \\linux_srv1\fox\001\arcur001.dbf alias arcur shared
>select arcur
>set exclusive off
>set multilocks on
>=cursorsetprop("Buffering",3,"arcur")
>begin transaction
>browse
>end transaction
In the beginning, there was a command prompt, and all was well.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform