>>>>
>>>>PMFJI, Do I understand correctly that the SQL 2000 ODBC will work with SQL 2008 except for the new data types, like Date type, correct? I have to make my app support varchar(MAX) type and therefore have to stay with SQL 2000 ODBC. Therefore, I need to make sure not to use DATE type in the SQL 2008. Just wanted to clarify.
>>>
>>>Yes it's correct
>>
>>Thank you.
>
>Another option is to use CA with ADO

Sergiu this was working and does work in other places. the code has not changed something outside of vfp has, the odbc driver, an os update, a sql update the key is to manage the change (which means discovering what changed) not gutting the entire app creating hundreds of changes....

This all works fine for naomi I will follow her course for now

Thanks