Solved

Interdev 6.0 and IIS5.0 on Win2KPro

Posted on 2000-03-08
5
260 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Time Conversions...both ways 2 29
Cannot open file from ASP if user is "logged in" 13 39
innerHTML 7 45
JQuery on multiple lines 3 47
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…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

739 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