Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

VBScript/IIS 3.0 Error - Not Supported

Posted on 1998-12-08
2
Medium Priority
?
225 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Originally, this post was published on Monitis Blog, you can check it here . It goes without saying that technology has transformed society and the very nature of how we live, work, and communicate in ways that would’ve been incomprehensible 5 ye…
CTAs encourage people to do something specific to show interest in your company, product or service. Keep reading to learn why CTAs should always be thought of as extremely important, albeit small, sections of websites.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.
Suggested Courses

885 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