davidlars99
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("c ontent_len gth")>0 then
set eqs=server.createobject("m seq.sessio n")
eqs.initdomain("C:\Documen ts and Settings\David & Mzia\My Documents\Visual Studio Projects\Northwind\Northwi nd.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
<%
if request.servervariables("c
set eqs=server.createobject("m
eqs.initdomain("C:\Documen
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
ASKER
you mean windows acount as IUSR... yes I'm logged in as admin
this should work perfectly > set eqs=server.createobject("m seq.sessio n")
this should work perfectly > set eqs=server.createobject("m
ASKER
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\No rthwind\No rthwind.eq d")
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
Set objEQSession = Server.CreateObject("Mseq.
objEQSession.InitDomain("c
Set objEQResponse = objEQSession.ParseRequest(
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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
I haven't seen this done before, so I am not sure if it will work or not.
FtB
ASKER
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
FtB
ASKER
Windows XP SP2, IIS 5.0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
If you still interested in my problem I created anoher topic
https://www.experts-exchange.com/questions/21149790/English-Query-Problem-is-Driving-me-Nuts.html
https://www.experts-exchange.com/questions/21149790/English-Query-Problem-is-Driving-me-Nuts.html
Please post here later to let us know how it turns out!
FtB
FtB
As an aside, I have never seen this done:
set eqs=server.createobject("m
Are you sure this works?
FtB