ado²Ù×÷access±¨´í£¡
ÎÒ×öµÄÊÇÒ»¸öDLL£¨MFC£©£¬Æô¶¯ÁËÒ»¸öỊ̈߳¬Ï̺߳¯ÊýÖзâ×°ÁËÏà¹ØµÄÊý¾Ý¿â²Ù×÷¡£
³õʼ»¯ole³É¹¦¡£
Á¬½ÓÊý¾Ý¿â³É¹¦¡£
µ«ÊÇrecordset openµÄʱºò±¨´í£¬MSJETOLEDB40.DLL ¶ÑÕ»Òç³ö¡£
Çë¸ßÊÖÃǰïæ·ÖÎöһϣ¬Ôõô½â¾ö¡£
·ÖÊýÉÙ¿ÉÒÔ¼ÓµÄ....
//Ï̺߳¯Êý
unsigned __stdcall ThreadOperateDB(LPVOID lpParam)
{
CoInitialize(NULL);
CAdoConnection adoCon;
BOOL bCon = adoCon.ConnectAccess(g_szDBFile, "");
if (!bCon)
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü£¡");
return false;
}
CAdoRecordSet adoSet(&adoCon);
while(g_bThread)
{
if (!adoCon.IsOpen())//Êý¾Ý¿â¶Ï¿ªÖØÁ¬
{
bCon = adoCon.ConnectAccess(g_szDBFile, "");
if (!bCon)
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü£¡");
return 0;
}
}
//²éѯ
CString strSQL;
strSQL.Format(_T("select ID from CustomTailorTable where TelNo = '%s'"), g_szTelCaller);
adoSet.Open(strSQL);
int nCount = adoSet.GetRecordCount();
adoSet.Close();
Sleep(100);
}
if (adoCon.IsOpen())
{
adoCon.Disconnect();
}
CoUninitializ
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......
ÒÑÖªÁ½¸öÊý¾Ý¿â£¬·Ö±ðΪBASE.MDB ºÍ BASE2.DBF
×ֶηֱðΪBASE.MDB:NAME NAME2 NAME3
A B C
D E F
......