April 12, 2013 at 11:40 am
Hi,
we have the following problem in our app (Sage OfficeLine):
when changing a record, the app tries to write a record into an archive-tab which runs into an error since several days.
After debugging and running the ms-profiler, we got this result:
for writing the record the app calls 'exec sp_executesql N'INSERT INTO ...' with filling some datetime-fields
by a string with an init-value (should be 30. dec 1899);
this runs into failure, because '1899-12-30 00:00:00:000' is (now ?) thought as yyyy-dd-mm ...
but some weeks ago all went ok.
When installing a clear new demo-database by the app (same server, same user, same app - diff db),
the same app calls the sp_ with 'Dez 30 1899 12:00:00:000AM' and runs well (so here it's clear where the month is set) !
So - what is wrong on my productive database ?
(search for "1899" in the attachments)
April 12, 2013 at 11:49 am
Hi and welcome to the forums. It is nearly impossible to offer much help based on the extremely limited amount of information you provided. We don't know your systems, data structures, the procs you are calling or what you are trying to do. The best anybody can do is guess.
Please take a few minutes and read the article found by following the first link in my signature for best practices when posting questions.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 12, 2013 at 12:18 pm
sure .. so break it down:
where can I set the datetime-format for a specific database or database / user / field ?
April 12, 2013 at 12:34 pm
In Object Explorer, right click on the server, click properties. On the General page, what is the language setting?
April 12, 2013 at 12:37 pm
Also, using profiler, check the connection options for the problem database.
April 15, 2013 at 1:02 am
Server-language is set to: "Deutsch (Deutschland)" / "German (Germany)"
Language in Connection-Property for both database is: "Deutsch (Deutschland)" / "German (Germany)"
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply