Solved

Interdev 6.0 and IIS5.0 on Win2KPro

Posted on 2000-03-08
5
261 Views
Last Modified: 2012-06-22
I Recently upgraded to Win2Kpro. I have the following problem:

All recordset design-time controls generate the same error when viewed locally - through view in browser.(Still works on the IIS4 serevr)

PAGE OUPUT:

The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

--------------------------------------------------------------------------------

Please try the following:

Click the Refresh button, or try again later.

Open the g35292 home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
ADODB.Connection (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/test_Local/ASP Page1.asp, line 29


Browser Type:
Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)

Page:
GET /test_Local/ASP Page1.asp

Time:
Wednesday, March 08, 2000, 3:25:20 PM


More information:
Microsoft Support
 

0
Comment
Question by:Manie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 9

Expert Comment

by:TTom
ID: 2595918
Can we see the contents of line 29 (or a chunk of code relating to that line)?

Quick guess.

It's possible that the connection information (DNS string) was trashed by your update.

Tom
0
 
LVL 1

Author Comment

by:Manie
ID: 2600882
Line 29 contains the code for a "drag'n'drop" Recordset object.  As it is a GUI object I do not want to change the code - I only modify the properties of the object.

Code follows:  error line marked with (*).  BTW, if I comment out the line, the next one gives an error, and so on.

<!--#INCLUDE FILE="../_ScriptLibrary/Recordset.ASP"-->
<SCRIPT LANGUAGE="JavaScript" RUNAT="server">
function _initrsAgent()
{
      var DBConn = Server.CreateObject('ADODB.Connection');
(*)      DBConn.ConnectionTimeout = Application('BulkConn1_ConnectionTimeout');
      DBConn.CommandTimeout = Application('BulkConn1_CommandTimeout');
      DBConn.CursorLocation = Application('BulkConn1_CursorLocation');
      DBConn.Open(Application('BulkConn1_ConnectionString'), Application('BulkConn1_RuntimeUserName'), Application('BulkConn1_RuntimePassword'));
      var cmdTmp = Server.CreateObject('ADODB.Command');
      var rsTmp = Server.CreateObject('ADODB.Recordset');
      cmdTmp.ActiveConnection = DBConn;
      rsTmp.Source = cmdTmp;
      cmdTmp.CommandType = 1;
      cmdTmp.CommandTimeout = 10;
      cmdTmp.CommandText = 'SET ROWCOUNT 0 SELECT * FROM Agent';
      rsTmp.CacheSize = 10;
      rsTmp.CursorType = 3;
      rsTmp.CursorLocation = 3;
      rsTmp.LockType = 3;
      rsAgent.setRecordSource(rsTmp);
      rsAgent.open();
      if (thisPage.getState('pb_rsAgent') != null)
            rsAgent.setBookmark(thisPage.getState('pb_rsAgent'));
}
function _rsAgent_ctor()
{
      CreateRecordset('rsAgent', _initrsAgent, null);
}
function _rsAgent_dtor()
{
      rsAgent._preserveState();
      thisPage.setState('pb_rsAgent', rsAgent.getBookmark());
}
</SCRIPT>
0
 
LVL 9

Accepted Solution

by:
TTom earned 200 total points
ID: 2601143
Let's look at:

Application(BulkConn1_ConnectionTimeout) = ???

in global.asa

Tom
0
 
LVL 1

Author Comment

by:Manie
ID: 2611067
TTom,

Solved my problem.  Thanks for your attempts.  It worked out that when you create a project through INTERDEV, it doesn't create the local web as an application.  

Until I find the solution, the workaround is to modify the local web and set it to be an application.
I found this out when all ASP code that requires Appliactions (such as server.application) breaks with th esame error.

I reduced the point score to 100.
Respond to claim your points.
0
 
LVL 1

Author Comment

by:Manie
ID: 2611071
Points allocated for response.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

729 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