I'm using a DSN for to connect to VFP6 Database. With ADO 2.5, I do something like this:
connection.open "MyDSN"

Someone here, recommend me to do this with VFP ODBC Driver:
=SQLEXEC(lnConnection,"SET EXCLUSIVE ON; PACK MyTable")

How do that with ADO? I guess that must be something like this:
connection.execute "SQLEXEC(lnConnection,"SET EXCLUSIVE ON; PACK MyTable")".

Well, I don´t know to use the VFP ODBC Driver with ADO from VB.

Thanks for anyone that help me!!!!!

German