问题一大堆啊。在问一个关于Oracle数据库在ASP中XML输出的问题。

[duguguiyu1984]

以下代码在SQL数据库中通过，在Oracle中无法通过。

Set conn = CreateObject("ADODB.Connection")
conn.Provider = "SQLXMLOLEDB.3.0"
conn.ConnectionString = ConnectionString
conn.Open

Set cmd = CreateObject("ADODB.Command")
Set cmd.ActiveConnection = conn

cmd.Dialect = DBGUID_SQL
Set stmXMLout = CreateObject("ADODB.Stream")
stmXMLout.Open
cmd.Properties("Output Stream") = stmXMLout
cmd.CommandText = "XXXXX"
cmd.CommandType = 1
cmd.Properties("xml root") = "Reporting"
cmd.Properties("Base Path") = MyBasePath
cmd.Properties("xsl") = "xx.xsl"
cmd.Execute, , adExecuteStream

在所有Properties行报错。Item cannot be found in the collection corresponding to the requested name or ordinal.
全部注销以后在最后一行报错。说不支持此Provider。

oracle下的connectinstring为
const ConnectionString = "Provider=MSDAORA.1;Data Source=XX;User ID=XX;Password=XX"

怀疑是不是Oracle下不支持SQLXMLOLEDB.3.0。。如果是，该换成什么求解~~~~~~~~~~~~~~~~~~~~

[duguguiyu1984]

up

[duguguiyu1984]

up~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[duguguiyu1984]

up~~~~~~~~~~~~~

[allfuly]

conn.Provider = "SQLXMLOLEDB.3.0"
这行在Oracle中不被支持

[duguguiyu1984]

那我想在页面中输出XML该怎么写？？

[duguguiyu1984]

55555没人知道吗？

[duguguiyu1984]

D~~~~I~~~~N~~~~~~G~~~~~~~