大家好,本人正作一个定制项目,现在需要将access数据往sql数据迁移,可以 总是连不上,请各位大侠指教,谢谢,技术验证代码如下:

ADOConnection1->ConnectionString   =   "Provider=SQLOLEDB.1;Persist   Security   Info=False;User   ID=sa;Password=sa;Initial   Catalog=suc;Data   Source=LUOBO-5AA1BC628" ;
    ADOConnection1->Connected;

    ShowMessage("test db");

      ComboBox1->Items->Clear();
        try
         {

               ADOQuery1->Connection=ADOConnection1;
            //   ADOQuery1->Active=true;
               AnsiString sql="select *  from   t_emp ";
               ADOQuery1->SQL->Clear();
                ADOQuery1->SQL->Add(sql);
               ADOQuery1->Prepared;

              ShowMessage("test db..........");   ADOQuery1->Open();
                while(!ADOQuery1->Eof)   //结束双击
                 {
                  ComboBox1->Items->Add(ADOQuery1->Fields->Fields[0]->AsString);       
                  ADOQuery1->Next();
                }

        }

        catch(Exception   &E)
        {
        ShowMessage("error");
        }

        ADOConnection1->Close();
        ADOQuery1->Close();
系统提示 :连接字符串属性无效,请各位指点。万分感谢,已经3天没有解决了,郁闷中......