Search results for query: *

Ok if it has information like this below, how would one approach things, kindly note I am referencing a tutorial I am currently reading on SOAP https://www.w3schools.com/xml/xml_soap.asp Soap request POST /InStock HTTP/1.1 Host: www.example.org Content-Type: application/soap+xml...

Sorry I don't think I follow or maybe it is due to the fact I have limited knowledge about SOAP, I know a soap is a a combination of XML and a HTTP request, I assumed if one can get the http request and http response working, then the only add-on is the XML envelop which contains all required...

I was looking for an example but I will see what I can create by writing the C# code

Yes I just realised so after contacting the vendor, I am trying to see if there is any good sample code for it.

thanks cjard and skydiver those are good points, hence can someone please guide me on how to call a http SOAP request, get an http SOAP response as a excel, all help is appreciated

By the way, do you happen to know if there steps to see the details of the files that could help one tweak the code

I mean when you using webclient to download it, it would show up the message it is corrupt, I sent you a manually downloaded file to show it is purely a xlsx file

So I spent time re-writing the code to use HTTPweb request but unfortunately I am still giving the same error. Please see the other code below HttpWebRequest fr = (HttpWebRequest)WebRequest.Create("www.testurl.com/report"); fr.Method = "GET"; HttpWebResponse fresponse =...

I Hi, I have done so. Thanks

I get the message the uploaded file does not have an allowed extension. The following extensions are allowed: .zip, .txt, .pdf, .png, .jpg, .jpeg, .jpe, .gif, .m4v, .mov, .mp4, .mp4v, .mpeg, .mpg, .ogv, .webm, .mp3

Please see the attached file. Kindly note, I am only trying to download the test file for now since my above code is not working well

Do you mean upload the file to the forum?

Sorry it was a typo but yes I am sure it is downloading a excel spreadsheet because I tested it manual at the source

I have a code similar to this below C#Copy using(webclient wc = new WebClient()) { string fileinfoname = "test_one"; string pathinfo = @"C:\testfolderinfo" + fileinfoname + ".xlsx"; wc.downloadFile("www.testurl.com/report", pathinfo); } I am currently experiencing a situation where the file...

Sorry about the late reply, the source was a csv file, I was trying out several approach to fix it. and I noticed that i had to redesign my tables to use all nvarchar columns and import the data using SSDT as unicode for it work properly, which I find a bit strange. just another quick question...

I am using Microsoft sql server 2019 - 15.0, SSMS 18.7.1 and Latin1_General_CI_AS but i tried changing it to a different collate in the query like this below select id, desc_info collate Latin1_General from metest but was told it was an invalid collate

OK I didn't know, so my question is in regards to the following example, I can save the following word s'il vous plaît in my nvarchar(2000) column which is called desc_info but when I write a select * from metest, the word doesn't display correctly in SSMS. How do I get it to show s'il vous...

Hi jmcihinney whenever I write a query in SSMS, i tend to see a strange symbol for the french character, how do i get to see the actual symbol instead. please note, this is not a .net code

Hello all; This has been puzzling me for a while. I have a table structure similar to this below to hold french word create table metest ( id numeric ,desc_info nvarchar ) Hence, i know nvarchar tends to store the data as bytes, thus when i write select id, desc_info from metest, how do i...

So, I have figured some of it out. you will need to create an SSIS package with the following components Flat file source --> script component --> OLE DB destination In the script component, you will click edit to write a bit of C# or VB code in the following methods below. for instance, in...