string sqlConnectionString = String.Format(@"Data Source={0};Initial Catalog={1};Integrated Security=True;MultipleactiveResultSets=True",server,database);
string mdbConnectionString = String.Format(@"Provider=microsoft.JET.OLEDB.4.0;data source={0};",@"C:\test\test.mdb");
using (var mdbConnection = new OleDbConnection(mdbConnectionString))
using (var sqlConnection = new SqlConnection(sqlConnectionString))
{
mdbConnection.Open();
sqlConnection.Open();
// Empty table
var sqlQuery = String.Format("DELETE FROM Languages");
var sqlCommand = new SqlCommand(sqlQuery,sqlConnection);
sqlCommand.ExecuteNonQuery();
// Fill table with new information
sqlQuery = String.Format("INSERT INTO Languages (ID,lang) " +
"SELECT ID,lang " +
"FROM OPENrowset('" + mdbConnection.Provider + "','" + mdbConnection.DataSource + "'; 'admin'; '',Languages)");
sqlCommand = new SqlCommand(sqlQuery,sqlConnection);
sqlCommand.ExecuteNonQuery();
}
第二个sqlCommand
在调用ExecuteNonQuery
时引发此错误:
System.Data.SqlClient.SqlException:'无法为链接服务器'(null)'创建OLE DB提供程序'microsoft.JET.OLEDB.4.0'的实例。''。''
我想念什么?