473,325 Members | 2,860 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Read Access database on Novell Netware 6 from ASPX

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
Nov 19 '05 #1
4 2077
Miro wrote:
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


Are you sure that the asp-account knows about the "N:" drivemapping?
Usually these are user-specific. When *you* try it, it works, as *you*
have that drive mapping. I don't know how Novell works with
drivemappings though.
For a plain windows network you could use \\server\share instead of N:,
try that (if possible).

--
Hans Kesting
Nov 19 '05 #2
Hello Hans!

Thanks for your advice. I've tried to map the Novell folder by using UNC
(\\server\folder) but it made no difference. I logged in in windows as IUSR
when I mapped Novell so I guess the IUSR should know about N:

/Miro

"Hans Kesting" wrote:
Miro wrote:
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


Are you sure that the asp-account knows about the "N:" drivemapping?
Usually these are user-specific. When *you* try it, it works, as *you*
have that drive mapping. I don't know how Novell works with
drivemappings though.
For a plain windows network you could use \\server\share instead of N:,
try that (if possible).

--
Hans Kesting

Nov 19 '05 #3
re:
I've created an account on Novell (IUSR_Machinename)
which is the same account that the aspx is using.
Excuse me if this sounds like a silly question but,
are you sure that's the account ASP.NET is using ?

The two accounts which ASP.NET uses by default are
Machinename\ASPNET and Machinename\Network Service.

Did you *change* the ASP.NET account to the
IUSR_Machinename account, and now it doesn't work ?

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Miro" <Mi**@discussions.microsoft.com> wrote in message
news:57**********************************@microsof t.com... 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

Nov 19 '05 #4
Hello Juan!

Yes, I'm pretty sure it's IUSR. I've tested on another folder and it worked
only when I granted IUSR full rights. I even tried to specify the user in
web.config:

<identity impersonate="true" userName="domain/IUSR_machinename"
password="****"/>

The anonymous access unchecked in ISS. The password is the same as in Novell.

I tried to add IUSR to Administrator and even changed IUSR_machinename (in
web.config) to the administrator account, with the same negative result.

/Miro

"Juan T. Llibre" wrote:
re:
I've created an account on Novell (IUSR_Machinename)
which is the same account that the aspx is using.


Excuse me if this sounds like a silly question but,
are you sure that's the account ASP.NET is using ?

The two accounts which ASP.NET uses by default are
Machinename\ASPNET and Machinename\Network Service.

Did you *change* the ASP.NET account to the
IUSR_Machinename account, and now it doesn't work ?

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Miro" <Mi**@discussions.microsoft.com> wrote in message
news:57**********************************@microsof t.com...
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


Nov 19 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Migrators | last post by:
Respected sir, Will Oracle 8i run on Novell Netware 5.0 ? If not which version of Oracle run Novell Netware 5.0. Kindly do clarify our doubt. With Regards, Jayachandar.B
0
by: Leroy Mason | last post by:
During setup, my application takes several network paths from the user. I want to prevent Novell Netware any version being used. Therefore I need to take the path and test that the server is not...
2
by: Luke Kandia | last post by:
This is an interesting problem. We recently had the privelege of upgrading a Netware 5.0 network server. It used to be on old HP equipment. Now it sits on new Dell equipment. There was a...
7
by: Jamma | last post by:
Hello, I have an Access 2000 file working on XP machines and a NT network. The files are split and 95% of the time all is well and stable. The main issue arises when the app prints,a novell...
6
by: andRea | last post by:
Hi all! Anybody knows how is possible detect the Novell login in Access? Thank you all andRea
0
by: Grey | last post by:
I have a ASP.NET web application which is required to copy file from windows server to Novell Netware server. I have used impersonation to connect to Netware server. The application works fine when...
4
by: Rvo | last post by:
Hi all, I need to use the Netware "send" function to send messages to some/all attached netware users on a server. However, I can't find any documentation on this topic on the Novell site or...
2
by: stephshomeemail | last post by:
>From my .net web page, I would like to retrieve the novell username. (This is for an intranet application.) Can anyone help? I have searched the web. These don't work, they get the windows...
4
by: kaisersose1995 | last post by:
Hi, I'm trying to get Novell Netware information using vba into my access database and have no idea how to progress. Basically when i right click the properties on my computer the free space of a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.