查询分析器用不了，所以用connection可是运行不了？呵呵高手帮助！！！

[yuanxy]

<%
set conn=server.createobject("adodb.connection")
set cmd=server.createobject("adodb.command")
connstr="provider=sqloledb.1;server=asdf;database=chinaauto;uid=yuanxy;pwd=yuanxy1234"
conn.open connstr
sql="use news"
sql=sql&"create table learning"
sql=sql&"("
sql=sql&" articleid int identity(1,1),"
sql=sql&" hits int,"
sql=sql&" images1 varchar(255),"
sql=sql&" dateandtime datetime,"
sql=sql&" images varchar(255),"
sql=sql&" typeid int,"
sql=sql&" review text,"
sql=sql&" reviewcount int,"
sql=sql&" title varchar(255)"
sql=sql&")"
sql=sql&"go"
sql=sql&"create clustered"
sql=sql&"index yuanxy on learning(articleid)"
set cmd.activeconnection=conn
cmd.commandtype=1
cmd.commandtext=sql
cmd.execute
%>

[JavaCoffee]

查询分析器用不了，不一定就连不上数据库；你仔细检查一下，看是什么原因。

你的这段代码能正常运行吗？