asp连接不到我mysql里_ASP连接MYSQL的问题

用ASP连接MYSQL 用ODBC的源连接 ，查询没问题可以读取到数据，但如果查询语句里有AND的话那就查询不到有内容呀 比如select * from admin where username='test' and

pwd='123'的话 就查询不到数据，这是什么问题??

dim myHost,myDB,myUID,myPWD

myHost = "localhost"

myDB = "test"

myUID = "root"

myPWD = "root"

sql="select * from admin where username='test' and pwd='123'"

strconnection="driver={mysql odbc 5.1 driver};server=" & myHost & ";database=" & myDB & ";user name=" & myUID & ";password=" & myPWD

set conn = server.createobject("adodb.connection")

conn.open strconnection

set rs=server.CreateObject("adodb.recordset")

rs.open sql,conn,1,1

Response.write rs.recordcount

结果等于 -1 但用SQL语句直接在MYSQL里查询 就有数据呀。