IIS sopts servings pages using ADO stream
- From: <Taher Sehli>
- Date: Fri, 29 Apr 2005 12:23:25 +0200
Hi all,
I am having a serious problem. IIS stops serving a page using
adExecuteStream option (see the code below). When I comment the Execute
command the page executes fine !
The config is IIS 6.0 on windows 2003 server.
Any Help is appreciated.
Thanx in advance
Here is the code :
Dim ADOStream , AdoConn , strConn
strConn = "PROVIDER=SQLOLEDB;Server=" & NR_CONFIG_SERVER & ";UID=" &
NR_CONFIG_SQL_USER & ";PWD=" & NR_CONFIG_SQL_PASSWORD & ";Database=" &
NR_CONFIG_DATABASE & ";"
set AdoConn = Server.CreateObject("ADODB.Connection")
AdoConn.Open strConn
Set cmd = Server.CreateObject("ADODB.Command")
set ADOStream = Server.CreateObject("ADODB.Stream")
Set cmd.ActiveConnection = AdoConn
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "dbo.nr_getOrderedPagination"
cmd.Parameters.Refresh
cmd("@s_tableName") = nameTable
cmd("@s_fieldName") = strNameOfSortField
cmd("@s_orderBy") = ourOrderBy
cmd("@i_nbChar") = cint(nbChars)
cmd("@i_nPageSize") = cLng(maxRecord_To_DSP)
ADOStream.Open cmd.Properties("Output Stream").Value = ADOStream
cmd.Execute , ,adExecuteStream
strOptions = ADOStream.ReadText
ADOStream.Close
AdoConn.Close
set ADOStream = nothing
Set cmd = nothing
set AdoConn = nothing
.
- Prev by Date: Re: Update database with a dataset
- Next by Date: ADO Query Error 'Path not found'
- Previous by thread: Update database with a dataset
- Next by thread: ADO Query Error 'Path not found'
- Index(es):