I haven't done exactly what you are attempting to do, but we move files
over to our db server for bulk insert using cffile and UNC paths. So you
would use a cffile call with the action "move" and the destination \\{db
ip}\{share}\ The big gotcha (and possibly what's wrong with your
current process) is that there has to be matching user accounts on both
machines. We run Coldfusion under a named user account (cfusion in our
case) and once we set up a cfusion user account with a matching password
on the db server it worked like a charm. So the first thing I'd do is to
find out what account the CF service is running under, then make sure
its a named account and that there is a matching account on the other box.
Judah
Calvin Trinh wrote:
> I'm able to execute the batch file now but nothing happen. It seems
> like Coldfusion server doesn't allow me to map a shared drive on
> another server. What I want to do is to copy a file on the
> coldfusion server to my database server. I created a batch file to
> map the shared drive on my DB server and copy the file over to my DB
> server. Unfortunately, that didn't happen the way I intended to be.
> So, I just want to ask is it coldfusion not allowing to map a drive
> in the code or am I missing something. This is driving me insane.
>
> Thanks for the reply.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281656
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
