mfc连接sqlserver找不到服务器,MFC用odbc连接sql server2008 死活不成功...急啊！！

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

哪位大神帮我看看啊~

void ****::OnButton1()

{

TRY{

m_database.OpenEx("DSN=stu_ODBC;UID=sa;PWD=1234",CDatabase::noOdbcDialog);

}

CATCH(CDBException,ex)

{

AfxMessageBox(ex->m_strError);

AfxMessageBox(ex->m_strStateNativeOrigin);

}

AND_CATCH(CMemoryException,pEx)

{

pEx->ReportError();

AfxMessageBox("memory exception");

}

AND_CATCH(CException,e)

{

TCHAR szError[100];

e->GetErrorMessage(szError,100);

AfxMessageBox(szError);

}

END_CATCH

// CDialog::OnOK();

if(!m_database.IsOpen())

{

m_database.Open(_T("stu_ODBC"));

}

else

{

MessageBox("failed to open it!");

}

CRecordset m_recordset(&m_database);

CString strSQL;

CString str;

UpdateData(TRUE);//读入用户输入的密码

if(!m_USERNAME.IsEmpty())

{

strSQL.Format("select * from 信息 where password='%s' and username='%s'",m_PASSWORD,m_USERNAME);

m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);//从数据库中查找，输入的密码是否正确

if(m_recordset.GetRecordCount()==0)

{

str.Format("登陆 口令错误或用户不存在！");

this->SetWindowText(str);

m_PASSWORD.Empty();

m_ctrlpassword.SetFocus();

UpdateData(FALSE);

m_recordset.Close( );

m_database.Close();

}

//如果登录成功

else

{

m_recordset.Close( );

m_database.Close();

****U m_dl***ialog::OnOK();

m_dlg.DoModal();

}

}

else

{

str.Format("登陆 用户名不能为空！");

this->SetWindowText(str);

m_ctrluser.SetFocus();

m_database.Close();

}

}