怎么把SQL Server数据库转换成Access数据库!急!
BOOL CPwrGroupApp::InitConn(CString strUserName, CString strPassword, CString strServer)
{
::CoInitialize(NULL);
CString strConn;
strConn.Format(_T("Provider=SQLOLEDB.1;NetWork library=dbmssocn;Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=powermanger;Data Source=tk"));
try
{
m_pConn.CreateInstance(__uuidof(Connection));
m_pConn->Open(_bstr_t(strConn),_T(""),_T(""),-1l );
}
catch(_com_error)
{
return false;
}
return true;
}
这是SQL Server数据库配置函数,怎么转换成Access数据库!急!
我采用的是ADO技术,主要是strConn.Format(_T("Provider=SQLOLEDB.1;NetWork library=dbmssocn;Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=powermanger;Data Source=tk"));怎么变成ACCESS的!