Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Microsoft English Query (0x80020009) Access is denied.

Posted on 2004-09-27
13
Medium Priority
?
680 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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 200 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
 
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 1800 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

730 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