Solved

Interdev 6.0 and IIS5.0 on Win2KPro

Posted on 2000-03-08
5
257 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
  • 3
  • 2
5 Comments
 
LVL 9

Expert Comment

by:TTom
Comment Utility
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
Comment Utility
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
Comment Utility
Let's look at:

Application(BulkConn1_ConnectionTimeout) = ???

in global.asa

Tom
0
 
LVL 1

Author Comment

by:Manie
Comment Utility
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
Comment Utility
Points allocated for response.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

728 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

10 Experts available now in Live!

Get 1:1 Help Now