Error: Server was unable to process request. --> String was not recognized as a valid DateTime.   

Hi,

I've got a strange problem when I'm returning a DataSet through one of my
WebService methods (ExecuteReaderWS(string commandText)): It returns the
above exception at:

-----------
[SoapException: Server was unable to process request. --> String was not
recognized as a valid DateTime.]

System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
Message message, WebResponse response, Stream responseStream, Boolean
asyncCall) +1501
   System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) +218
....
-----------


Where's that coming from? I'm addressing a SQL Server 2000 database.

I don't know, but is it an error to use SMALLDATETIME columns in SQL Server?

Your quick reply is quite appreciated!

TIA,
Axel Dahmen

date: Thu, 6 Apr 2006 18:32:58 +0200   author:   Axel Dahmen am

Re: Error: Server was unable to process request. --> String was not recognized as a valid DateTime.   

No help? ...MS?



--------
"Axel Dahmen" <KeenToKnow@newsgroups.nospam> wrote in message
news:uDZKFfZWGHA.4768@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> I've got a strange problem when I'm returning a DataSet through one of my
> WebService methods (ExecuteReaderWS(string commandText)): It returns the
> above exception at:
>
> -----------
> [SoapException: Server was unable to process request. --> String was not
> recognized as a valid DateTime.]
>
>
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
> Message message, WebResponse response, Stream responseStream, Boolean
> asyncCall) +1501
>    System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) +218
> ...
> -----------
>
>
> Where's that coming from? I'm addressing a SQL Server 2000 database.
>
> I don't know, but is it an error to use SMALLDATETIME columns in SQL
Server?
>
> Your quick reply is quite appreciated!
>
> TIA,
> Axel Dahmen
>
>

date: Mon, 10 Apr 2006 15:05:59 +0200   author:   Axel Dahmen am