win2000ϵͳADOÁ¬½ÓACCESSÊý¾Ý¿â±ØÐèÒª½øÈë×ÀÃæ?
win2000ϵͳADOÁ¬½ÓACCESSÊý¾Ý¿â±ØÐèÒª½øÈë×ÀÃæÂð?
ÎÒÓÐÒ»¸ö×°ÁËwin2000-SP4µÄ»ú×Ó,ÒÑ×°ÁËMDAC 2.8 ,дÁ˸öwindows·þÎñ³ÌÐòÊÇÓÃADO²Ù×÷ACCESSÊý¾Ý¿âµÄ,Ææ¹ÖµÄÊÇ´ò¿ªÊý¾Ý¿âÎļþʱ,±ØÐèÒªµÇ¼µ½×ÀÃæ²ÅÄÜÕý³£´ò¿ª,δ½ø×ÀÃæ¾Í´ò²»¿ª.
XPÊÇ¿ÉÒÔ²»½ø×ÀÃæ¾Í´ò¿ªACCESSÊý¾Ý¿âµÄѽ.
ÄãÊÇÈçºÎÁ¬µÄ£¿
http://download.csdn.net/source/1498324
_T("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;User ID=;Password=;Jet OLEDB:Database Password=")
¾ÍÕâôÁ¬µÄ
_T("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;User ID=;Password=;Jet OLEDB:Database Password=")
%s µÄÄÚÈÝÊÇʲô£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
¸ñʽ»¯µÄÁ¬½Ó×Ö·û´®,%sÊÇMDBÎļþµÄ·¾¶
csConnectStr.Format(_T("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;User ID=;Password=;Jet OLEDB:Database Password="),m_csDBPath);
try
{
m_pConnection.CreateInstance(__uuidof(Connection));
m_pConnection->Open((_bstr_t)(LPCTSTR)csConnectStr,"","",adModeUnknown);
}
catch(_com_error &e)
{
m_csError = (LPCTSTR)e.Description();
m_pConnection = NULL;
ret = FALSE;
}
Â¥Ö÷°¡¡£
»»¸öÎÊ·¨°É¡£ Äã m_csDBPath ÖеÄÄÚÈÝÊÇʲô£
Ïà¹ØÎÊ´ð£º
±í½á¹¹£º
ProductSeriesID ×Ô¶¯±àºÅ
ProductSeriesName Îı¾
ProductSeriesRemark ±¸×¢
Ö´ÐÐǰ
ProductSeriesID ProductSeriesName ProductSeriesRemark
2 LVϳµ¶ÏµÁÐ LVϳµ¶ÏµÁÐ
3 ÎÙ¸ÖÉá ......
ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......
Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\"
cat = New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......
Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......
m_PriceÊÇfloatÐÍ
m_MonthÊÇctimeÐÍ
ÆäËüÊÇcstringÐÍ
´íÎóÌáʾ£ºµ¯³ö´íÎó¶Ô»°¿ò£¬×××.exe£Ó¦ÓóÌÐò´íÎ󣬡¡¡¡¡¡¸ÃÄÚ´æ²»ÄÜΪ"read"
¸ßÊÖ¼±¾È¡«¡«¡«¡«µ½µ×Ó¦¸ÃÈçºÎд
......