为什么每次连接数据库时都是‘请检查资源配置’,用的是sql server2000

  • 初始化ADO链接... */ void CBookManageApp::InitAdo() { try { ::CoInitialize(NULL); CString AdoConString = "driver={SQL Server};SERVER=(LOCAL);UID=sa;PWD=;DATABASE=bookshop"; m_pCon.CreateInstance(_uuidof(Connection));
    m_pCon->ConnectionString = (_bstr_t)AdoConString; m_pCon->Open("","","",NULL); m_pCom.CreateInstance("ADODB.Command"); m_pRs.CreateInstance(_uuidof(Recordset));
    } catch(_com_error) {
    MessageBox(0,"请检查系统配置信息", "数据库连接失败",MB_OK);
    return; } catch(...) {
    AfxMessageBox("SYS Error"); return ; } 可能连接不上的问题都有什么

你这个都是你人为代码控制的,你能网上搜搜SQL 连接,感觉你们好懒,先给罗列几个 :

标准安全连接

Data Source = myServerAddress;Initial Catalog = myDataBase;User Id = myUsername;Password = myPassword;
使用服务器名\实例名作为连接指定SQL Server实例的数据源。如果你使用的是SQL Server 2008 Express版,实例名为SQLEXPRESS。

可替代的标准安全连接

Server = myServerAddress;Database = myDataBase;User ID = myUsername;Password = myPassword;Trusted_Connection = False;

信任连接

Data Source = myServerAddress;Initial Catalog = myDataBase;Integrated Security = SSPI;
可替代的信任连接

Server = myServerAddress;Database = myDataBase;Trusted_Connection = True;

OracleConnection conn = new OracleConnection("Provider=MSDAORA;Data Source=DATABASE.hospital.com;User Id=blgd;Password=blgd;");
conn.open();