ADO: Locale And Decimal Separator

Hi

I am working on an application that uses ADO to retrieve data from SQL Server 2005. It may be used against various instances of databases and each instance contains floating point values that may used comma (',') or point ('.') as decimal. This is where the problem occurs. Depending on the database instance the strings containing floating point values also use comma or point as decimal separator.

Is there a way that by which I can force the database to return floating points with decimals separated by point? Doing a prelimimary google search, I found hints of including "Locale Identifier" in the connection string such as




Code Block
Provider=SQLOLEDB.1;Persist Security Info=True;Locale Identifier=0x0409;User ID......




but even if I specify US English locale, it does not remove the commas in floating point data.

Kind regards
Jens Ivar