Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Netherlands
 Boudewijn Lutgerink
 To: Chris Van de Velde
  Where is Chris Van de Velde?
 antwerpen
 Belgium
 Chris Van de Velde
 Tags
Subject: RE: VFP, MS-Access and Webspace
Thread ID: 21728 Message ID: 21821 # Views: 3 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Wednesday, April 02, 2003 11:37:51 AM         
   


> > > I want to access (read/write) and Access database in webspace. I cannot do it with Mysql or SQL/Server because my hosting provider does not tollerate these on his machines. MS_Access is however on his server.
> > > How do I connect my local Foxpro application (.EXE) to this database (connection string)?
> > > Chris Van de Velde
> >
> > One thing I know is that you can host your own server with DynIP, the same that foxite uses, in that way you are not depending on the wishes and rules of any provider.
> > Good thing of course will be if you have any form of broadband, having the telephone on all day *might* end up very costly....
> > That way you can create your own site.
> > I don't see why youshould use a fox exe to access an access mdb. did you take a look at the datapages possibility of Access to access access mdb's.
> > (Wow, that's a lot of accessible access.)
> > Another option, of course, and more stable (definetely) will be then to use IIS and any form of web api, either foxisapi or west-wind or AFP from Juergen -wOOdy- Wozinsky and his company prolib.
> >
> > Boudewijn LutgeĀ®ink
> > Boudewijn.Lutgerink@foxite.com
> > Experience is the knowledge you get immediately AFTER you actually needed it...
> Boudewijn,
> I need to use a FOX exe, because the main part of the application uses FOX. Only the part where shared data is invoked, needs a DB somewhere in the WWW. For that same reason I cannot use IIS. I tied before using internet file sharing to access a foxpro table, but for some customers firewalls are disabling that trafic.
>
> Chris Van de Velde

do you really need that to be an Access DB?
I have been playing around with MySQL exactly for that reason. Especially when you use VFP8 connecting to datasources you are THE man.
to sketch a picture.
Paul McNett had, a while ago, his database open over the internet. One of the tables had about 61000 records or so.
Paul lives in Florida, his machine (linux BTW) is situated there as well.
retrieving one record took .03 seconds, bummer... I couldn't even get out of my chair to get my coffee.
Retrieving ALL records was a major bummer as well, took only 7 seconds. Still no coffee...
Changing data, sending it there and re-retieving it took only .48 seconds for one record. (Sh*t!! still no coffee!!)
doing the same for multiple records (about 45) took as much as 1.1 second. (D*MN I want that coffee!!)
After this I ended the test, I needed that coffee ;-)

Boudewijn LutgeĀ®ink
Boudewijn.Lutgerink@foxite.com
Experience is the knowledge you get immediately AFTER you actually needed it...

COMPLETE THREAD

VFP, MS-Access and Webspace Posted by Chris Van de Velde @ 3/31/2003 1:54:54 PM
RE: VFP, MS-Access and Webspace Posted by Boudewijn Lutgerink @ 4/1/2003 8:56:31 AM
RE: VFP, MS-Access and Webspace Posted by Chris Van de Velde @ 4/2/2003 10:10:44 AM
RE: VFP, MS-Access and Webspace Posted by Boudewijn Lutgerink @ 4/2/2003 11:37:51 AM