Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Vfp connection string not working
Message
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Versions des environnements
Environment:
C# 1.1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01041478
Message ID:
01041515
Vues:
15
Linda,

>I am going through the Jump Start C# exercises from your class. I tried the connection in the help file but it did not work. I then followed the instructions in the help file to create a connection object on the form, create a connection string and paste it into the app.config file. I tested the connection and it was successful. I then pasted it into the app.config file. The resulting code is as follows:
>
> add key="TotalControlSystem\Connection" value="User ID=;DSN=;Collating Sequence=MACHINE;Data Source=C:\DEVE\REQSNEW\TCDATA\TOTALCONTROL.DBC;Password=;Provider=VFPOLEDB.1;Cache Authentication=False;Mask Password=False;Mode=ReadWrite|Share Deny Write;Extended Properties=;Encrypt Password=False"
>
>When I try to add a binding member to a text box on my form, I get an error message "keyword not supported 'dsn'. I tried removing that and it complained about 'collating sequence'. When I removed that, it complained about provider. I think there must be something else wrong besides invalid key words.
>
>What should I try next?

Did you remember to set the DataAccessClass element in the config file? For example:
<add key="Northwind\Connection" value="Provider=vfpoledb.1;Data Source=C:\Program Files\Mere Mortals .NET Framework 2003\Samples\VFPData\northwind.dbc" />
<add key="Northwind\DataAccessClass" value="DataAccessOleDb" />
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform