Web Serviece Error
-
Hi., I am trying to send dataset to Webservice but if my dataset table have more than 3000 rows then it send SoapException.Exception is about Content-length. How can I send Dataset with Table having 100000 records Thanks in advance. Navneet.H
Develop2Program & Program2Develop
-
Hi., I am trying to send dataset to Webservice but if my dataset table have more than 3000 rows then it send SoapException.Exception is about Content-length. How can I send Dataset with Table having 100000 records Thanks in advance. Navneet.H
Develop2Program & Program2Develop
A request is limited to 4 MB by default. You have to change the settings in web.config on the site hosting the web service, so that it can accept larger requests. Also, sending it as a data table means that there will be a lot of overhead in the serialising. An array of custom objects should reduce the size of the request. Another alternative would be to serialise the data yourself using a BinaryWriter and then encode it using base64. Why are you sending so much data to a web service anyway?
--- "Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things." -- Douglas Adams
-
A request is limited to 4 MB by default. You have to change the settings in web.config on the site hosting the web service, so that it can accept larger requests. Also, sending it as a data table means that there will be a lot of overhead in the serialising. An array of custom objects should reduce the size of the request. Another alternative would be to serialise the data yourself using a BinaryWriter and then encode it using base64. Why are you sending so much data to a web service anyway?
--- "Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things." -- Douglas Adams
Hi., I am having two servers on server-1 there is my Applicaton that copies the data from MS Access, creates the dataset and provide to the Webservice .On server-2 there is my webservice which accept the dataset and using sqlBulkCopy Fill Data into SQL Server. so problem is that all the tables having nearly 3000 records are successfully loaded , but the tables with more records are throwing exceptions. This is where I am getting the problem. Thanks, Navneet.H
Develop2Program & Program2Develop
-
Hi., I am having two servers on server-1 there is my Applicaton that copies the data from MS Access, creates the dataset and provide to the Webservice .On server-2 there is my webservice which accept the dataset and using sqlBulkCopy Fill Data into SQL Server. so problem is that all the tables having nearly 3000 records are successfully loaded , but the tables with more records are throwing exceptions. This is where I am getting the problem. Thanks, Navneet.H
Develop2Program & Program2Develop
I see. Any progress with what I suggested?
--- "Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things." -- Douglas Adams
-
I see. Any progress with what I suggested?
--- "Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things." -- Douglas Adams
Hi !! Yea! I have set the maxRequestLength ="2097150" now the data is flowing across and all is fine , only concern is speed so I am trying to compress and decompress at respective ends. Respect Navneet.H
Develop2Program & Program2Develop