conn.Open "provider=sqloledb;data source=(local);uid=jsyc;pwd=123456;database=jzzs"
用这种形式就OK了。
把错误的提示给贴出来
set conn=server.createobject("adodb.connection")
conn.open"driver={SQL Server};" & "server=local;" & " uid=jsyc;" & "pwd=123456;" & "database=jzzs;"