Hello,
I'm using SQL 2000, Personal Ed.
IIS 5.0
Win 2k

I copied the code from chapter 3,page 67, example using a data grid. I set up a virtual Directory in IIS. I then tried to open the page in IE: http://localhost/begaspnetdb/ch03/SQ...onnection.aspx

However, the ASP does not compile. I can see "First Example: Listing data from the Employees table " at the top of the page, but the data grid does not show. When I click on view source, I can still see the VB Script, it hasn't been compiled.

Then, I tried Webmatrix, and it worked. Viewing the Source showed a compiled page, no VB Script was visible.

Any suggestions on what I need to do to get IIS working.

thanks,
rwiethorn

Can you view any aspx page with IIS or do they all show the VB code?

Stu,
Yeah I can get it to display simple pages, bu when I try to connect to SQL Serve it gives me an error.

The Error I get is: Login failed for user 'IS009-2\ASPNET'.

IS009-2 is my machine name. I added the ASPNET account to my SQL serve database as a system admin, I also am using mixed mode security.

Below is the error page,
thanks rwiethorn

************************************************** *********************************
Login failed for user 'IS009-2\ASPNET'.
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: Login failed for user 'IS009-2\ASPNET'.

Source Error:


Line 13: Dim objCommand As New SqlCommand(strSQL, objConnection)
Line 14:
Line 15: objConnection.Open()
Line 16:
Line 17: Response.Write("ServerVersion: " & objConnection.ServerVersion & _


Source File: c:\inetpub\wwwroot\BegASPNet\Webroot\CH03\WebForm1 .aspx Line: 15

Stack Trace:


[SqlException: Login failed for user 'IS009-2\ASPNET'.]
   System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction)
   System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction)
   System.Data.SqlClient.SqlConnection.Open()
   ASP.WebForm1_aspx.Page_Load(Object Source, EventArgs E) in c:\inetpub\wwwroot\BegASPNet\Webroot\CH03\WebForm1 .aspx:15
   System.Web.UI.Control.OnLoad(EventArgs e)
   System.Web.UI.Control.LoadRecursive()
   System.Web.UI.Page.ProcessRequestMain()




rwiethorn

What does your connection string look like?

Check this out and hopefully it will help.

http://www.able-consulting.com/dotne...anagedProvider

Hi, I'm new in this, well, let me tell you that I used to have the same problem as yours, and I tried whatever was possible, trying to fix the problem, the last thing that I did was to reinstalled the IE and (amazed) it worked. Maybe you can try this.