Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

VBScript/IIS 3.0 Error - Not Supported

Posted on 1998-12-08
2
Medium Priority
?
228 Views
Last Modified: 2013-12-25
I am using the following code:
<%
SET Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "dsn=xxx;uid=xxx;pwd=xxx"
Qs = "Select count(*) Num from employee where n_empid = '12345'
SET ST=Conn.Execute(Qs)
Op = ST("Num")
IF Op = "1" THEN      'ERROR IN THIS LINE
<some statements>
ELSE
<some statements>
END IF
%>
I get the following error:

Microsoft VBScript runtime error '800a01ca'

Variable uses an Automation type not supported in VBScript

/myfirstproj/default.asp, line 34

The same program runs in my local Personal Web Server (in Windows 98) but does not run when I move it to the IIS 3.0 on NT 4.0
0
Comment
Question by:sowmyan
2 Comments
 
LVL 3

Accepted Solution

by:
hkp earned 100 total points
ID: 1856971
Line 34 is not syntactically correct. Try to do the following instead of line 34

If "#" & Op = "#1" Then

or

If Op = 1 Then


0
 

Author Comment

by:sowmyan
ID: 1856972
I had already tried this. I suspect the problem to be the absence of some files (dlls or otherwise) in the ISS server machine that is present in my local machine.
thanks anyway.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
When the s#!t hits the fan, you don’t have time to look up who’s on call, draft emails, call collaborators, or send text messages. An instant chat window is definitely the way to go, especially one like HipChat. HipChat is a true business app. An…
The viewer will learn how to count occurrences of each item in an array.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses
Course of the Month14 days, 1 hour left to enroll

580 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