Chuck,
Check out the following link:
http://www.able-consulting.com/ADO_Conn.htm
HTH

>I am a little confused about how to create a ADO DSN-less connection. Every example I look at uses SQL Server. What about VFP?? What about free tables?? Does the DSN-less connection only work with SQL Server?
>
>I would appreciate a real example of a DSN-less connection to VFP free tables and VFP DBC. I was trying to use an ActiveX OLE control on a form and could not get the "connectionstring" property to work. I put the text in the following properties :
>recordsource = 'freetable'
>connectionstring = '\\server_path\server_name\data_dir\'
>I also tried
>connectionstring = "server='\\server_path\server_name\data_dir\';
> driver='visual foxpro table';table='bank'"
>
>I appreciate any help. Thanks, Chuck