我又试了dsn的连接
dsn设置没错叫school,测试成功
Set adoConn = Server.CreateObject("ADODB.Connection")
strDSN="DSN=school;uid=sa;pwd="
adoConn.Open strDSM
Set adoRs = Server.CreateObject("ADODB.Recordset")
adoRs.ActiveConnection = adoConn
adoRs.Open "select * from EMPLOYEE"
adoRs.MoveFirst
fdcount=adoRs.Fields.Count
response.write "dd" & fdcount
response.write adoRs
adoRs.Close
Set adoRs = Nothing
adoConn.Close
Set adoConn = nothing
dsn设置没错叫school,测试成功
Set adoConn = Server.CreateObject("ADODB.Connection")
strDSN="DSN=school;uid=sa;pwd="
adoConn.Open strDSM
Set adoRs = Server.CreateObject("ADODB.Recordset")
adoRs.ActiveConnection = adoConn
adoRs.Open "select * from EMPLOYEE"
adoRs.MoveFirst
fdcount=adoRs.Fields.Count
response.write "dd" & fdcount
response.write adoRs
adoRs.Close
Set adoRs = Nothing
adoConn.Close
Set adoConn = nothing
是在asp里调用的