The domain account that we use to run the CF service has write access to a couple of shared directories to which the account that our SQL server runs under also has access. It's sort of a drop box for sharing files between the two :)
As far as the logins - any query that needs to do this can easily have the default connection permissions overridden by passing a less restrictive logon id and password to the cfquery tag for this operation. Roland -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Munson, Jacob Sent: Thursday, July 14, 2005 3:59 PM To: [email protected] Subject: RE: [CFCDev] gateway CFCs I tried to do this once, and ran into all these problems because I needed to put the file in a place SQL server had rights (on a different server than the web server), plus the SQL server user had to have special privileges to do a bulk insert. Maybe other people have had better luck with this than me. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill Rawlinson > Sent: Thursday, July 14, 2005 11:41 AM > To: [email protected] > Subject: Re: [CFCDev] gateway CFCs > > Oracle has a similar function but to be honest I don't > remember what it is. > > FYI Here is a very basic call to the SQL server bulk insert > > > <cfset filepath = "absolute path to a file on the SQL server"> > > <cfquery dataSource="#someDSN#"> > BULK INSERT someTableName FROM '#filePath#' WITH > (FIELDTERMINATOR = ',') > </cfquery> > > > > > > On 7/14/05, Roland Collins <[EMAIL PROTECTED]> wrote: > > Using the SQL BULK INSERT command or it's equivalent. > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > > Of [EMAIL PROTECTED] > > Sent: Thursday, July 14, 2005 1:00 PM > > To: [email protected] > > Subject: RE: [CFCDev] gateway CFCs > > > > How else can you do "bulk" insert/updates without doing a > loop over a > > SQL Insert/Update statement? > > > > Tom > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Nando > > Sent: Thursday, July 14, 2005 12:29 AM > > To: [email protected] > > Subject: RE: [CFCDev] gateway CFCs > > > > > > >I think the problem we might be encountering is trying to map > > everything we > > do to a defined Pattern. > > > > Hmmm ... you know, if i had an app that did a lot of bulk > updating and > > within the architecture, the DB handling object seemed like it just > > didn't > > fit in as either a DAO or a Gateway, i'd be willing to try > making it an > > object in it's own right. Gridway, Grateway, GAO, an MDAO - > at least i > > could > > try it and see if it fell into place nicely. > > > > It's My App - TM :) > > > > > > > > > > > > ---------------------------------------------------------- > > You are subscribed to cfcdev. To unsubscribe, send an email to > > [email protected] with the words 'unsubscribe cfcdev' as > the subject of > > the email. > > > > CFCDev is run by CFCZone (www.cfczone.org) and supported by > CFXHosting > > (www.cfxhosting.com). > > > > CFCDev is supported by New Atlanta, makers of BlueDragon > > http://www.newatlanta.com/products/bluedragon/index.cfm > > > > An archive of the CFCDev list is available at > > www.mail-archive.com/[email protected] > > > > > > > > > > ---------------------------------------------------------- > > You are subscribed to cfcdev. To unsubscribe, send an email to > > [email protected] with the words 'unsubscribe cfcdev' as > the subject of the > > email. > > > > CFCDev is run by CFCZone (www.cfczone.org) and supported by > CFXHosting > > (www.cfxhosting.com). > > > > CFCDev is supported by New Atlanta, makers of BlueDragon > > http://www.newatlanta.com/products/bluedragon/index.cfm > > > > An archive of the CFCDev list is available at > > www.mail-archive.com/[email protected] > > > > > > > > > > > > > > > > ---------------------------------------------------------- > > You are subscribed to cfcdev. To unsubscribe, send an email > to [email protected] with the words 'unsubscribe cfcdev' as > the subject of the email. > > > > CFCDev is run by CFCZone (www.cfczone.org) and supported by > CFXHosting (www.cfxhosting.com). > > > > CFCDev is supported by New Atlanta, makers of BlueDragon > > http://www.newatlanta.com/products/bluedragon/index.cfm > > > > An archive of the CFCDev list is available at > www.mail-archive.com/[email protected] > > > > > > > > > -- > [EMAIL PROTECTED] > http://blog.rawlinson.us > > If you want Gmail - just ask. > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email > to [email protected] with the words 'unsubscribe cfcdev' as > the subject of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by > CFXHosting (www.cfxhosting.com). > > CFCDev is supported by New Atlanta, makers of BlueDragon > http://www.newatlanta.com/products/bluedragon/index.cfm > > An archive of the CFCDev list is available at > www.mail-archive.com/[email protected] > > > > > This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). CFCDev is supported by New Atlanta, makers of BlueDragon http://www.newatlanta.com/products/bluedragon/index.cfm An archive of the CFCDev list is available at www.mail-archive.com/[email protected] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). CFCDev is supported by New Atlanta, makers of BlueDragon http://www.newatlanta.com/products/bluedragon/index.cfm An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
