<%@ 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.