临时表问题-----在线等

[titan913]

ls_a1=select x1,x2...xn into #temp from tabal_1
ls_a2=select a.*,b.y from table_1 a(nolock),#1 b(nolock) where a.z=b.z and ...

Set ftsqf = Server.CreateObject("ADODB.Recordset")
cmdTemp.CommandText = ls_a2
cmdTemp.CommandType = 1
cmdTemp.CommandTimeout = 0
Set cmdTemp.ActiveConnection = ELEC
ftsqf.Open cmdTemp, , 1, 1
为何提示“ODBC 驱动程序不支持所需的属性”

请给出一个相关的临时表例子，谢谢！

[vulcan]

Set cmdTemp.ActiveConnection = ELEC

ELEC有没有定义？

[titan913]

定义了，总共1个ADODB.Connection，2个ADODB.recordset

[vulcan]

ftsqf.Open cmdTemp,ELEC, 1,3
试试

[cpp2017]

例子:
strSQL ="select A.a1,A.a2 into #temp;select * from #temp"
rs.open strSQL,Conn,3,1]
set rs = rs.NextReocrdSet
if (not RS.EOF)
{
Response.write(rs(0).value);
}