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
