>any example for me , when i want using vfp to access sql server database, because i have using odbc before, is very slow and unconfortable.

It's not ODBC that's slow but generally either network or code requesting more than needed (or even backend). However ODBC would be slow if you're not using prepared calls or stored procedures but that's not fault of ODBC or OLEDB.

lnHandle=SQLStringConnect('DRIVER=SQL Server;SERVER=(local);DATABASE=pubs;'+;
   'Trusted_Connection=Yes')
lnResult=SQLExec(m.lnHandle, "select * from authors", 'crsAuthors')
SQLDisconnect(m.lnHandle)
select crsAuthors
browse

Is a simple one with no error checking (if lnResult is not > 0 check aerror()). On UT (and in help file) there are plenty of other samples connecting,querying,updating using RV,SPT,CA.
Cetin