The problem is really only if you have control over the web server or not. If you can install the com object on the machine, you can do what you want.


>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