Thanks Bill,

I was about to throw my computer out the window yesterday. I tried doing the spt and was getting the same problem. The solution -- My mysql table was empty. I had to add a record with fields that were the length of the AgencyName and AgencyNumber character length.

I didn't think I could do a remote view unless it was part of a dbc. I do like the CA (now that it works).

Have a nice weekend,

Michael
>Hiya Michael -
>does it have to be a CA ?
>if not -
>why not chose one one of the following ?
>1. scan..endscan on your table with a SPT for insert to mySql via odbc [system DSN or string connection]
>2. make remote view to the mysql table, and then scan..endscan on your vfp table to the remote view?
>3. still using the fox 2.x product? there is TCP/IP library for mySql that works rather well.
>
>As to your column types not mapping to the right type - man - thats a weird one. Smells Fishy.
>
>I don't have that problem with using a remote view based on a system DSN for odbc.. If it consistently fails on all records, then its a mystery to me. If it fails on one or two records - then there is some munged data in there.
>
>hth - mondo regards [Bill]