John;
Tried this method and the field types are the same.

Bob;
The fields that we are using in SQL server are of Type 'Char' size 254.

Note :
I changed the field to be type 'Text' on 6.5 and 7.0 and Checked Foxpro and it shows the the Type as 'Memo' this is a correct mapping yet i still receive the error message at the clients end on 6.5. We are developing on 7.0.

Shawn
Thanks for the replies
I Hope this new info helps out