Hello!
I have an ASP.NET application which needs to read some data from an Access
database on Novell. I've found an article on Microsoft and did the following:
I've created an account on Novell (IUSR_Machinename) which is the same
account that the aspx is using. This account has full rights to the database
and the folder (on Novell). I've mapped the folder in explorer but when I try
to access the database from ASP.NET I get these errors:
DataSet ds = new DataSet();
Connection.ConnectionsString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\\ip-adres\filepath;Persist Security Info=False";
DataAdapter.Fill(DS)
Error: The Microsoft Jet database engine cannot open the file "..." It is
already opened exclusively by another user, or you need permission to view
its data.
when I try this:
DataSet ds = new DataSet();
Connection.ConnectionsString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=N:\filepath;Persist Security Info=False";
DataAdapter.Fill(DS)
I get Error: 'N:\filepath' is not a valid path. Make sure that the path
name is spelled correctly and that you are connected to the server on which
the file resides.
I get the connectionstring from an UDL-file which works with both
approaches. Why can't ASP read the database?
Thanks
Miro