February 16, 2010 at 2:59 am
Hello, I'll try to explain clearly my issue,
I've been creating a managment software for several institutions of my company all over the world...
The client is In FLEX using webservices in .NET (C#) linked to a sql server 2005 database
HEre is my problem
Until now everything was working perfectly, everytime i had a time and a date i would enter it in visual studio as UTC and when i would try to retreive it FLEX would automatically change the timezone according to the location of the client....
I reinstalled my computer and upgraded to Win 7 reinstalled EXACTLY the same versions of all my softwares, (FLEX, VS AND MSQL) and weird, now when i program all the dates come in UTC in flex, it doesn't convert it anymore....
Ok so i thought might be a flex problem.... So i connected my local development environment to the actual release database on the web.... and their it works, FLEX converts the dateTime to a correct format again even if i use it from my local computer....
So can't come from flex I assume then it's a configuration problem either in SQL Server or VISUAL STUDIO, but can't seem to find what the matter is.... maybe i did something wrong when reinstalling everything but can't find....
As someone already got this kind of problem?
It's not really important as the released server still works perfectly even when i put updates of the software, it's only on my local environment... SO i can still work, but can never see the good dates anymore....
Please help.... Hope I've been clear...
Thanks in advance...
February 16, 2010 at 3:39 am
Have you checked that its not related to a collation issue on the database, in that its set to a different collation to that expected. Can happen if SQL Server was installed when the language settings in windows were set differently in environments.
February 16, 2010 at 3:51 am
Hello,
Thanks for the answer.
I already checked this and the collation is correct, it's the same than the previous installation, and the same with my web environment...
I just reinstalled compeltly sql server and the database locally to check, and the same problem stil occurs....
Well I'm thinking if it doesn't come from FLEX neither from the database itself, it might come from visual studio....
February 16, 2010 at 4:04 am
Some News
Just tried using my local webservice, but connecting to the distant database, and i have the same problem.. So the problem definitly don't come from SQLSERVER but from my webservice apparently....
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply