数据库里有这个表吗?你的odbc是否连对了数据库
看看表user_info的owner是不是dbo
strQuery = "select user_ID,User_PWD from dbo.user_Info where
user_ID = ' "+m_sUSER+" ' ";
看看表user_info的owner是不是dbo
strQuery = "select user_ID,User_PWD from dbo.user_Info where
user_ID = ' "+m_sUSER+" ' ";
exec sp_defaultdb 'sa','you database'
2.reconfig ODBC the datasource must correct!
3.try use oledb privoder a connection string like:constr="driver={SQL Server};server=servername;uid=sa;pwd=;database=db name"