Solved

VBScript/IIS 3.0 Error - Not Supported

Posted on 1998-12-08
2
213 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 50 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Learn by example how to specify CSS selectors for Selenium WebDriver test automation software.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now