Solved

Microsoft English Query (0x80020009) Access is denied.

Posted on 2004-09-27
13
670 Views
Last Modified: 2011-09-20
when I'm trying to init a .eqd file which is compiled  english query project file I get an error on line #3 (eqs.initdomain(....))

<%
   if request.servervariables("content_length")>0 then
      set eqs=server.createobject("mseq.session")
      eqs.initdomain("C:\Documents and Settings\David & Mzia\My Documents\Visual Studio Projects\Northwind\Northwind.eqd")
   end if
%>  

Error Type:
Microsoft English Query (0x80020009)
Access is denied.
/eq/example1.asp, line 3


has anybody ever had such a problem..?

thanks
 dave
0
Comment
Question by:davidlars99
  • 7
  • 5
13 Comments
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 12165618
Are you sure that the IUSR  account has READ/WRITE to the Northwind directory?

As an aside, I have never seen this done:

set eqs=server.createobject("mseq.session")

Are you sure this works?

FtB
0
 
LVL 13

Author Comment

by:davidlars99
ID: 12165771
you mean windows acount as  IUSR... yes I'm logged in as admin

this should work perfectly > set eqs=server.createobject("mseq.session")


0
 
LVL 13

Author Comment

by:davidlars99
ID: 12165827
0
 
LVL 13

Author Comment

by:davidlars99
ID: 12166692
everything works fine in Visual Studio Project, but I can't get it to work in asp

Set objEQSession = Server.CreateObject("Mseq.Session")
objEQSession.InitDomain("c:\inetpub\wwwroot\Northwind\Northwind.eqd")
Set objEQResponse = objEQSession.ParseRequest("list customers")

Select Case objEQResponse.Type
Case nlCommandResponse
   Set objCommands = objEQResponse.Commands
   For intCommand = 0 To objCommands.Count - 1
      Set objCommand = objCommands(intCommand)
      Select Case objCommand.CmdID
      Case nlQueryCmd
         DoSQLCommand objCommand
      Case nlAnswerCmd
         Response.Write objCommand.Answer
      end select
   Next
Case nlUserClarifyResponse
   DoClarification objEQResponse, "list customers"
Case nlErrorResponse
   Response.Write objEQResponse.Description & "<BR>"
   Response.End
End Select
0
 
LVL 31

Assisted Solution

by:alorentz
alorentz earned 50 total points
ID: 12168416
>>you mean windows acount as  IUSR... yes I'm logged in as admin

Logged in as Admin has nothing to do with it.  You need to assign rights for IUSR_YourComputerName in IIS, or on the specific file being used.
0
 
LVL 13

Author Comment

by:davidlars99
ID: 12169268
ahh... only when I used windows authentication to loggin with ASP I get an error message that SERVER\IUSR_SERVERNAME has failed...  I don't know how to assign rights

how about English Query has anybody ever implemented it thru ASP?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 12169650
That is what I was talking about with the IUSR permissions--you must give them to the directory that houses your database.

I haven't seen this done before, so I am not sure if it will work or not.

FtB
0
 
LVL 13

Author Comment

by:davidlars99
ID: 12182213
fritz_the_blank, I will accept your comment as a solution if you show me how to set SERVER\IUSR_SERVERNAME, but my problem will remain the same, I think I need to install the whole ActiveX component for that feature which comes with Microsoft Library, I'm not sure though... :)
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 12182898
Are you running windows xp or something else?

FtB
0
 
LVL 13

Author Comment

by:davidlars99
ID: 12182918
Windows XP SP2, IIS 5.0
0
 
LVL 46

Accepted Solution

by:
fritz_the_blank earned 450 total points
ID: 12182928
If XP, the you will have to do the following:

WinXP Pro File Sharing Disable Simple File Sharing
Disabling Simple File Sharing is necessary in order to enable the creation of Access Control Lists for shared disks and folders:

Click Start | My Computer | Tools | Folder Options | View.
Scroll to the bottom of the list of advanced settings and un-check Use Simple File Sharing (Recommended).
Click OK.


Now you can right click on the "C:\Documents and Settings\David & Mzia\My Documents\Visual Studio Projects\Northwind\" directory and and give the IUSR_ account read and write permissions.

FtB
0
 
LVL 13

Author Comment

by:davidlars99
ID: 12183093
If you still interested in my problem I created anoher topic
http://www.experts-exchange.com/Web/Q_21149790.html
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 12183109
Please post here later to let us know how it turns out!

FtB
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
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…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now