COM+ over the internet

VFP7.0 XPSP2

I want to creatre a com+ server which fetch data from dbf file (exist on
internet server) depending on a query , then the result is exported to xls
file. then i will download this file to local pc, then import the data from
xls to dbf at client pc and show him the result.

1- how i run the com+ server over the internet from client pc ?
x = createobject("mydll.myclas")
X.RUN_QUERY

2- in my local pc i use the following code in a procedure in the class:
USE c:\mydir\mydbf.dbf in 0 shared
what is the command i should use to open a table in internet server?
USE \internetdir\mydbf.dbf in 0 shared <-- is this correct ?

here is my code

DEFINE CLASS EXPORT_TO_XLS AS Custom OLEPUBLIC

PROCEDURE RUN_QUERY
SET EXCLUSIVE OFF
USE c:\mydir\mydbf.dbf IN 0 SHARED
SELECT UNIQUE_ID, TITLE FROM mydbf WHERE PLATFORM = "PC" INTO CURSOR XXLIST
SELECT XXLIST
EXPORT TO c:\MYDIR\OUTPUT.XLS TYPE xls
USE
SELECT MYDBF
USE
ENDPROC

ENDDEFINE

Craig
Wed Oct 25 09:09:30 CDT 2006

COM+ is a Microsoft to Microsoft solution and not suitable over the
internet. You should look at Web Services or check out the articles at
www.west-wind.com.
--
Craig Berntson
MCSD, Visual FoxPro MVP
www.craigberntson.com
Salt Lake City Fox User Group
www.slcfox.org
www.foxcentral.net


"Samir Ibrahim" <samir.ibrahim@wilcopm.com> wrote in message
news:Ou5TbDC%23GHA.3348@TK2MSFTNGP03.phx.gbl...
> VFP7.0 XPSP2
>
> I want to creatre a com+ server which fetch data from dbf file (exist on
> internet server) depending on a query , then the result is exported to xls
> file. then i will download this file to local pc, then import the data
> from xls to dbf at client pc and show him the result.
>
> 1- how i run the com+ server over the internet from client pc ?
> x = createobject("mydll.myclas")
> X.RUN_QUERY
>
> 2- in my local pc i use the following code in a procedure in the class:
> USE c:\mydir\mydbf.dbf in 0 shared
> what is the command i should use to open a table in internet server?
> USE \internetdir\mydbf.dbf in 0 shared <-- is this correct ?
>
> here is my code
>
> DEFINE CLASS EXPORT_TO_XLS AS Custom OLEPUBLIC
>
> PROCEDURE RUN_QUERY
> SET EXCLUSIVE OFF
> USE c:\mydir\mydbf.dbf IN 0 SHARED
> SELECT UNIQUE_ID, TITLE FROM mydbf WHERE PLATFORM = "PC" INTO CURSOR
> XXLIST
> SELECT XXLIST
> EXPORT TO c:\MYDIR\OUTPUT.XLS TYPE xls
> USE
> SELECT MYDBF
> USE
> ENDPROC
>
> ENDDEFINE
>