Hi,

Problem with time zone with IIS
We have two application running in a web server(IIS), one application is for UK user's and other for UAE user's.

Can we do anything that application/database caters to the time zone for UAE and UK users running on same iis.

Thanks in Advance,

KCube

 Hi,

Its not a problem with IIS, you need to localize your application to support different timezones. You need to ask the user to enter which time zone he is in, you can do this while:

1. asking him during registration

2.  by clicking some flag or link for UK and UAE, switching locales on the click event

3. or you can check locale via IP (more intrensive).

Then you need to set the timezone in the thread accordingly. You can refer these links:

http://forums.msdn.microsoft.com/en-US/netfxbcl/thread/772971a4-9f1b-4004-a873-c1e0e2098852 

http://www.codeproject.com/KB/aspnet/HostedTimeZone.aspx

Hope this helps,

Vivek 

HI,

Thanks very much,

I still face problem with database..

i have two database running a single sql server, one for uae and other for uk, can i change to time zone of the database seperately.

Thanks,

kcube

Hi,

 I agree that  getDate() returns the server date, and its not possible to set  datetime value for each database running in single sql server.

Still i hope there is some solution for this. Please help?

Any suggestion other than with UTC is appreciable.

Thanks,

KCube

You need to stre timezone in the database table, and do calculations based on that. Refer these articles:

http://www.netnewsgroups.net/group/microsoft.public.dotnet.framework.aspnet/topic20684.aspx

http://forums.asp.net/t/894118.aspx?PageIndex=2

HTH,

Vivek