none
Compatibility issue between server windows 2003 with IIS 6.5 and server windows 2008 R2 2008 with IIS 7.5 RRS feed

  • Question

  • <%@ LANGUAGE="VBSCRIPT" %>
    <!-- #include file="dbmgr.asp" -->
    <%
    on error resume next
    '---get state list from db
    Dim strStateList, arrList
    Dim retNo, record_num
     '--connect DB
     call OpenDBConn
     '--set sql
     strSQL = "select inputState from DistLoc_StateMapping order by inputState "
     
     '---get Record Set
     Set g_oRS = Server.CreateObject("ADODB.RecordSet")
     g_oRS.open strSQL, g_oConn
    	
     If not g_oRS.EOF then
    	 arrList = g_oRS.GetRows
    	 retNo="0"
    	 record_num=ubound(arrList,2)+1
    End if
     
     '--close DB
    '--close DB	
      'g_oRS.close
      'Set g_oRS = nothing	
     call closeDBConn
    %>


    1)the code above is  running in windows 2003 server but it is not running on windows 2008 R2 professional.

    <!-- #include file="dbmgr.asp" -->
    <script language="vbscript" type="text/vbscript">
    on error resume next
    '---get state list from db
    Dim strStateList, arrList
    Dim retNo, record_num
     '--connect DB
     call OpenDBConn
     MsgBox(g_test)
     '--set sql
     strSQL = "select inputState from DistLoc_StateMapping order by inputState "
     
     '---get Record Set
     Set g_oRS = Server.CreateObject("ADODB.RecordSet")
     g_oRS.open strSQL, g_oConn
    	
     If not g_oRS.EOF then
    	 arrList = g_oRS.GetRows
    	 retNo="0"
    	 record_num=ubound(arrList,2)+1
    End if
     
     '--close DB
    '--close DB	
      'g_oRS.close
      'Set g_oRS = nothing	
     call closeDBConn

      2)but the code above is  running in windows 2003 server as well as it is  running on windows 2008 R2 professional.

    3)I have application which is in syntax showed in 1st code and it will be cumbersome to change the syntax for all application.Please suggest any configuration setting I need to change and suggest any change I need to do to run this on both the server.

    Monday, May 21, 2012 3:07 PM

Answers