MS SQL Server ODBC - Mdac 2.8 and ADODB.Stream on II6

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Mdac 2.8 and ADODB.Stream on II6

ronbl

2005-05-02, 8:23 pm

Hi,

I host new site on godaddy servers.
2003 server with mdac 2.8 on ii6

The error i recive:

ADODB.Command error '800a0cc1'

Item cannot be found in the collection corresponding to the requested
name or ordinal.

My code:

Set oCommand = Server.CreateObject("ADODB.Command")
oConn.CursorLocation = adUseClient
oCommand.ActiveConnection = oConn
oConn.CursorLocation = adUseClient
oCommand.CommandType = adCmdText
oCommand.CommandText = sQuery
Set oStream = Server.CreateObject("ADODB.Stream")
oStream.Open
oCommand.CommandStream = oStream
oCommand.Properties("Output Stream").Value = oStream

call oCommand.Execute(,,1024) ', , 1024 'adExecuteStream

sXMLStream = oStream.ReadText
If oStream.State = adStateOpen Then oStream.Close
Set oStream = Nothing
Set oCommand = Nothing

The Query Is for XML Auto

I cant get the right answer for slove this problem

any help, pls

10x

Ron Belson

Sponsored Links