Database access error 
Author Message
 Database access error

Rodger,

"Runon=server" should be "Runat=server"

Other than that, it runs on my machine just fine.

Marvin Thompson

Quote:

> I've been bothered by this error for days.  I'm new to ASP's and fairly
> new to VBScript.  On both IIS at work & PWS at home I get this error:

> "object required:Server"

> Here is the code for the dbse script.     If anyone can help I would be
> real please.

> I also get similar error when I try to write back data like:
> Resopnse.Write "...."    'this gives an error "oject required: Response"

> I'm wondering if I've installed the servers properly.
> Thank
> Rodger


> <html>
> <head>
> <title>Test Oracle Connection</title>
> </head>
> <body>
> <Script Language="VBScript" Runon="Server">
> Set objConn=Server.CreateObject("ADODB.Connection")      ' error here

> objConn.Open "dsn=LISDSN;uid=genadmin;pwd=*******;"
> Set objRS=objConn.Execute("SELECT formatted_name FROM  g_party")

> Response.Write "<Table border=1 cellpadding=4>"
> Response.Write "<tr>"

> For i=0 To objRS.Fields.Count - 1
>       Response.Write "<td><b>"  & objRS(i).Name & "</b></td>"
> Next

> Response.Write "</tr>"

> objRS.MoveFirst

> Do While Not objRS.EOF
>       Response.Write "<tr>"

>       For j=0 To objRS.Fields.Count - 1
>              Response.Write "<td>"  & objRS(j) & "</td>"
>       Next

>        Response.Write "</tr>"

>        objRS.MoveNext
> Loop

> Response.Write "</Table>"

> objRS.Close
> objConn.Close
> </script>
> </body>
> </html>



Sun, 24 Mar 2002 03:00:00 GMT  
 Database access error

<Script Language="VBScript" RUNAT="Server">

--
Michael Harris

  I've been bothered by this error for days.  I'm new to ASP's and fairly
  new to VBScript.  On both IIS at work & PWS at home I get this error:

  "object required:Server"

  Here is the code for the dbse script.     If anyone can help I would be
  real please.

  I also get similar error when I try to write back data like:
  Resopnse.Write "...."    'this gives an error "oject required: Response"

  I'm wondering if I've installed the servers properly.
  Thank
  Rodger


  <html>
  <head>
  <title>Test Oracle Connection</title>
  </head>
  <body>
  <Script Language="VBScript" Runon="Server">
  Set objConn=Server.CreateObject("ADODB.Connection")      ' error here

  objConn.Open "dsn=LISDSN;uid=genadmin;pwd=*******;"
  Set objRS=objConn.Execute("SELECT formatted_name FROM  g_party")

  Response.Write "<Table border=1 cellpadding=4>"
  Response.Write "<tr>"

  For i=0 To objRS.Fields.Count - 1
        Response.Write "<td><b>"  & objRS(i).Name & "</b></td>"
  Next

  Response.Write "</tr>"

  objRS.MoveFirst

  Do While Not objRS.EOF
        Response.Write "<tr>"

        For j=0 To objRS.Fields.Count - 1
               Response.Write "<td>"  & objRS(j) & "</td>"
        Next

         Response.Write "</tr>"

         objRS.MoveNext
  Loop

  Response.Write "</Table>"

  objRS.Close
  objConn.Close
  </script>
  </body>
  </html>



Sun, 24 Mar 2002 03:00:00 GMT  
 Database access error
I've been bothered by this error for days.  I'm new to ASP's and fairly
new to VBScript.  On both IIS at work & PWS at home I get this error:

"object required:Server"

Here is the code for the dbse script.     If anyone can help I would be
real please.

I also get similar error when I try to write back data like:
Resopnse.Write "...."    'this gives an error "oject required: Response"

I'm wondering if I've installed the servers properly.
Thank
Rodger


<html>
<head>
<title>Test Oracle Connection</title>
</head>
<body>
<Script Language="VBScript" Runon="Server">
Set objConn=Server.CreateObject("ADODB.Connection")      ' error here

objConn.Open "dsn=LISDSN;uid=genadmin;pwd=*******;"
Set objRS=objConn.Execute("SELECT formatted_name FROM  g_party")

Response.Write "<Table border=1 cellpadding=4>"
Response.Write "<tr>"

For i=0 To objRS.Fields.Count - 1
      Response.Write "<td><b>"  & objRS(i).Name & "</b></td>"
Next

Response.Write "</tr>"

objRS.MoveFirst

Do While Not objRS.EOF
      Response.Write "<tr>"

      For j=0 To objRS.Fields.Count - 1
             Response.Write "<td>"  & objRS(j) & "</td>"
      Next

       Response.Write "</tr>"

       objRS.MoveNext
Loop

Response.Write "</Table>"

objRS.Close
objConn.Close
</script>
</body>
</html>



Mon, 25 Mar 2002 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Database accessing error '3343'

2. Database access error

3. Database access error in VB6 but not VB4-32, why?

4. Crystal 1.0 database error when connecting to Access 1.1 database

5. error doing a FILTER on an Access database via Asp/VBScript and ADO

6. Weird ASP error when trying to add a new record to a MS Access database

7. error doing a FILTER on an Access database via Asp/VBScript and ADO

8. Access Database Error (ASP)

9. VBScript Error due to converting databases from Access to SQL Server 6.5

10. Error Message when querying Access database

11. asp to access database error...

12. Access 2000 Database Error - error opening file

 

 
Powered by phpBB® Forum Software