See Message #682735 for how to impersonate a valid user on your network.


>Do I have to modify .NET framework security settings on the target machine on which the database resides?
>
>The Webservice generates the folowing error:
>
>System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file '\\Server1\Share\BSLabels\bslabels.mdb'. It is already opened exclusively by another user, or you need permission to view its data. at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at System.Data.OleDb.OleDbConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) at System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at wsBSSN.BSSN.getSnRecord(String
>serialNo) in d:\develop\net\bssn\wsbssn\bssn.asmx.cs:line 230 --- End of inner exception stack trace ---
>
>>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?