Theo,
>Can anyone assist with getting MM C# to connect to VFP.
>My connection string is
>
>add key="MCFP01SQL_MASTER\Connection" value="Provider=vfpoledb.1;Data Source=\\MCFTS001\c$\SBB\mcf\data01\mcf.dbc" /
>add key="MCFP01SQL_MASTER\DataAccessClass" value="DataAccessOleDb" /
>
>The error I get is:
>Keyword not supported: 'provider'.
>Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
>
>Exception Details: System.ArgumentException: Keyword not supported: 'provider'.
This message is commonly encountered when trying to use a VFP connection string with a SQL Server data access class. A few things to check:
1. Make sure your business object's DatabaseKey property is set to MCFP01SQL_MASTER.
2. If you have an override for your business object's CreateDataAccessClass(), make sure the logic in this override is instantiating the correct data access class.
If you still can't figure it out, please post your stack trace here so we can have more information to figure out what's going on.
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com