Hi,
Anyone know how to pass file name to the bulkload when sqlserver and coldfision
servers are on different physical servers; The following xml load works when
both SQl and CF servers are residing on the same physical server.
- How I can refer to the local file where sqlserver can access it?
- Any alternative ways?
Thanks
K
EXEC('
INSERT INTO [ProjectXML](Code, Reference, xmlFileName, [xmlDocument])
SELECT '''+'2503'+''','''+'455'+''', ''' +
'C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp6410035959573708012.tmp'
+ ''', xmlData FROM ( SELECT * FROM OPENROWSET (BULK ''' +
'C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp6410035959573708012.tmp'
+ ''' , SINGLE_BLOB) AS XMLDATA ) AS FileImport (XMLDATA) ')
Error when on different servers:
Message: Error Executing Database Query.
Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot bulk load because
the file
"C:\ColdFusion9\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotmp4527544419188947137.tmp"
could not be opened. Operating system error code 3(The system cannot find the
path specified.).
sqlStatement: HY000
.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344153
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
