Connection String Debug

Question

I guess my question is how do you debug a connection string?

Background Info

• Dev Machine is 64bit but I have my build targeting 32bit
• Windows Form App targeting .NET 2.0
• Has an embedded access database to hold look up values and store some basic information

• In App.config

  add name="MyConnection" connectionString="Provider = Microsoft.Jet.OLEDB.4.0; Data Source =C:\Development\MyFolder\MyAccessData.mdb;"

As soon as I hit F5 it sets a breakpoint on this line:

connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MyConnection"].ToString();

Answer 1

try this..

connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString;