代碼如下：
#include <iostream>
#import "c:\\Program Files\\Common Files\\System\\ado\\msado15.dll" no_namespace rename("EOF","adoEOF") rename("BOF","adoBOF")
int main()
{
_ConnectionPtr m_pConnection;
_RecordsetPtr m_pRecordset;
_bstr_t strConnect = "Provider=SQLOLEDB;Data Source=CH-SPIDER;User ID=sa;Paswword=aabbcc123;Initial Catalog=MyStocks";
_bstr_t sql = "SELECT COUNT(*) FROM [CoreConception]";
m_pRecordset = m_pConnection->Execute(sql, NULL, adCmdText);
_variant_t vIndex = (long)0;
_variant_t vCount = m_pRecordset->GetCollect(vIndex);///取得第一個欄位的值放入vCount變數
m_pRecordset->Close();
m_pConnection->Close();
CoUninitialize();
std::cout << "Hello World!\n";
}
報錯如下：
uj5u.com熱心網友回復：
Execute 之前 先要掛接和打開資料庫
_ConnectionPtr m_pConnection;
_variant_t RecordsAffected;
try
{
m_pConnection.CreateInstance(__uuidof(Connection));
m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Northwind.mdb","","",adModeUnknown);
}
catch(_com_error e)
{
CString errormessage;
errormessage.Format("連接資料庫失敗!\r錯誤資訊:%s",e.ErrorMessage());
AfxMessageBox(errormessage);
return;
}
try
{
_bstr_t strCmd="INSERT INTO Employees(EmployeeID,FirstName,LastName,HireDate,City,Country) VALUES(10,'Mary','Williams','15/4/1993 12:00:00','New York','USA')";
m_pConnection->Execute(strCmd,&RecordsAffected,adCmdText);
}
catch(_com_error &e)
{
AfxMessageBox(e.Description());
}
if(m_pConnection->State)
{
m_pConnection->Close();
}
uj5u.com熱心網友回復：
沒有初始化COM,開頭加行
CoInitialize();
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/26949.html
標籤：數據庫