Date Problem when Rehosting Site to new Server

[Steve101]

Hi,

We have rehosted an Access database and ASP based web site (which connects to the database) to a new Server computer.

The application is now having date problems. This is caused by the fact that on the new server, the locale of the regional settings are set to ENGLISH AUSTRALIA, as opposed to ENGLISH UNITED STATES.

Here's the question:

Is there a simple way of configuring IIS, ASP or anything else to recognise the date format as dd/mm/yy WITHOUT changing the locale setting (ENGLISH AUSTRALIA is correct for this configuration) AND without having to change ASP Code.

The database access is currently controlled by ODBC based connections defined via DSNs located on the server.

If this cannot be achieved by configuration outside of the server, then Im happy to go into the code, and change some sort of Connection level properties; I just dont know how to do this (hense this post!)

I am a bit loath to go in and change code beyond the method above (eg. using the format function to control date handling) unless I absolutely have to.

Any assistance would be really appreciated,

Thanks in advance,


Steve Lewy
Solutions Developer
steve@simplydata.com.au
(dont cut corners or you'll go round in circles)

 

[Steve101]

OK. Think Ive resolved this myself. Anyone who is interested, check out:

http://www.4guysfromrolla.com/webtech/031401-1.2.shtml

for a way to resolve the problem via minimal coding. Not sure there are any other options.




Steve Lewy
Solutions Developer
steve@simplydata.com.au
(dont cut corners or you'll go round in circles)