I'm running into an odd date format problem.

I'm connecting to an SQL database through ODBC (v3.70.06.23) from a simple VFP application. When I query the database through SQLEXEC() my application date format changes from MM/DD/YYYY to YYYY.MM.DD on all the controls(text boxes, report fields). Once the application is restarted, the correct format is there once again.

I looked into the regional settings while the application is running, played around with the various ANSI and regional ODBC driver settings, and tried SET DATE but all to no avail.

I'm trying to replicate the problem in the office on another SQL Server database but I cannot make it happen.

Has anyone ever run into this situation before? Any suggestions?

Tom