Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.0 and 1.1 Basics
| Search | Today's Posts | Mark Forums Read
ASP.NET 1.0 and 1.1 Basics ASP.NET discussion for users new to coding in ASP.NET 1.0 or 1.1. NOT for the older "classic" ASP 3 or the newer ASP.NET 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 5th, 2004, 04:56 AM
Friend of Wrox
 
Join Date: May 2003
Location: Delhi, Delhi, India.
Posts: 229
Thanks: 0
Thanked 0 Times in 0 Posts
Default

http://www.microsoft.com/sql/evaluation/trial/

Charul Shukla
 
Old October 5th, 2004, 09:16 AM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

http://www.microsoft.com/downloads/d...displaylang=en



Sal
 
Old October 5th, 2004, 02:01 PM
Authorized User
 
Join Date: Jul 2003
Location: , , .
Posts: 68
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks everyone. I decided to download the trial version of sql server. Is msde normally such a pain in the rear??

 
Old October 5th, 2004, 04:33 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , .
Posts: 540
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Quote:
quote:Originally posted by mar0364
 Is msde normally such a pain in the rear??

Well, it is free...

J
 
Old October 8th, 2004, 05:11 PM
Authorized User
 
Join Date: Jul 2003
Location: , , .
Posts: 68
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Here I go again. I've loaded up the eval version of sql server with enterprise manager. I'm not getting any error its just reading the text in the <h4> tags.

My server is name "marinerhome" the database is "northwind"
here is the code:
<%@ Import namespace="System.Data" %>
<%@ Import namespace="System.Data.SqlClient" %>

<html>
<head>
    <title>Beginning ASP.NET Databases Chapter 3</title>
</head>

<body>
    <h4>First Example: Listing data from the Employees table</h4>
    <asp:DataGrid id="dgNameList"
                 runat="server"
                 Gridlines="None"
                 BackColor="LightBlue"
                 CellPadding="5"
                 CellSpacing="5"
                 BorderWidth="2"
                 BorderColor="Black"
                 ToolTip="Includes only those employees who are at HQ" />
<body>
</html>

<script language="VB" runat="server">
Sub Page_Load(Source As Object, E As EventArgs)
Dim strConnection As String = "server=(marinerhome); database=Northwind; " & _
                                "integrated security=true"
Dim objConnection As New SqlConnection(strConnection)

Dim strSQL As String = "SELECT FirstName, LastName, Country " & _
                         "FROM Employees;"
Dim objCommand As New SqlCommand(strSQL, objConnection)

objConnection.Open()

Response.Write("ServerVersion: " & objConnection.ServerVersion & _
                 vbCRLF & "Datasource: " & objConnection.DataSource & _
                 vbCRLF & "Database: " & objConnection.Database)

dgNameList.DataSource = objCommand.ExecuteReader()
dgNameList.DataBind()
objConnection.Close()
End Sub
</script>
 
Old October 11th, 2004, 01:57 AM
Friend of Wrox
 
Join Date: May 2003
Location: Delhi, Delhi, India.
Posts: 229
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

I have tested your code on my machine and just make a little change in the SQL Server name to make it compitable with my settings and it's works absolutly fine without any problem.

As you saying that it's not executing any ASP.NET code on your machine, are you sure that .NET framework is installed on your machine and IIS is configured to Support ASP.NET code execution.

Charul Shukla
 
Old October 11th, 2004, 06:28 AM
Authorized User
 
Join Date: Jul 2003
Location: , , .
Posts: 68
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks! Gee I really feel dumb asking this but here goes. How do install the dot.net framework on IIS 5.1?

Thanks!
Rich

 
Old October 11th, 2004, 07:45 AM
Friend of Wrox
 
Join Date: May 2003
Location: Delhi, Delhi, India.
Posts: 229
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Rich,

You have two options as follows:

You can download the Microsoft .NET Framework Version 1.1 Redistributable Package from the following location

http://www.microsoft.com/downloads/d...displaylang=en

and then use any editor to code ASP.NET such as Microsoft Web Matrix. Web Matrix is available for download at http://www.asp.net

Secondly you can install Microsoft Visual Studio.NET 2003 editon after installing IIS and it will automatically install all the components such as .NET Framework and rest

Charul Shukla
 
Old October 11th, 2004, 09:16 AM
Authorized User
 
Join Date: Jul 2003
Location: , , .
Posts: 68
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I've allways had IIS on the machince odd thing is I just installed VS.Net on the machine. When I go to the control panel and open up the IIS admin I have an icon that calls it self the .net wizard.

I'm going to try downloading and installing the redistribution pack.

 
Old October 11th, 2004, 10:31 AM
Authorized User
 
Join Date: Jul 2003
Location: , , .
Posts: 68
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I unstalled it and still nothing.





Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server does not exist or access denied happygv SQL Server 2000 0 April 9th, 2008 02:27 AM
SQL Server does not exist or access denied jennypretty Classic ASP Databases 3 May 18th, 2007 11:43 AM
SQL Server does not exist or access denied. jimbeam36 BOOK: ASP.NET Website Programming Problem-Design-Solution 3 November 3rd, 2004 08:51 AM
SQL Server does not exist or access denied haidee_mccaffrey Classic ASP Databases 19 June 28th, 2004 09:38 PM
SQL Server does not exist or access denied. nitinmailbox All Other Wrox Books 1 June 25th, 2003 06:35 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.