>server
>win 200 server
>mysql 4.0.18-nt
>
>workstation
>os = winxp sp1
>odbc = mysql odbc 3.51
>vfp 8.0
>
>
>i have successfully created a connection in mysql,
>on the process of creating the remote view, all the tables of the database were listed, but when i am trying to add the table i receive an error:
>
>connectivity error: [mysql][ODBC 3.51 Driver][mysql 4.0.18-nt] table root.member doesn't exist.
>
>On the contrary when i use SPT commands i gain access to the table but i can't make the cursor updatable.
>
>what did i miss on the server or on the workstation.
>
>many thanks.

table [root dot member] ?
hmmmm
try
changing your connection info to default to 'root' as the default database, then move on with your remote view.

--
at a minimum - try making a system dsn in the odbc manager, and test it .
---
add a table into mysql via vfp ? how you doing that, exactly ?
---
you have writes to 'add' stuff ?
---
spt
lcsql = sqlexec(lnhandle, "select * from yourtable ","yourcursor")
use dbf("yourcursor") again alias IAmReadWrite

---
usually for a remote view to NOT be updateable or insertable from a mysql backend, you failed to identify a PRIMARY KEY column.

====