Solved

Object required: ''?????

Posted on 2006-11-17
7
236 Views
Last Modified: 2008-03-10
Why do I keep getting this error:

Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/don_sched/add_event_confirm.asp, line 23

while using this code:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<%
  strConn = "dsn=don_sched;uid=don_sched;pwd=carter;"
  set Conn = Server.CreateObject("ADODB.Connection")
  Conn.Open strConn
            
  edate = request.form ("edate")
  eprojname = request.form ("eprojname")
  eprojman = request.form ("eprojman")
  eprojdraft = request.form ("eprojdraft")
  etask = request.form ("etask")
  eprojnum = request.form ("eprojnum")
  eprojclient = request.form ("eprojclient")
                        
  strSQL = "INSERT INTO master (edate, eprojname, eprojman, eprojdraft, etask, eprojnum, eprojclient) Values('" & edate & "','" & eprojname & "','" & eprojman & "','" & eprojdraft & "','" & etask & "','" & eprojnum & "','" & eprojclient & "')"            
  response.write strsql
  set rs = connGlobal.Execute (strSQL)
%>
<body>
</body>
</html>
0
Comment
Question by:phishyman2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 4

Expert Comment

by:carlmahon
ID: 17969707
set rs = connGlobal.Execute (strSQL)

should be Conn.Execute (strSQL)
0
 
LVL 54

Accepted Solution

by:
b0lsc0tt earned 125 total points
ID: 17969709
phishyman2,

I think you have a typo and that is why you get the error.  You don't have an object connGlobal when you try to run Execute.  Rename it to Conn.

set rs = Conn.Execute(strSQL)

Let me know if you have any questions or need more information.

b0lsc0tt
0
 
LVL 4

Expert Comment

by:carlmahon
ID: 17969712
Sorry

set rs = Conn.Execute(strSQL)

I left of the first part
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 54

Expert Comment

by:b0lsc0tt
ID: 17969716
@Carlmahon - I wasn't trying to correct you.  It was a late duplicate.  I think you made your point well in the first comment.

bol
0
 

Author Comment

by:phishyman2
ID: 17969780
Sweet. Thanks for the help
0
 
LVL 4

Expert Comment

by:carlmahon
ID: 17970008
b0lsc0tt, thanks for the tip but my second post was done without knowledge of your answer. If I would have seen it then I wouldn't of posted because you gave phishyman2 a good cut and paste answer.
0
 
LVL 54

Expert Comment

by:b0lsc0tt
ID: 17970017
@Carlmahon - That makes sense.  I certainly didn't mean to imply that you got anything from me.  Sorry if it seemed that way. :)

@Phishyman2 - Your welcome!  I'm glad that I could help you.  Thank you for the grade, the points and the fun question.

bol
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Multiflying 2 Input Text On a Table 7 31
edit .asp files 5 48
Code Manager | Snippits 2 62
ASP and Extracting XML 7 27
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question