Solved

VBScript/IIS 3.0 Error - Not Supported

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

How our DevOps Teams Maximize Uptime

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

Question has a verified solution.

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

Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
When crafting your “Why Us” page, there are a plethora of pitfalls to avoid. Follow these five tips, and you’ll be well on your way to creating an effective page.
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…
The viewer will learn how to dynamically set the form action using jQuery.

713 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