Link to home
Start Free TrialLog in
Avatar of davidlars99
davidlars99Flag for United States of America

asked on

Microsoft English Query (0x80020009) Access is denied.

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
Avatar of fritz_the_blank
fritz_the_blank
Flag of United States of America image

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
Avatar of davidlars99

ASKER

you mean windows acount as  IUSR... yes I'm logged in as admin

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


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
SOLUTION
Avatar of alorentz
alorentz
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
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
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... :)
Are you running windows xp or something else?

FtB
Windows XP SP2, IIS 5.0
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Please post here later to let us know how it turns out!

FtB