主题:与SQL SERVER2000连接急需帮助
大家好,本人正作一个定制项目,现在需要将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天没有解决了,郁闷中......
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天没有解决了,郁闷中......