Hi all,
I have just bought the spaanjaars asp.net instant results book. I have installed the survey engine(ch4) locally on my pc. I have set the program to ASP.NET to ver2 in IIS. The book says it should be easy to get going but I am getting the error below. The virtual directory is ok and the files are there. Any ideas please? Thanks.
Paul


Server Error in '/Surveys' Application.
-------------------------------------------------------------------
The resource cannot be found.
Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested URL: /Surveys/Login.aspx
--------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

Hi there,

How did you set up IIS? How exactly do you browse to the site? E.g. what address do you type in the browser? Maybe you shouldn't append /Surveys to the URL?

And is the error message correct? When you look at the root of the site, do you see the page on disk?

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

I have IIS already setup. I use it for developing most of my db projects which I mostly do with dreamweaver mx using sql server or MS access. IIS works fine like this and has done so for a very long time. I'm using IIS 5.1 on XP pro and not IIS6 on server2003. Could this be the problem?

I can browse to the site by using http://localhost and http://127.0.0.1. I have my documents directory set as the root and file browsing enabled. I then just click thought to the folder and file I want. I get the error message whether I'm browsing to the file or append it to the url.

The error is not correct as the files are there on disk.

Thanks

Paul


[quote]Originally posted by Imar
 Hi there,

How did you set up IIS? How exactly do you browse to the site? E.g. what address do you type in the browser? Maybe you shouldn't append /Surveys to the URL?

And is the error message correct? When you look at the root of the site, do you see the page on disk?

Hi Paul,

If you browse to the site as http://localhost then you shouldn't be requesting http://localhost/Surveys/Login.aspx but http://localhost/Login.aspx I am not sure if the error is due to a problem in the site or due to your setup.

Somehow there seems to be a mismatch between the setup of IIS and the way you open / browse to the site or request pages.

Normally, you'd do something like this:

1. Create a folder like C:\WebSites\Surveys

2. In this folder, place the file from the zip archive so you end up with files like C:\WebSites\Surveys\Login.aspx

3. Set up IIS and have the root of the site point to C:\WebSites\Surveys

4. With this setup, pages like http://localhost/Login.aspx should exist.

If that doesn't help, I need more about information about physical paths, setup, settings etc to be able to help you.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Imar,
Thanks for your help. I have set the survey engine to the root of my localhost. It seems to have partially worked. I now get what looks like an admin login. However when I login using SuperAdmin and password# I get the error below. Why should I need to set this folder as the root. I can't now run my other ASP website projects. I wanted to integrate the survey engine into my schools intranet for staff to setup their own surveys. But if it won't work as a virtual directory of sub directory then I see little use for it.

Regards

Paul



Server Error in '/' Application.
---------------------------------------------------------------------

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
   System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +735059
   System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820
   System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
   System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
   System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130
   System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
   System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject) +424
   System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject) +496
   System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection) +82
   System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.SqlClient.SqlConnection.Open() +111
   System.Web.DataAccess.SqlConnectionHolder.Open(Htt pContext context, Boolean revertImpersonate) +84
   System.Web.DataAccess.SqlConnectionHelper.GetConne ction(String connectionString, Boolean revertImpersonation) +197
   System.Web.Security.SqlMembershipProvider.GetPassw ordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121
   System.Web.Security.SqlMembershipProvider.CheckPas sword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
   System.Web.Security.SqlMembershipProvider.CheckPas sword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
   System.Web.Security.SqlMembershipProvider.Validate User(String username, String password) +83
   System.Web.UI.WebControls.Login.OnAuthenticate(Aut henticateEventArgs e) +160
   System.Web.UI.WebControls.Login.AttemptLogin() +105
   System.Web.UI.WebControls.Login.OnBubbleEvent(Obje ct source, EventArgs e) +99
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
   System.Web.UI.WebControls.Button.OnCommand(Command EventArgs e) +115
   System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +163
   System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

 ---------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210







[quote]Originally posted by Imar
 Hi Paul,

If you browse to the site as http://localhost then you shouldn't be requesting http://localhost/Surveys/Login.aspx but http://localhost/Login.aspx I am not sure if the error is due to a problem in the site or due to your setup.

Somehow there seems to be a mismatch between the setup of IIS and the way you open / browse to the site or request pages.

Normally, you'd do something like this:

1. Create a folder like C:\WebSites\Surveys

2. In this folder, place the file from the zip archive so you end up with files like C:\WebSites\Surveys\Login.aspx

3. Set up IIS and have the root of the site point to C:\WebSites\Surveys

4. With this setup, pages like http://localhost/Login.aspx should exist.

If that doesn't help, I need more about information about physical paths, setup, settings etc to be able to help you.

Cheers,

Imar

Hi Paul,

It looks like you're trying to connect to a database server that is on a different machine than the webserver?

Take a look at this article: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395 especially the Other Issues at the end of the article.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.