desktop program to connect remote db

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yamily@gmail.com - 01 Jul 2008 16:25 GMT

hi, i have a question....i want to do a desktop program, where you can
make a query to a remote db through the Internet ......i mean, that it
will be able to make a connection to a remote database and see the
data, but i wanna know if i can do this and how, there's a protocol, a
technique,cause i have no idea .....or if i can make it with vfp,
which language i need to use.? like an example, there's the INTTRA
DESKTOP system...you see it as a local desktop program, but it
connects to a remote db and you can receive and send information, but
is not in web.

Please, i'd appreciate your help, any help.

thanks in advance!!

Reply to this Message

Craig Berntson - 02 Jul 2008 15:35 GMT

There are several ways to do this:

- Web services. Response is pretty good, but a web server is required
- Connect to VFP data. Forget this idea. Speed will be terrible as queries
will be resolved locally, so lots of data will be pulled over the wire.
- Server database, such as MS SQL Server, My SQL, etc. Response is pretty
good.

Signature

Craig Berntson
Microsoft MVP

-------------

> hi, i have a question....i want to do a desktop program, where you can
> make a query to a remote db through the Internet ......i mean, that it
[quoted text clipped - 9 lines]
>
> thanks in advance!!

Reply to this Message

Juan Alonso - 22 Sep 2008 19:12 GMT

So far.. I see three options that will give you good result.

PhP to pull data from an SQL/ My SQL DB or you can use

Active Foxpro Pages...or Active Server Pages ... You can use it to pull data
from SQL/ My SQL DB also.

These will be run on server side though, but give very good result with
something you might already recognize.

There are many other things too, but I don't want to through you into the
lake of fire in the variance of language choices and other factors that you
would use in order to optain information you pull from your DB file.

Any data you pull from your local computer will only be as fast as your wire
connection... so your speed of retreival will be set on that.

Any data you pull on server side will be faster because you only need echo
your results.

Good luck,

Juan.

Server side with

Reply to this Message