>In my DataAccess class I have a private method called GetConnectionString to generate the connection string based on property values. I'm trying to use it to connect to an Access database. In this method is a switch which is evaluated based on the InvariantName. For the OleDb option I have:
>
>

>
>DbConnectionStringBuilder csb = _Factory.CreateConnectionStringBuilder();
>
>.
>.
>.
>
>case "System.Data.OleDb":
>    if (_Provider != "")
>    {
>        csb.Add("Provider", _Provider);
>    }
>    if (_DataSource != "")
>    {
>        csb.Add("Data Source", _DataSource);
>    }
>    if (_InitialCatalog != "")
>    {
>        csb.Add("Initial Catalog", _InitialCatalog);
>    }
>    if (_TrustedConnection)
>    {
>        csb.Add("Integrated Security", "SSPI");
>    }
>    else
>    {
>        if (_UserName != "")
>        {
>            csb.Add("User Id", _UserName);
>        }
>
>        if (_Password != "")
>        {
>            csb.Add("pwd", _Password);
>        }
>    }
>
>    break;
>
>

>
>Then outside the switch I have:
>
>

>return csb.ConnectionString;
>

>
>When I step to this line and hover over 'csb', I see
>

Provider=Microsoft.Jet.OLEDB.4.0;Data Source="M:\APEX Master Database.mdb";Integrated Security=SSPI

>
>When I hover over 'ConnectionString' I see:
>

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"M:\\APEX Master Database.mdb\";Integrated Security=SSPI

>
>Notice the extra slashes before and after the database name.

You may want to include an @ sign in front of your string values in the properties where you have that assigned. In other words like this.

///
/// DataSource Property
///
public string DataSource
{
     get { return _dataSource; }
}
private string _dataSource = @"M:\APEX Master Database.mdb...";

Like Viv said about the escape characters, the @ sign will negate that.
Tim