Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with accessing VFP data
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
00846683
Message ID:
00846707
Views:
16
>I'm new to MM .Net and I'm having a problem setting up a business object to use VFP data.
>
>Basically, I setup everything as specified in the sample application but changed the SQL dataclasses to use the OLEDB equivalent.
>When I try to access data, I get the error that "Keyword not supported: 'provider'".
>Here is what my webconfig looks like:
>
>  <databases>
>    <add key="Emmis\Connection"value="provider=VFPOLEDB.1 ;data source='U\emmis.dbc';password='';user id=''" />
></databases>
>
>Any of you guys know where I may have gone wrong here?
>Thanks,

Add a space between Connection" and value="

The source='U\emmis.dbc is missing a colon.

XML also tends to be case sensitive (although I'm not sure if the connection string is), so you might also want to change "data source" to "Data Source" and "provider" to "Provider" You can drop the password/userid attributes. They're not really necessary.
-Paul

RCS Solutions, Inc.
Blog
Twitter
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform