I’ve installed the latest Visual FoxPro OleDb drivers from Microsoft (http://www.microsoft.com/download/en/details.aspx?id=14839). I can access everything fine through Delphi’s DBGo components so I’m sure the ADO option could work in Schema Modeler, but I haven’t figured the magic formula out yet. I select ADO for the driver and then “VFPOLEDB.1” for the “Aux Driver”. I’ve tried pointing at the .dbc file but that didn’t work. Any place I can put the connection string I used to connect via the ADOConnection component? The product I’m connecting to started life as a FoxPro application, but they’ve added SQL Server as a database option. I’d like to use ADO so that I can connect to either backend through DA for read only ODATA Feeds (updates have to happen through a COM API so I’ll do them in RO SDK methods). Any configuration suggestions?
Have you tried the options of http://www.connectionstrings.com/visual-foxpro
I have working connection strings for ADOConnection. I’m just not sure how to get it to work in the Schema Modeler wizard. When selecting ADO in Schema Modeler I’ve never tried a driver other than SQL Server that I can recall.
Hello,
Thanks for the report, the issue was logged as #52713.
You won’t be able to Test Connection in Connection Wizard. Just click OK after defining driver, typing DB name and necessary parameters. Then as a workaround, please, change in your connection string in Schema Modeler ‘Database’ property to ‘Data Source’, i.e.
'ADO?AuxDriver=VFPOLEDB.1;Database=C:\DB\data1.dbc;‘
to
’ADO?AuxDriver=VFPOLEDB.1;Data Source=C:\DB\data1.dbc;’
Hope this helps.
Very cool. Thanks. I can connect now. 