vb 连sybase数据库时，执行到rs.Open "select * from user_data_mail where send_flag='0'",.......时出错

Question

vb 连sybase数据库时，执行到rs.Open "select * from user_data_mail where send_flag='0'",.......时出错

Answer 1

完整语句：
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.Open "DSN=test_sendmail;UID=sa;PWD=suntek"
rs.Open "select * from user_data_mail where send_flag='0'", conn, adOpenDynamic, adLockOptimistic

Answer 2

试试
rs.Open "select * from user_data_mail where send_flag=0", conn, adOpenDynamic, adLockOptimisticsend_flag的数据类型是什么？