Hosting server regional settings in US, I want them in FR-CH !

Hi,

My hosting server has American regional settings (dates are mm/jj/yyyy hh:mm:ss XM) and, since I have swiss visitors, I would like to view my dates as jj.mm.yyyy hh:mm:ss
I could make a function to display it in swiss format, but it would be too long to change everywhere. Is there a possibility to define new regional settings just after the connection string, or something like that ?

Please help, very urgent.

http://www.manege-corsier.ch

Yes, the parameter in question is called Locale Identifier and you have to set it in the connection string something like this:
"Locale Identifer=4108;"

See http://msdn.microsoft.com/library/d...l/vsmscLCID.asp for a list of valid locale identifiers.

Well, I've added it in my connection string :

dbconn.open "PROVIDER=SQLOLEDB;DATA SOURCE=sql.mywebserver.com;DATABASE=mydb;UID=user; PWD=pwd;Locale Identifier=4108;"

But I still see dates as "4/17/2004 03:15:45 PM" for April, 17th 2004...
I want "17/04/2004 15:15:45" or "17.04.2004 15:15:45" !!!

I've tried Session.LCID=1408, but it returns me "Bad LCID".

Do I have to put a little function like "US2CH" in front of all my dates ? If yes, that really suck !

I'm programming SQL for years, and I never found a solution to this problem ! Please help me.....

OK I'm too bad...
Session.LCID = 4108 (not 1408) and it shows me dates as I wanted to...

Thanks a lot...

OK now, i just realize i've got another problem... When I do "Now()", it returns me the USA time (for. ex. it is 09:52 in Switzerland, and 02:52 in USA)
What should I do to change the Locale Time Zone ?