Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OLEdb connect string in app.config
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
VB.NET 1.1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01001016
Message ID:
01001694
Views:
22
Glenn,

>I need to enter the following connect string in the app.config file and the xml parser is puking!
>
><add key="VAL\Connection" value="User ID=;DSN=;Cache Authentication=False;Data Source="C:\DEV\VDEV\VALTEST\VAL4\DATA\DATABASE.DBC";Provider="VFPOLEDB.1";Collating Sequence=MACHINE;Mask Password=False;persist security info=False;Mode=Share Deny None;Extended Properties=;Encrypt Password=False" />
>
You need to remove the double quotes from your Source and Provider like this:
<add key="VAL\Connection" value="User ID=;DSN=;Cache Authentication=False;Data Source=C:\DEV\VDEV\VALTEST\VAL4\DATA\DATABASE.DBC;Provider=VFPOLEDB.1;Collating Sequence=MACHINE;Mask Password=False;persist security info=False;Mode=Share Deny None;Extended Properties=;Encrypt Password=False" />
I recommend checking the MM .NET Dev Guide topic "Specifying connection strings in the config file". It has a number of different sample

Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform