General information
Category:
Coding, syntax and commands
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only