I am a new user and just starting out with "ASP" I purchased the book (ASP 3.0), I am working on chapter "15" and trying to test the classified program.
Here is my problem: I get the default page fine, login and new user page is coming up fine. However, when I try to open the "Browse listing page" I am getting an "HTTP 500" error. So I changed the default connection string from e:/... to my Access DB location (c:\inetpup\wwwroot\classified\_private\classified _2000.mdb
in the ASP "clssfd.asp" file. Also I changed the location string for the "MSado15.dll" to:. Still the same problem, getting the same error: Cannot find file.
Please help, am lost.

Can you be more specific about the error code? Is it a 500 code, or a 404 (file not found)? Can you post the entire message?

Also, can you post the code of the page you're working with? I don't have the book, so I don't know what Chapter 15 is talking about....

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thank you very much for your reply,her is the error page:

.................................................. ..................
 The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

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

Please try the following:

Open the classified home page, and then look for links to the information you want.
Click the Refresh button, or try again later.

Click Search to look for information on the Internet.
You can also see a list of related sites.

HTTP 500 - Internal server error
Internet Explorer
.................................................. ...................

Here is the code for the DB connection string: Straig of the website.
For your convineance here is a link for the chapter 15 download:http://www.p2p.wrox.com/dynamic/books/download.aspx

<!-- METADATA TYPE="typelib"
              FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->
<%
  Dim objConn
  Set objConn = Server.CreateObject("ADODB.Connection")
  objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
               "Data Source=C:\Inetpub\wwwroot\artresales\fpdb\vsproduc ts.mdb

  If Session("blnValidUser") = True and Session("affilID") = "" Then
    Dim rsaffilIDCheck
    Set rsaffilIDCheck = Server.CreateObject("ADODB.Recordset")
    Dim strSQL
    strSQL = "SELECT affilID FROM Vendors " & _
             "WHERE affilID = '" & Session("affilID") & "';"
    rsaffilIDCheck.Open strSQL, objConn
    If rsaffilIDCheck.EOF Then
      Session("blnValidUser") = False
    Else
      Session("affilID") = rsaffilIDCheck("affilID")
    End If
    rsaffilIDCheck.Close
    Set rsaffilIDCheck = Nothing
  End If
   'C:\Inetpub\wwwroot\bid\_private/classified_2000.mdb" changed from the top connection
%>
.................................................. .................
Thank you very much for your help...)

It looks like you're not getting really detailed error info. To improve the quality of the error messages, turn off "Friendly Error Messages" (Hi, good afternoon, I'll be your error message for the day; how may I help you):

In Internet Explorer, open the Advanced tab of the Options dialog, and uncheck "Show friendly HTTP error messages". For your Web site in IIS, open the Properties dialog, switch to the Home Directory tab, and click the Configuration button. On the Debugging tab, make sure "Send detailed ASP error messages to the client" is checked.
Then run the page, and see if you get any error information.

Can you post the detailed error message you get here?

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Yes let me do this right now, I will email the results here in a few minutes. thanks again for helping:)

Here is the error message:
Microsoft VBScript compilation error '800a0409'

Unterminated string constant

/Clssfd.asp, line 7

"Data Source=C:\Inetpub\wwwroot\artresales\fpdb\vsproduc ts.mdb
--------------------------------------------------------------^

Here is the line 7 error in the file "Clssfd"
 Dim objConn
  Set objConn = Server.CreateObject("ADODB.Connection")
  objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
               "Data Source=C:\Inetpub\wwwroot\artresales\fpdb\vsproduc ts.mdb
.................................................. ...................

Right, forget the message I just sent you. Should have spotted this right away:

objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
               "Data Source=C:\Inetpub\wwwroot\artresales\fpdb\vsproduc ts.mdb

As you can seem the string with the database name is not closed properly. Change it to this:

objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
               "Data Source=C:\Inetpub\wwwroot\artresales\fpdb\vsproduc ts.mdb"


Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Oh my god,
I found the problem here, I forgot to put the (") ending Quotation marks. I am so stupid, sorry to bother everybody...:)