Re: Is this possible?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

First I wonder if this would work at all as ; is the line continuation
symbol in vfp and
not a seperator of commands. But that may be part of OleDB to
convert it for vfp accordingly.

Probably. Part of my problem is that I may not know exactly what syntax to
use in such a situation (operating on FoxPro tables through ADO.Net).


As your script works on your local machine and not on the
server: Do you do it with a connection to the same database?


No. It works if I am running the web app on my local machine with local
files. It fails if I run off the web server with the DBF tables that are
located on the same machine as the web server.

As the process which packs a table needs to be the one with
exclusive access to the dbf with no other usage of the file,
it's most likely you can't succeed on the server, because the
database is always in use by some user while a local copy
of the database on your machine of course is only in use
by yourself if at all.

This appears likely. As someone here suggested, I will now try and write a
console app I can put on the web server and either shell to from the web app
or assign to a SQL job.

Thanks
B.C.
.

Relevant Pages

  • Re: Any Web Servers for Visual FoxPro
    ... Session is a VFP baseclass and as such has an EXACT meaning. ... sessions as well as several users being able to access the web server ... I was thinking that maybe the EEATASoft webserver might ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Any Web Servers for Visual FoxPro
    ... multiple domains and multiple IP's. ... His codebase is not free. ... writtin in VFP with source code). ... solution for my clients so that I can easily expand on the web server in VFP ...
    (microsoft.public.fox.programmer.exchange)
  • aspnet._wp.exe could not be started
    ... I'm attempting to use a web app that has been set up by a third party ... request failure can be found in the application event log of the web server. ... This error can be caused when the worker process account has ... .NET Framework is correctly installed and that the ACLs on the installation ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Single Web and Desktop Interface
    ... I'm surprised no one has mentioned eevaa web server, ... written in vfp! ... I would like to have an all HTML ... is the ActiveX object. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Need to write my first web application - scratching head
    ... If you write this as a web app, you'll need a web server. ... from PHP you have only partial control over how the page ... And I did suspect that the printing requirement and the single-machine ...
    (comp.lang.php)