question

I have a .Net WCFWebService that connects to an MSSQL database. I am calling a stored procedure that takes an sql datetime value as a parameter which is passed from the web service application as a .NET DateTime value via a parameterised procedure call. However, i am getting the following error and i cant work out what the issue is (am new to MSSQL!):- "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated." Interestingly if i use the MsSQL profiler i can grab the executed SQL command and run it now problems from within Management Studio? It appears as:- exec dbo.VRS_UpdatePositionAndDistance @voyageid=19020,@portid=115191,@eta='2012-07-18 11:54:00:000' The database language is set to British, set language British set dateformat dmy Any help is greatly appreciated!!! Thanks. The Stored Procedure code is as follows: ALTER PROCEDURE [dbo].[VRS_UpdateETA] @index int, @eta datetime AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; UPDATE dbo.VMVoyagePort set ETA = @eta, where ID = @index END This procedure is invoked by the follwoing .NET code (ETA is a DateTime): dbWrapper.ExecuteProcWithParams("dbo.VRS_UpdateETA", dbWrapper.CreateParameter("@index", ), dbWrapper.CreateParameter("@eta", ETA)); public void ExecuteProcWithParams(string procName, params DbParameter[] parameters) { try { using (DbCommand cmd = db.CreateCommand()) { cmd.Transaction = trans; cmd.CommandText = procName; cmd.CommandType = CommandType.StoredProcedure; foreach (DbParameter param in parameters) { cmd.Parameters.Add(param); } cmd.ExecuteNonQuery(); } } catch (Exception) { throw; } } public DbParameter CreateParameter(string name, object value) { DbParameter result = null; switch (databaseType) { case DatabaseType.SqlServer: // Sql Server: NULL parameters have to initialised with DBNull rather than NULL result = new SqlParameter(name, value ?? DBNull.Value); break; default: throw new Exception(String.Format("Unknown database type {0}", databaseType)); } return result; }