紧急！！

[wdaanng]

set conn=server.createobject("adodb.connection")
set rs=server.createobject("adodb.recordset")
conn.open="driver=sql server;server=sizheng;database=renshi;uid=sa;pwd=sqlpass"

rs.open sql,conn,3,2

这段代码有什么错误？为什么系统总说：
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: '=' 附近有语法错误。

请各位帮忙看看

[wdaanng]

我还有一个问题：
当查询到的记录某个字段为空时，我想让其显示"空"，可就是显示不出来。
以下是我的代码，请各位帮忙看看
intfieldcount=rs.fields.count-1
if not rs.eof then
response.write "<table border=1><tr>"
for intl=0 to intfieldcount
response.write"<td><b>"&rs(intl).name&"</b></td>"
next
response.write"</tr>"

do while not rs.eof
response.Write "<tr>"
for intl=0 to intfieldcount
if rs.fields(intl).value<>"" then
response.write"<td valign=""top"">"&rs.fields(intl).value&"</td>"
else
response.write"<td valign=""top"">空</td>"
end if
next
response.write"</tr>"
rs.movenext
loop
response.write"</table>"
end if

[cpp2017]

sql 语句有问题

[cqfeng]

conn.open "driver=sql server;server=sizheng;database=renshi;uid=sa;pwd=sqlpass"

[cmsoft]

conn.open "driver=sql server;server=sizheng;database=renshi;uid=sa;pwd=sqlpass"

conn.open后面没有=

[zippooo]

conn.open="driver=sql server;server=sizheng;database=renshi;uid=sa;pwd=sqlpass"
应该是conn.open "driver=sql server;server=sizheng;database=renshi;uid=sa;pwd=sqlpass"

[mygoodbuy]

怎么没有看到sql的值？

[ministry_bill]

conn.open "driver={sql server};server=sizheng;database=renshi;uid=sa;pwd=sqlpass"
另外你的sql语句？

[billyqiao]

conn.open="driver=sql server;server=sizheng;database=renshi;uid=sa;pwd=sqlpass"
也可改成：conn.connectionstring="driver={sql server};server=sizheng;database=renshi;uid=sa;pwd=sqlpass"
conn.open
sql="select * from tablename"
rs.open sql,conn,3,2

[shadowkiss]

yes conn.open=XXX is wrong

[wdaanng]

完整的程序是这样的
从表单获取strzgdm的值

sql="select * from zgjbt_2 where"

if strzgdm<>"" then
sql=sql+"gzdm='"+strzgdm+"'"
end if

set conn=server.createobject("adodb.connection")
set rs=server.createobject("adodb.recordset")
conn.open"driver=sql server;server=sizheng;database=renshi;uid=sa;pwd=sqlpass"

rs.open sql,conn,3,2

请大家帮忙看看

[wdaanng]

谢谢各位的帮忙

[ministry_bill]

set conn=server.createobject("adodb.connection")
conn.open"driver={sql server};server=sizheng;database=renshi;uid=sa;pwd=sqlpass"
set rs=server.createobject("adodb.recordset")
sql="select * from zgjbt_2"
if strzgdm<>"" then
sql=sql&" where gzdm='"&strzgdm&"'"
end if
rs.open sql,conn,1,1//不修改、添加数据库的话