One way is to put a stub program on the server behind the fw. Then
have a CF program outside the fw pass SQL statements to the stub
(CFHTTP).
The stub issues the SQL statements against the db & passes the
results to the caller.
The data is all passed using WDDX.
I use this technique all the time to move data between mutually
inaccessable SQL servers.
HTH
Dick
At 2:59 PM -0400 6/2/2000, Gilles Ratte wrote:
>The problem I have is that that client database is on the same server than
>the web root and I think it's not right.
>
>I would like to move that ms access database to the other server behind the
>firewall and have access to the database via CF.
>
>Can somebody guide me on how to do it?
>
>Thanks in advance
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.