viewing ASP pages--no dice still 2

crashc123 · Oct 30, 2001

I have installed IIS 5.0 on my machine. Have settings set for executables and scripts. Have named my database with a DSN ASP pages WILL NOT load. I even downloaded a lesson db file, set it up according to their instructions and put it in my

http://wwwroot

folder, can view html pages, but no scripts. What's going on? How do I get these to run? Any Suggestions? Am I missing something, I thought that it was supposed to be easy to do.

By the way I even uninstalled and reinstalled my IIS.
Thanks for your input.

Sonya

ToddWW · Oct 30, 2001

Sonya,

Try something simple. Let's just see if the server will parse ASP.

Load this onto your server and run it.

Code:

<%@ Language=VBScript %> <% Option Explicit %> <% Response.Buffer = True %> <% dim myName myName = "Hello, My name is Sonya." Response.Write myName & " " _ & "My host server is at: " _ & Request.ServerVariables("REMOTE_HOST") %>

See what happens there. If that works, maybe you're not defining the server side script language at the top of the page properly.

ToddWW

crashc123 · Oct 30, 2001

Thank you ToddWW! Yours worked - Below is the part of the code I am trying to run. Hey as I was trying to open the page I acutally got a "this page cannot be displayed" message and at the bottom I got this:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/sie/projectslist.asp, line 12

<%@ Language=VBScript %>
<Html>
<Head>
<Title>Projects List<Title>
</Head>
<Body>
<% Response.Buffer = True %>
<%
Dim oRSpl
Set oRSpl= Server.CreateObject ("ADODB.Recordset&quot

'open "tablename" and make sure the DNS is correct and on web server
oRSpl.Open "Projects", "DNS=SIEdata"
'This is telling program to go to the first row.
oRSpl.MoveFirst

How do I fix this?
Thanks again for your help.
Sonya

ToddWW · Oct 30, 2001

OK, you've got a few problems here. The first one is an honest mistake and I'm not necessarily saying that this is the entire fix.

#1: You are specifying DNS. That stands for Domain Name Server which is a solution used for translating domain names to IP addresses. You need to use the term DSN which stands for Data Source Name and is more appropriate for connecting to databases.

#2: You're using the wrong syntax to open a recordset. And that's OK too. I'm going to show you how to do that here in a second, but first I want to see if we can get this DSN working so I just want you to run this code and let me know what happens.

Code:

<%@ Language=VBScript %> <% Option Explicit %> <% Response.Buffer = True %> <% dim Conn dim strProvider strProvider = "DSN=SIEdata" set Conn = Server.CreateObject("ADODB.Connection") Conn.Open strProvider set Conn = Nothing %>

Now if that returns a blank screen with no errors, then we're in luck. If you get an error, show that back here along with a few other pieces of information.

What database are you using ?
Is the database password protected ?
What is the physical path to the database on the server ?

Note: I would only ask that you to get in the habit of starting all of your ASP pages with those three lines at the very top.

ToddWW

crashc123 · Oct 31, 2001

That worked no errors just a blank page. I thought I was specifying the Data Source Name

Okay now what do I do?

I am running an MS Access database.
There are no passwords set up on the database. (This will be another project for another day.)

The physical path to the database is C:\Inetpub\

http://wwwroot\fpdb\mydatabase.mdb

I have got ALOT to learn, but I am looking forward to it. Most of this is fun for me. And your help is SO appreciated.

ToddWW · Oct 31, 2001

OK, looks like we're making progress. Try this out.

Code:

<%@ Language=VBScript %> <% Option Explicit %> <% Response.Buffer = True %> <% Dim strProvider strProvider = "DSN=SIEdata" Dim oRSpl Dim strQuery Set oRSpl= Server.CreateObject ("ADODB.Recordset") oRSpl.CursorType = 3 strQuery = "SELECT * FROM projects" oRSpl.Open strQuery, strProvider set oRSpl.ActiveConnection = Nothing %> <Html> <Head> <Title>Projects List<Title> </Head> <Body> There are currently <%=oRSpl.RecordCount%> records in this table. <% set oRSpl = Nothing %> </Body> </Html>

If that works, come back here and I'll give you a little step by step on creating recordsets, adding, deleting, and updating that database along with a great link to a reference book for you to buy on ASP. For the purpose of completing this particular page, when you reply, let me know what the name of the DB fields of the data that you want to display on the page are.

ToddWW

crashc123 · Oct 31, 2001

Okay I tried that. I got "this page cannot be diplayed" and:

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
ADODB.Recordset (0x800A0E79)
Operation is not allowed when the object is open.
/test2.asp, line 14

Browser Type:
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)

Page:
GET /test2.asp

Time:
Wednesday, October 31, 2001, 2:57:42 PM

More information:
Microsoft Support

What does all that mean?

I have got the book "Beginning ASP Databases" from Wrox press and as you can probably tell I haven't read the whole thing--yet.

ToddWW · Oct 31, 2001

You're the 3rd person I've screwed up today because I was missing a line in the code. Try this. I forget to set the cursor location to the client with the oRSpl.CursorLocation = 3 command. Here you go.. My apologies.

<%@ Language=VBScript %>
<% Option Explicit %>
<% Response.Buffer = True %>
<%
Dim strProvider
strProvider = "DSN=SIEdata"

Dim oRSpl
Dim strQuery
Set oRSpl= Server.CreateObject ("ADODB.Recordset&quot
oRSpl.CursorType = 3
oRSpl.CursorLocation = 3
strQuery = "SELECT * FROM projects"
oRSpl.Open strQuery, strProvider
set oRSpl.ActiveConnection = Nothing
%>
<Html>
<Head>
<Title>Projects List<Title>
</Head>
<Body>
There are currently <%=oRSpl.RecordCount%> records in this table.
<%
set oRSpl = Nothing
%>
</Body>
</Html>

Should work like a charm.

Don't forget to reply back with the field names of the data you want displayed on the page so I can show you how to properly setup that recordset and display the data.

ToddWW

crashc123 · Oct 31, 2001

Woo Hoo!! I got a blank page with no error message. the fields in the table are:
ProjectID
ProjectName
ProjectDescription
ProjectBeginDate
ProjectEndDate
ProjectDeadLine
PlaneType
ClientID

ToddWW · Oct 31, 2001

Actually, you should have gotten a page that displays the following sentence..

There are currently X records in this table.

Did you not get that. If not, view the source of the blank page, is there anything there and if so, copy the source and paste it here. You do see that where I wrote that sentence in between the <body></body> tags of the page that I provided..

If you did get the sentence above, let me know. I need to know that your recordset is working error free before we go onto the next step.

ToddWW

crashc123 · Nov 1, 2001

Okay I got just a blamk whit page when I viewed by going (in IE 5.5)

http://Sonya/test2.asp

(my name is by default the name of the website). However when I viewed the source code I got the following:

<Html>
<Head>
<Title>Projects List<Title>
</Head>
<Body>
There are currently 5 records in this table.

</Body>
</Html>

(I do have 5 records in the table, also the title at the top of IE is still "

http://Sonya/test2.asp

- Microsoft Internet Explorer&quot

ToddWW · Nov 1, 2001

OK, you've got a bad closing </title> tag. See that. You have two opening tags surrounding the title. Apparently IE doesn't like that !!

Also, my advice to you would be to change all of your HTML tags to lower case. You'll be happy you did if and when you start using sytles and CSS. Especially with Netscape who treats HTML tags with case sensitivity.

OK, I'll send over an example of displaying your data using that recordset. Should be just a few minutes.

ToddWW

crashc123 · Nov 1, 2001

thanks.

DennisTheMenace · Nov 1, 2001

Nice work Todd! =====================
Dennis B

http://www.e-gunparts.com

Remember - YOU ARE UNIQUE!!!... Just like EVERYONE ELSE! ;o)

ToddWW · Nov 1, 2001

OK, here you go.. Please look at this carefully so you can try to learn and understand the conventions used to display data from a database table. Also look at the source code when the page is rendered to the browser so you can see what ASP has sent to the browser.

Code:

<%@ Language=VBScript %> <% Option Explicit %> <% Response.Buffer = True %> <% Dim strProvider strProvider = "DSN=SIEdata" Dim oRSpl Dim strQuery Set oRSpl= Server.CreateObject ("ADODB.Recordset") oRSpl.CursorType = 3 oRSpl.CursorLocation = 3 strQuery = "SELECT * FROM projects" oRSpl.Open strQuery, strProvider set oRSpl.ActiveConnection = Nothing %> <html> <head> <title>Projects List</title> </head> <body> <table border="1" cellpadding="2" cellspacing="0"> <tr> <td>ID</td> <td>Name</td> <td>Description</td> <td>BeginDate</td> <td>EndDate</td> <td>DeadLine</td> <td>PlaneType</td> <td>ClientID</td> </tr> <% oRSpl.MoveFirst WHILE NOT oRSpl.EOF %> <tr> <td><%=oRSpl("ProjectID")%></td> <td><%=oRSpl("ProjectName")%></td> <td><%=oRSpl("ProjectDescription")%></td> <td><%=oRSpl("ProjectBeginDate")%></td> <td><%=oRSpl("ProjectEndDate")%></td> <td><%=oRSpl("ProjectDeadLine")%></td> <td><%=oRSpl("ProjectPlaneType")%></td> <td><%=oRSpl("ProjectClientID")%></td> </tr> <% oRSpl.MoveNext WEND oRSpl.Close set oRSpl = Nothing %> </table> </body> </html>

ToddWW

crashc123 · Nov 1, 2001

Thank you!! I really appreciate your help. Works great.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

viewing ASP pages--no dice still 2

crashc123

Technical User

ToddWW

Programmer

crashc123

Technical User

ToddWW

Programmer

crashc123

Technical User

ToddWW

Programmer

crashc123

Technical User

ToddWW

Programmer

crashc123

Technical User

ToddWW

Programmer

crashc123

Technical User

ToddWW

Programmer

crashc123

Technical User

DennisTheMenace

IS-IT--Management

ToddWW

Programmer

crashc123

Technical User

Similar threads

Part and Inventory Search

Sponsor