If the database is on a local path, the web service can connect to it. However, if the database exists on a network drive (Mapped or un-mapped) the web service cannot connect to the database.


The following code initializes the ConnectionString:

xOleDbConn.ConnectionString = @DSN();

// Get DSN string specified in AppSettings section of Web.config file
private string DSN()
{
// return the connection string
return System.Configuration.ConfigurationSettings.AppSettings["DSN"];
}

The Web.config file has the following key under the configuration key:





If I change the Data Source for my DSN entry in the Web.config file to to: "\\Server1\bslabels\DB\bslabels.mdb;" or use a mapped path
as: "P:\bslabels.mdb",

the data connection fails.

Is it possible to connect to an MS Access database on a network path/drive or is M$ forcing us to use MSDE/SQL Server?