I'm using Win2K, so this is how I would do it. Win 9x and Win XP are all a little different, but similar:
1. Open the ODBC Administrator: Start>Settings>Control Panel>Administrative Tools>Data Sources (ODBC)
2. Select the DSN that you are using from the lists from the appropriate tabs (User DSN, System DSN, File DSN).
3. Click the "configure" button.
4. Click the "Next" button until the button caption changes to "Finish".
5. There's a check box on the tab that says "use regional settings for currency..." etc. That's where the setting is made.

Another thing you can do to check the connection properties is to look at the connection string that is being used by the connection. You can get that by connecting to your data source with the DSN and calling the SQLGetProp function, like this:
nHandle = SQLCONNECT( 'YourConnection' )
? SQLGETPROP( nHandle,"ConnectString" )
This can help you figure out what's going on.

HTH : )
Ken

>Dear all,
>
>I have a problem about VFP to retreive SQL data via ODBC. I checked the option "Use regional settings when outputting currency, numbers, dates and times" on the ODBC driver. Once, I retreive the data from SQL via ODBC, all returned numeric value change to currency format (e.g. 1000 -> 1,000.00). When I display the value of field in VFP, it return 1 for the value. I don't know to uncheck the option on ODBC. Have any way to set the format of return value from Connection String? Thank you very much ....
>
>Best Regards,
>
>Justy Chow