I've been asking this question for awhile now and have yet to receive any good answers.

So, now I've finally installed SQL2008 on my machine and I built a table and used the new DATE datatype.

In VFP I ODBC'd the table down and GUESS WHAT?

Right! Exactly!

The DATE datatype gets brought down to VFP as, wait for drum roll... A FREAKING VARCHAR.

A VARCHAR!

It's a GD VARCHAR.

Boyz, we are screwed now. I'm running VFP 9 SP2, so there's nowhere to go to get this one fixed.