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 ÖеÄÄÚÈÝÊÇʲô£
Ïà¹ØÎÊ´ð£º
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ
Microsoft O ......
ÎÒĿǰ±íµÄÅÅÁÐÊÇÉÏÃæÕâÕÅͼÕâÇé¿ö£º
ÎÒÏ£Íûµ÷Õû³É£º
ÈçºÎ×öÄØ£¿
¸Õ²ÅÊÔÁËÏ£¬µã¡°¿ªÊ¼¡±--¡°ÊÓͼ¡±--¡°Éè¼ÆÊÓͼ¡±²»ÐÐ
PS£ºÎÒÓõÄÊÇaccess 2007£¬ÉÏÃæÕâ¸ö±íÊÇmdb¸ñʽµÄ
Ö÷²Ëµ¥£¬ ÊÓͼ ......