Solved

"It is already opened exclusively by another user, or you need permission to view its data."

Posted on 2003-12-11
12
1,185 Views
Last Modified: 2011-08-18
Greetings,

I have an ASP(on W2K) with runs a searching query through a remote Access 2000 database. This Access database is on a Novell Netware 5.0 server. I have installed the GSNW on my W2K server and created an account on Novell server. I used this account on GSNW to make the connection. I am able to map the database on my IIS server. I can open the database on the W2K without any problem. But when I ran my ASP, I got the following error msg"It is already opened exclusively by another user, or you need permission to view its data." I am sure the database is not open by anyone.

Also, I followed the following MS document.

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q271/2/28.ASP&NoWebContent=1

Please Help!


M.
0
Comment
Question by:mrong
  • 5
  • 3
  • 2
  • +1
12 Comments
 
LVL 11

Accepted Solution

by:
thunderchicken earned 150 total points
ID: 9922590
1. Make sure you close all your connections
2. Make sure Access isn't open
3. Make sure you have permission
0
 

Author Comment

by:mrong
ID: 9922606
What do you mean by "close all your connection"?

0
 
LVL 11

Expert Comment

by:thunderchicken
ID: 9922628
cn.close
set cn = Nothing

Anytime you access the db from access
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 11

Expert Comment

by:thunderchicken
ID: 9922630
ar,

Anytime you access the db from ASP
0
 

Author Comment

by:mrong
ID: 9922711
Here is my connection:

Set objConn = Server.CreateObject("ADODB.Connection")objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
               "Data Source=Z:\MTrackBE.mdb;Persist Security Info=False;"

Yes, I checked all 3 already.

.
0
 
LVL 6

Expert Comment

by:BubbaisBest
ID: 9924080
mrong,

I have had this happen a couple of times on me.  All I did was went to the database server itself, made a copy of the database, deleted the old database, renamed the copy of the database to the original name and then it works.  Not sure if it was that I didn't get a connection closed or something else funky but it doesn't happen very often to me.

Good luck,
Bubs
0
 
LVL 8

Assisted Solution

by:nishikanth
nishikanth earned 50 total points
ID: 9925823
pls give user permissions on ther server

or try this

right click the guest account you added and make sure that it has access to the database you are trying to use. You can provide access by checking the box next to the list of the databases.
0
 

Author Comment

by:mrong
ID: 9927879
I have it fixed. My Novell Administrator didn't set up the right password for IUSR_HOST user.

Thanks:-)

M.
0
 
LVL 11

Expert Comment

by:thunderchicken
ID: 9927893
> 3. Make sure you have permission
0
 
LVL 11

Expert Comment

by:thunderchicken
ID: 9929714
Why close this? There were already correct answers given.
0
 
LVL 6

Expert Comment

by:BubbaisBest
ID: 9929876
Thunderchicken should receive the points due to his #3 in his post and even later in the post mrong stated that this had already been checked and was correct.  
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Scheduled IIS .Net2 AppPools recycle and SQL connection Hangs 33 146
Designing forms 3 41
Set time on Session (ASP) 14 29
Ajax on ASP 2 32
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question