Re: Primary Key with a datetime datatype

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 10/18/04 

Date: Mon, 18 Oct 2004 23:13:57 +0200

Perhaps the app passes appropriate SET DATEFORMAT command, but in a different connection? I'm
thinking things like connection pooling etc. It is definitely an app issue, and Profiler should
reveal what is really happening. I'd strongly suggest to the app vendor to use a "safe" format. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Colleen Rossman" <crossman@discussions.microsoft.com> wrote in message 
news:75915596-9A5C-4665-950D-794B05F957C6@microsoft.com...
> Yes, the vendor does claim it's 'by design' and it's been this way for a long
> time.  However I found a 'set dateformat=dmy' statement in the trace output
> which works in QA, allowing me to pass ddmmyyyy format without error,  but it
> didn't work in the app and that's teh real issue here.
>
> Colleen
>
> "Adam Machanic" wrote:
>
>>
>> "Colleen Rossman" <crossman@discussions.microsoft.com> wrote in message
>> news:DDBAF283-CC40-408A-B942-428DF8A157E3@microsoft.com...
>> >
>> > SQL profiler indicated the app was passing a date value in format that is
>> > incompatible (passing dd-mm-yyyy).  I am able to reproduce the error in
>> Query
>> > Analyzer.
>> >
>> > Is there something I don't know about the internal storage of a primary
>> > key/datetime datatype that would cause this error?
>>
>>     Aboslutely not...
>>
>>     But why did the date format that the app is passing change?  Does the
>> vendor claim that it was that way before?
>>
>>
>>

Relevant Pages

  • Re: Newbie: Saving as Word doc
    ... I've inherited a VB app that experts here say is poorly written. ... Merely changing a file's extension does NOT "convert" that ... application has to support the file's format). ... > goes back into the folder, opens every doc, and resaves it as a Word doc. ...
    (microsoft.public.vb.general.discussion)
  • Re: Output to text files or a database?
    ... This software has to do with the retrieval and processing of travel ... With plain text files being the universally loved file format, ... Another small app would read these text files, ... from the database, after all. ...
    (comp.unix.programmer)
  • Re: VB & SAL Date/Time Problem?
    ... site you can format it as YYYYMMDD. ... > I've written an ASP app that requires users to login - normal stuff. ... > following SQL statement: ...
    (microsoft.public.sqlserver.programming)
  • Re: adding "floating notes"
    ... Word has nothing to offer in that regard. ... Stickies app also has a number of other features as well. ... Another option based on Daiya's suggestion wouldbe to format the 'note' text ... then slowly scroll back up past the notes until I find the ...
    (microsoft.public.mac.office.word)
  • Re: Migrate from Access 97?
    ... understand, you can move to Acc2007 but stay under the .mdb format, ... you can distribute on one CD a copy of your app in 97 along with the Access ... That positions you to support all versions of Windows from Windows 95 ... Using InstallShield 2010 I can distribute one ...
    (comp.databases.ms-access)