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
Extreme Programming = Plan -> Design -> Code -> Test