>>I didn't realize that ODBC wouldn't work for any files above VFP 6.0. So, do I have to go with OLEDB, but how with ColdFusion?
>
>I don't think that is the problem. Free tables are VFP6 compatibles.
>And you CAN connect to them with VFP through ODBC, isn't it? :-)
>So ODBC is not the case here.

Are you sure, Borislav?

varchar, autoinc and varient are available for free tables, I believe in VFP9. and if they are, ODBC does not like them.

Beth