Re: Error 242, Severity : 16, State : 3

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 09:59:54 +0530

Hi Li,

I feel that this error is no way related to a Login issue. This MSG: 242
normally comes while you give invalid date format on
datetime data type.

set language us_english
declare @k datetime
set @k='25/07/2004'

Thanks
Hari
MCDBA

"Li" <Li@discussions.microsoft.com> wrote in message
news:B29BFC56-EBF9-48AB-8DE4-8898659BEC9C@microsoft.com...
> I tried to transfer the data from one application to another. Under the
SQL Profile it stated Error 242, Severity : 16, State : 3. Any idea? SQL
provide an logging "sa" error. I have checked the password for the
application setup, odbc and SQL, they are all identical. The applications
have no problem.

Relevant Pages

  • Re: Error 242, Severity : 16, State : 3.
    ... normally comes while you give invalid date format on ... datetime data type. ... set language us_english ...
    (microsoft.public.sqlserver.server)
  • RE: How to save "formatted text"
    ... You can update from lower to upper case or the reverse. ... You can update a text field with a different format of datetime data. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Convert Date-Time Field to Date
    ... SMALLDATETIME have time components. ... What I think you want to do is format ... your DATETIME data as a string? ... > convert a date-time field to a date field? ...
    (microsoft.public.sqlserver.tools)
  • RE: SqlCeEngine.CreateDataBase() - LCID - Datepart format problem
    ... You can explicitly convert datetime data to your specified format by using ... | I´m setting a locale identifier in the connection string to ...
    (microsoft.public.sqlserver.ce)
  • Re: Text Date Field Query
    ... The data is entered in the format of 19750521, ... In other words I need the query to pull the records for the current month. ... It's always better to store dates as DateTime data types, ...
    (microsoft.public.access.queries)