I run a VBScript on the win98 task scheduler. It gave a error message like this: Line: 20 char: 1 Error: Object required: "Server" Code: 800A01A8 Source: Microsoft VBScript runtime error
My code in line 20 & 21 are: Set strConnect = Server.CreateObject("ADODB.Connection") strconnect.open "DSN=ppsWEB"
Thanks in advance.
Y.H. Duan
Tue, 26 Nov 2002 03:00:00 GMT
Bill #2 / 4
run a VBSript on Win98 task scheduler
I beleive the Server object is only available in ASP.
Try
Set strConnect = CreateObject("ADODB.Connection") strconnect.open "DSN=ppsWEB"
Quote:
> I run a VBScript on the win98 task scheduler. It gave a error message > like this: > Line: 20 > char: 1 > Error: Object required: "Server" > Code: 800A01A8 > Source: Microsoft VBScript runtime error
> My code in line 20 & 21 are: > Set strConnect = Server.CreateObject("ADODB.Connection") > strconnect.open "DSN=ppsWEB"
> Thanks in advance.
> Y.H. Duan
Tue, 26 Nov 2002 03:00:00 GMT
Yongheng Dua #3 / 4
run a VBSript on Win98 task scheduler
Bill: Thanks. Another question is: Can I use the following code in vbscript?
strSQL="SELECT * FROM ops " 'set up rst Set rst=createobject("ADODB.RECORDSET") rst.open strSQL, _ strConnect, ado_OpenKeyset, ado_LockOptimistic
It gives me the error message:" ADO could not find the object in the collection corresponding to the name or oridinal reference requested by the application".
run a VBSript on Win98 task scheduler