If the machine that has the TXT file has CF on it, then you can do the
following: (Provided WDDX can handle a file that big - someone else might
have a handle on this)
1) Make a CFHTTP call to the base machine from the remote machine that
calls a script on your base machine. Have that script to query the TXT file
and use WDDX to send the contents of your TXT file back to the remote
machine.
2) Parse out the WDDX packet and update your Access database.
Dave
----- Original Message -----
From: "Bob Lehman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 21, 2001 8:13 AM
Subject: Linking Databases and files on remote server
> Hi all
>
> I thought I had seen reference to this awhile back but have yet to find
it.
> So I will ask the question.
>
> I have a TXT file (6000+ records)on a remote server (ISP). On a nightly
> basis this file is getting replaced with a new one as all the data
changes,
> and I need to take the data and place into the ACCESS database. Now on my
> local development machine that's no problem. I just have a link to the TXT
> file and run a query and delete and update the database. On the remote
(ISP)
> machine there is a problem as the link I established on the development
> machine does not have the same mappings as the ISP server. Any idea's on
> how to get around this. I really need to be able to upload the database on
> the ISP machine nightly using the TXT file and I cannot see FTPing in a
new
> database nightly.
>
> Any suggestions would be a great help.
>
> TIA
>
> Enjoy
>
> Bob Lehman
> New Horizon Mgmt and Consulting
> 440-542-0992
> [EMAIL PROTECTED]
> www.nhmac.com
> www.nhmac-user.com
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
