Re: CF10 Webservices error

[Kambiz Heydari]

Yes - It works without any issue.
On Tuesday, April 29, 2014 6:07 PM, Dave Watts dwa...@figleaf.com wrote:
  

 Error Occurred While Processing Request
   Unable to read WSDL from URL: 
http://www.webservicex.net/CurrencyConvertor.asmx?WSDL.
 Error: java.net.SocketException: Permission denied: connect. It is 
 recommended that you use a
 web browser to retrieve and examine the requested WSDL document to ensure it 
 is correct.

Have you tried using a web browser from the server running CF 10 as
suggested? It could be a networking problem unrelated to CF.

Dave Watts, CTO, Fig Leaf Software
1-202-527-9569
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.



~|
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:358474
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Coldfusion 9 SQL Server 2008 XML bulkload

[Kambiz Heydari]

Thanks Steve,

Kambiz Heydari
(781) 898-8857

On May 3, 2011, at 7:01 AM, Steven Durette st...@durette.org wrote:

 
 First SQL has to be running under an account that has access to that 
 directory. Then it is easiest if you make a share, then you reference it as 
 \\sernername\sharename\filename
 
 Steve
 
 Sent from my iPhone
 
 On May 3, 2011, at 12:48 AM, Kam Heydari heyda...@yahoo.com wrote:
 
 
 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:344157
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm