Object required: ''?????

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>
phishyman2Asked:
Who is Participating?
 
b0lsc0ttConnect With a Mentor IT ManagerCommented:
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
 
carlmahonCommented:
set rs = connGlobal.Execute (strSQL)

should be Conn.Execute (strSQL)
0
 
carlmahonCommented:
Sorry

set rs = Conn.Execute(strSQL)

I left of the first part
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
b0lsc0ttIT ManagerCommented:
@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
 
phishyman2Author Commented:
Sweet. Thanks for the help
0
 
carlmahonCommented:
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
 
b0lsc0ttIT ManagerCommented:
@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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.