July 5, 2005 at 9:32 am
Last month we upgraded hardwared to Windows 2003 from NT. The Database was left at SQL 7.0
since the upgrade, we have a strange issue with the client application. The application is a interest rate amortization program. The program gets the current date from the db and displays the date to end-user and calculates upcoming rates from the starting date: ie 5/1/05 until the end of the term (ie 36 months)
The appl. displays the proper date/rates if the client's settings are US region. However, if the client PC's regional setting is UK, the date is scrambled and shows improperly... For example, the valid display of 5/1/05 which should display as 1/5/05 in UK notation, displays something like 1/7/05 and the rate is calculated as if the date was July 1st, 2005.
We have temporarily resolved the issue by having the UK clients' regional settings set to US time; however, we're looking for an answer on what could be wrong.
Thanks for any input.
July 5, 2005 at 9:44 am
if this is only happening when reading then you should look at the App code. if it happens after an insert on the DB you may try to look at some SQL calls when the connection is established like "SET LANGUAGE british"
* Noel
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply