This sounds like a VFP Web Service type of thing which would involve setting up a vfp COM MTDLL. BTW, this kind of vfp web service will only be scalable using a vfp COM MTDLL, not a COM EXE. You would just compile your class into a mtdll. I'm pretty sure Cold Fusion can call a Web Service. See this Microsoft web service walkthu for more:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxgen7/html/vfpws.asp

>I need to access a VFP 8.0 database and table from Coldfusion.
>I want to do this through com automation.
>
>1) IS THE FOLLOWING POSSIBLE?
>2) IF the answer to 1 is yes, then can anyone recommend a good book on this?
>
>DEFINE CLASS test AS CUSTOM OLEPUBLIC
> function init
> open database \\my_network\my_share\mydbc.dbc
> endfunc
>
> PROCEDURE getCity( tcID as Integer )
> local lcCity as String
> lcCity=''
>
> select 0
> use myDBC!address order id
> if seek(tcID)
> lcCity=alltrim(address.address
> endif
> use in address
> return (lcCity)
> ENDPROC
>ENDDEFINE