收藏
sql2008无效连接问题安装后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; }
-
提问者： charlescg | 提问时间： 2011-11-17 12:30:09 | 回复(0)
我来回答