>Hi.
>I have a web.config file with:
>
>connectionString="Provider=vfpoledb.1;Data Source=C:\Webportal\App_Data\WP.dbc;Collating Sequence=MACHINE;"
>
>
>string Cs = settings.ConnectionString;
>string CommandString = "SELECT * FROM .....";
>SqlDataAdapter da = new SqlDataAdapter(CommandString, Cs);
>
>On the SqlDataAdapter line , I am getting a run time error saying:
> keyword not supported 'provider'
>
>It looks like there's something wrong with the connection string
>
>Anybody got any ideas ?
>
>Regards,
>Gerard

Gerard,
You're using SqlDataAdapter. That's specific to SQL server and provider is implicitly set. Use OleDbDataAdapter and you'd be fine.
Cetin