Discuss "Object Required?!?!?" in the ASP Development forum.

jarvelous · #1 March 20th, 2008, 12:41 PM

BLaaaarche gave me some code iin another post. The code is this:

strSQL = "Select memberid, membername from members"
Set objRS = siteConn.Execute(strSQL)

I am getting an error.

ASP Error occurred 3/20/2008 9:38:17 AM in Microsoft VBScript runtime
Error number: -2146827864 (0x800A01A8)
File: /test/Default.asp, line 3
Object required: 'siteConn'

Can anyone please explain to me what this is? I am new to ASP, please bare with me!!!!!!

jmurrayhead · #2 March 20th, 2008, 12:43 PM

You have to define what siteConn is:

Code:

Set siteConn = Server.CreateObject("ADODB.Connection")
strSQL = "Select memberid, membername from members"
Set objRS = siteConn.Execute(strSQL)

jarvelous · #3 March 20th, 2008, 12:46 PM

got it thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Discuss "Object Required?!?!?" in the ASP Development forum.

ASP Development - Learn coding practices and tips to get the best out of your Active Server Pages (ASP). The Classic ASP forum is for ASP/VBScript and ASP/JScript applications.