Solved

VBScript/IIS 3.0 Error - Not Supported

Posted on 1998-12-08
2
212 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
Comment Utility
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
Comment Utility
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

771 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

9 Experts available now in Live!

Get 1:1 Help Now