I am getting the following error when i call my website

Code:

ERROR: 400.100 Bad Request
HResult: 0x80004005
Source: Microsoft SQL isapi extension
Description: Query not specified

I am calling the example from the book i.e. http://localhost/WroxUnited.
Anyone got any suggestions as IIS is running and all components are installed.


Regards

Stone

Stoney

what is the code that is calling the query?

Sorry but i am unsure what you mean by that? I am calling an .aspx file through my browser and then I get this error. If this isn't of any help let me know how I can be more specific.

I want to use the ISS instead of Cassini.So upon following the instructions in the book I have created an alias (WroxUnited) and set the correct path to my site i.e. http://Websites/Wroxunited.So now when I go into my browswer I type "http://localhost/WroxUnited" and I get the error.

I am pretty new to IIS but it is installed with all the correct components (I installed everything to be safe). Is there something I need to do to start the server (I am pretty sure it's running? Or am I typing the wrong path into the address bar of the browswer?

I appreciate this help.

Regards

Stoney


Stoney

The error to me seems to be a database error. Are you accessing a DB anwhere in your code?

No it's only a static page with no database access.

Stoney

I have exactly the same problem. Stoney did you manage to find a solution?

I just managed to get it working, I tried creating the Virtual directories using IIS Manager instead of IIS Virtual Directory Mangement for SQLXML and it worked straight away.

Hia,

I have tried doing this using "Administrative tools - IIS and then adding the virtual directory".But i keep getting the following error:

Directory Listing Denied
This Virtual Directory does not allow contents to be listed.

Could you let me know exactly how you set yours up step by step as I'm tearing my hair out at this stage!

Much appreciated.

Stone

Stoney

You get this error because a) you don't have a Default Document set up that matches with a document you have in the folder and b) you disabled directory browsing.

To fix problem a, create a page like Default.aspx. This document will be served whenever the folder (and not a direct page) is requested. To see what default documents your server has, open up the IIS Manager, locate your site and open its Properties dialog. Then click the Documents tab. You see a list with files that will be seen as Default documents. So, when you see Default.html, and you have a file with that name, that file will be served whenever you access something like http://localhost/ or http://localhost/SomeFolder

To fix problem b (not recommended on a production server as it may expose too much information about your files), once again open the IIS Manager, and open the Properties dialog for your site. Then on the Home Directory tab, make sure that Directory browsing is enabled.

Hope this helps,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

Hia,

Many thanks for the advice. I have used your suggestion and have made some progress.

When I call the website from the browser e.g. "http://localhost/SomeFolder", I get a listing of all the directories within that website. I do have a page called "default.aspx" so I am unsure of how to get it to just display the "default.aspx" rather than the listing of directories within the site.

Many thanks again.

Stoney

Stoney