Accessing an Access database using the ADO method in vc++6.0

Using ADO to connect to a database is done through the connection object's open method, which is:

Connection.Open connectionstring.userid.password,openoptions

Parameter description:

Connectionstring: (optional) string, containing connection information

UserID: (optional) string that contains the user name to use when connecting

Password: (optional) string containing multiple passwords when establishing a connection

Openoptions: (optional) ConnectOptionEnum value, and if set to Adconnectoasync, the connection is opened asynchronously.

ConnectComplete event is generated when connection is available

The specific implementation methods are as follows:

void CConnectDlg::OnInitADOConn()
{
try
{
//创建连接对象实例
m_pConnection.CreateInstance("ADODB.Connection");
//设置连接字符串
CString strConnect="DRIVER={Microsoft Access Driver (*.mdb)};
uid=;pwd=;DBQ=shujuku.mdb;";
//使用Open方法连接数据库
m_pConnection->Open((_bstr_t)strConnect,"","",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox(e.Description());
}
}
void CConnectDlg::ExitConnect()
{
//关闭记录集和连接
if(m_pRecordset!=NULL)
m_pRecordset->Close();
m_pConnection->Close();
}