Hello Theo,
Strange that you're getting 'provider' in the error text when clearly you have 'Provider' in your app.config... don't know why it would change to lower case.
Is it possible you're picking up another, incorrectly formatted connection string key from your app.config? Or maybe you have some commented lines in that section of your app.config? I remember getting some strange error messages when we were doing that "in the beginning."
If not, have you tried copying and pasting that connection string elsewhere... say directly into a VFP SQLCONNECT command?
Either way, something doesn't like the format of what you're trying to send through your data access layer -- try stepping through FillDataSet and check the various portions of the SelectCommand object to make sure they look correct. You might even try changing your select command SQL statement to something that doesn't require string concatenation (SELECT * FROM arcust01 WHERE custno = 1)
Hope some of that helps,
---J
>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'.
>
>Thank you,
>Theo