1.我建立了用户sa 密码sa 登陆了sql server 2012,如图所示2.我建立了一个test数据库,如图所示3.进入c++2012,用MFC建立一个对话框应用程序,如图所示4.然后我加入一个控件叫查询,双击它进入代码编写
5.我找到数据库连接字符串,如图所示6.我在查询控件里面输入如图所示代码,就是初始化连接对象和记录集对象,如图所示7.然后我调试运行直接跳转到错误的地方,如图所示8.然后就出错了,连接不上,如图所示
我苦苦弄了4天还弄不上,快哭瞎了 ,求大神帮我啊C++MFCSQL Server数据库

解决方案 »

  1.   

     ADOConn1->Close();
     
     ini=new TIniFile(".//SAS_Config.ini");
     tempStr=ini->ReadString("dataBase","数据库类型","SQLSERVER");
     ini->WriteString("dataBase","数据库类型",tempStr);
     if(tempStr=="SQLSERVER") //连接SQL SERVER
     {
    connStr="Provider=SQLOLEDB.1;Persist Security Info=True;";
    tempStr=ini->ReadString("dataBase","密码","xzsat");
    ini->WriteString("dataBase","密码",tempStr);
    connStr+="Password="+tempStr+";" ;
    tempStr=ini->ReadString("dataBase","用户名","sa");
    connStr+="User ID="+tempStr+";" ;
    ini->WriteString("dataBase","用户名",tempStr);
    tempStr=ini->ReadString("dataBase","数据库名称","daw");
    connStr+="Initial Catalog="+tempStr+";" ;
    ini->WriteString("dataBase","数据库名称",tempStr);
    tempStr=ini->ReadString("dataBase","服务器名(IP)","XJQ-SAT");
    connStr+="Data Source="+tempStr+" " ;
              ini->WriteString("dataBase","服务器名(IP)",tempStr);
     }
     else       //连接ACCESS
     {
       // Provider=Microsoft.Jet.OLEDB.4.0;Password=123;Data Source=E:\VehData.mdb;Persist Security Info=True
    connStr="Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=True;";
    tempStr=ini->ReadString("dataBase","密码","");
    ini->WriteString("dataBase","密码",tempStr);
    connStr+="Password="+tempStr+";" ;
    //tempStr=ini->ReadString("dataBase","用户名","Admin");
    //connStr+="User ID="+tempStr+";" ;
    //ini->WriteString("dataBase","用户名",tempStr);
    tempStr=ini->ReadString("dataBase","数据库名称","E:\VehData.mdb");
    connStr+="Data Source="+tempStr+";" ;
    ini->WriteString("dataBase","数据库名称",tempStr);
             }
             delete ini;  ADOConn1->ConnectionString=connStr;
     ADOConn1->Open();