Hi Cetin.
I've changed to OleDB and it works fine now.
Thanks for your help.
Gerard


>>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