Thanks for the suggestions guys, I just changed the user to sa in the admin panel for my data source and it worked right off, whch would suggest this IS a permissions issue with my DB user, any ideas what rights they need? They currently have datareader and datawriter access to the db but that's it.
Thanks, Rob -----Original Message----- From: Gert Franz [mailto:[EMAIL PROTECTED] Sent: 23 April 2007 14:54 To: CF-Talk Subject: Re: Bulk Insert What about testing it on the server itself. Does the query succeed in the Query Analyzer? I guess there you will get more information about any errors. Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ Robert Rawlins - Think Blue schrieb: > Thanks AJ, > > SQL and CF are both on the same box for sure, are there likely to be any > logs create anywhere by SQL that are likely to give me a better picture of > what's going wrong? > > Thanks, > > Rob > > -----Original Message----- > From: AJ Mercer [mailto:[EMAIL PROTECTED] > Sent: 23 April 2007 14:25 > To: CF-Talk > Subject: Re: Bulk Insert > > The text file needs to be on the SQL server > > Is CF and MS-SQL on the same box? > If not, you will need to get the text file onto the SQL Server. > > On 4/23/07, Robert Rawlins - Think Blue > <[EMAIL PROTECTED]> > wrote: > >> Following on from my query this morning about the stored proc, I've >> started >> dabbling with the query in CF to start with, just as it feels more >> familiar. >> >> >> >> I'm struggling to get the following piece of code working though: >> >> >> >> <cfquery name="qCommitLogs" datasource="MyDSN"> >> >> BULK INSERT DeviceStaging >> >> FROM 'D:\test.txt' >> >> WITH (FIELDTERMINATOR = ',') >> >> </cfquery> >> >> >> >> <p>Done</p> >> >> >> >> This just returns a blank page, no error messages and nothing gets >> inserted >> into the database table. Both the TXT file and DeviceStaging are 4 columns >> and the datatypes appear to match. >> >> >> >> 00:00:00:00:00,1,2007-01-01 12:00:00,1 >> >> 00:00:00:00:00,1,2007-01-01 12:00:00,1 >> >> 00:00:00:00:00,1,2007-01-01 12:00:00,1 >> >> 00:00:00:00:00,1,2007-01-01 12:00:00,1 >> >> 00:00:00:00:00,1,2007-01-01 12:00:00,1 >> >> >> >> Columns are: >> >> >> >> MacAddress Varchar(50) >> >> Port TinyInt >> >> DateTime DateTime >> >> Class TinyInt >> >> >> >> Any ideas on where to started with this? >> >> >> >> Thanks, >> >> >> >> Rob >> >> >> >> >> >> >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:276022 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
