Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection to Access DB on network drive fails...
Message
 
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00693316
Message ID:
00693321
Views:
22
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform