ADO 2.6没有生效?如何解决?(200分)

  • 主题发起人 主题发起人 superwings
  • 开始时间 开始时间
S

superwings

Unregistered / Unconfirmed
GUEST, unregistred user!
我安装了sql server 2k之后 安装的ado 2.6好像不太起作用!
因为使用其中一个属性的时候居然出错。例子是ado 2.6自己的例子。
如何确认安装ado 2.6呢?
程序如下:
Response.Write "<H3>Server-side processing</H3>"

Dim adoConn
Set adoConn = Server.CreateObject("ADODB.Connection")

Dim sConn
sConn = "DSN=EcConnection;uid=sa;pwd=xxxxx"
adoConn.ConnectionString = sConn
adoConn.CursorLocation = adUseClient
adoConn.Open

Dim adoCmd
Set adoCmd = Server.CreateObject("ADODB.Command")
Set adoCmd.ActiveConnection = adoConn

Dim sQuery
sQuery = "<ROOT xmlns:sql='urn:schemas-microsoft-com:xml-sql'><sql:query>SELECT * FROM customerTBl FOR XML AUTO</sql:query></ROOT>"

Dim adoStreamQuery
Set adoStreamQuery = Server.CreateObject("ADODB.Stream")
adoStreamQuery.Open
adoStreamQuery.WriteText sQuery, adWriteChar
adoStreamQuery.Position = 0

Set adoCmd.CommandStream = adoStreamQuery
adoCmd.Dialect = "{5D531CB2-E6Ed-11D2-B252-00C04F681B71}"

Response.write "Pushing XML to client for processing " &amp
"<BR/>"

adoCmd.Properties("Output Stream") = Response
--------出错。

Response.write "<XML ID='MyDataIsle'>"
adoCmd.Execute , , adExecuteStream
Response.write "</XML>"
 
Component Checker

The Component Checker tool is designed to help you determine installed version
information and diagnose installation issues with the Microsoft Data Access Components
(MDAC). Component Checker runs on the following operating systems: Microsoft
Windows 95, Windows 98, Windows NT 4.0, and Windows 2000. Only 32-bit and
64-bit platforms are supported. Component Checker has been updated to include
MDAC 2.6 data.


http://download.microsoft.com/download/dasdk/install/1.0/WIN98/EN-US/cc.exe
 
接受答案了.
 

Similar threads

后退
顶部