VBscript variable is undefined error

Question

Here is my vbscript - not got too far with this. The 2 lines I've lifted from Microsoft documentation don't work. The file is saved as a vbs file. I'm doubleclicking to run. Windows XP is the OS.

option explicit

Dim Rs1
Set Rs1 = Server.CreateObject( "ADODB.Recordset" )

I get a runtime error saying error: variable is undefined: 'Server'. Bit puzzled by this as the code is sooooo basic.

Any ideas anyone? thanks...

Alex K. · Accepted Answer · 2014-01-27 16:49:25Z

7

Server.CreateObject is for ASP Pages, for "desktop" VBScript use:

option explicit

Dim Rs1
Set Rs1 = CreateObject( "ADODB.Recordset" )

answered Jan 27, 2014 at 16:49

Alex K.

177k32 gold badges275 silver badges298 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MeSo2 Over a year ago

Server.CreateObject("ADODB.Recordset") and CreateObject("ADODB.Recordset") work with Classic ASP: <%@language="VBSCRIPT" CODEPAGE="65001" LCID=1033%>. I guess it depends on how IIS is set up and how your files and folders security is set.

Collectives™ on Stack Overflow

VBscript variable is undefined error

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related