sql2008无效连接问题回答(0条) 2011-11-17 12:30:09
问题描述:安装后MANAGER STUDIO用SA账号可登陆,TELNET 192。168。1。101 1433也可以,但是就是程序调用时提示无效连接,程序代码CString strIP = ini.GetValue( "DBSetup", "IP", "127.0.0.1" );
CString strDBName = ini.GetValue( "DBSetup", "DBName", "apollo" );
CString strUserName = ini.GetValue( "DBSetup", "UserName", "sa" );
CString strPassword = ini.GetValue( "DBSetup", "Password", "apollo" );
CString strConnection = _T("Provider=SQLOLEDB;Network Library=DBMSSOCN;Data Source=" + strIP \
+ ";Initial Catalog=" + strDBName \
+ ";User Id=" + strUserName \
+ ";Password=" + strPassword + ";");
if ( g_db.Open(strConnection) == FALSE )
{
CSetupSheet sheet("系统设置", NULL, 0);
if ( sheet.DoModal() != IDOK )
return FALSE;
strConnection = _T("Provider=SQLOLEDB;Network Library=DBMSSOCN;Data Source=" + sheet.m_wndDBPage.m_strIP \
+ ";Initial Catalog=" + sheet.m_wndDBPage.m_strDBName \
+ ";User Id=" + sheet.m_wndDBPage.m_strUserName \
+ ";Password=" + sheet.m_wndDBPage.m_strPassword + ";");
if ( !g_db.Open(strConnection) )
return FALSE;
}


