Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP 3.0 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
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 3rd, 2004, 09:59 AM
Registered User
Join Date: Jun 2004
Location: Rexburg, Id, USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to kbuska
Default Database Query Question

I'm having issues with this Script. It works great on my machine connecting to a third party SQL hosting service but once I upload it to my Web Hosting service it no longer works. The Web Hosting service says it is something in this script. Any Ideas? I basically got this script from my WROX Beginning ASP 3.0 Book.

Ken Buska

    Option Explicit

<Title>Email Offers Query</Title>
<link href="../global.css" rel="stylesheet" type="text/css">

    dim adOpenForwardOnly, adLockReadOnly, adCmdTable, strConnect, objConn, objRS, strQuerystring

    strQuerystring = Request.QueryString("user")
    adOpenForwardOnly = 0
    adLockReadOnly = 1
    adCmdTable = 2

    strConnect = "Provider=sqloledb;" & _
                    "Data Source=<ServerName>;" & _
                    "Initial Catalog=db1559;" & _
                    "User Id=dba1559;" & _

    Set objConn = Server.CreateObject("ADODB.Connection")
    Set objRS = Server.CreateObject("ADODB.RecordSet")

    objConn.Open strConnect

    objRS.Open "Email_Offers", objConn, adOpenForwardOnly, adLockReadOnly, adCmdTable
<table "border=1"><tr><td class="survey">Email Address</td><td class="survey">Date & Time Submitted</td></tr>
    While Not objRS.EOF
        Response.Write "<TR><TD class=selectviewtext><a href=mailto:" & objRS("Email_Address") & ">" & objRS("Email_Address") & "</a></TD><TD class=selectviewtext>" & objRS("Date_Time") & "</TD></TR>"

  #2 (permalink)  
Old June 3rd, 2004, 11:16 AM
Friend of Wrox
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts


What specific error are you getting, and does it give you a line number?

  #3 (permalink)  
Old June 3rd, 2004, 12:06 PM
Registered User
Join Date: Jun 2004
Location: Rexburg, Id, USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to kbuska

 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 <SITE> 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

  #4 (permalink)  
Old June 3rd, 2004, 01:19 PM
Friend of Wrox
Join Date: Jun 2003
Location: , , Denmark.
Posts: 184
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Jonax

It could be the path to the typelib...

  #5 (permalink)  
Old September 23rd, 2004, 11:04 PM
Registered User
Join Date: Sep 2004
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts

Had same prob with Ch 15 example.
Was the Data Source code in the clssfd.asp file
Needed to contact ISP for path address.


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query Question Otacustes VB Databases Basics 6 July 15th, 2008 01:24 PM
Update Query Question arholly Access 2 January 19th, 2007 01:28 PM
query performance question kBusby Oracle 3 February 14th, 2005 04:42 PM
Sql query question. pankaj_daga SQL Language 3 November 30th, 2003 03:04 PM
Query Question tingtuang SQL Language 3 June 19th, 2003 11:07 AM

All times are GMT -4. The time now is 09:12 PM.

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