ADOÊý¾Ý¿â²Ù×÷(ACCESS)
Ò»¡¢ADO¼ò½é
ADO(Active Data Object£¬»î¶¯Êý¾Ý¶ÔÏó)ʵ¼ÊÉÏÊÇÒ»ÖÖ»ùÓÚCOM(×é¼þ¶ÔÏóÄ£ÐÍ)ÖеÄ×Ô¶¯»¯½Ó¿Ú(IDispatch)¼¼Êõ£¬²¢ÒÔOLE DB(¶ÔÏóÁ¬½ÓºÍÏâÈëµÄÊý¾Ý¿â)Ϊ»ù´¡£¬¾¹ýOLE DB¾«ÐÄ°ü×°ºóµÄÊý¾Ý¿â·ÃÎʼ¼Êõ£¬ÀûÓÃËü¿ÉÒÔ¿ìËٵĴ´½¨Êý¾Ý¿âÓ¦ÓóÌÐò¡£
ADOÌṩÁËÒ»×é·Ç³£¼òµ¥£¬½«Ò»°ãͨÓõÄÊý¾Ý·ÃÎÊϸ½Ú½øÐзâ×°µÄ¶ÔÏó¡£ÓÉÓÚODBCÊý¾ÝÔ´Ò²ÌṩÁËÒ»°ãµÄOLE DB Privider£¬ËùÒÔADO²»½ö¿ÉÒÔÓ¦ÓÃ×ÔÉíµÄOLE DB Privider£¬¶øÇÒ»¹¿ÉÒÔÓ¦ÓÃËùÓеÄODBCÇý¶¯³ÌÐò¡£
¶þ¡¢ADOÊý¾Ý¿â²Ù×÷
1¡¢Ê×ÏÈ£¬ÒªÓÃ#importÓï¾äÀ´ÒýÓÃÖ§³ÖADOµÄ×é¼þÀàÐÍ¿â(*.tlb)£¬ÆäÖÐÀàÐÍ¿â¿ÉÒÔ×÷Ϊ¿ÉÖ´ÐгÌÐò(DLL¡¢EXEµÈ)µÄÒ»²¿·Ö±»¶¨Î»ÔÚÆä×ÔÉí³ÌÐòÖеĸ½Êô×ÊÔ´ÀÈ磺±»¶¨Î»ÔÚmsado15.dllµÄ¸½Êô×ÊÔ´ÖУ¬Ö»ÐèÒªÖ±½ÓÓÃ#importÒýÓÃËü¼È¿É¡£¿ÉÒÔÖ±½ÓÔÚStdafx.hÎļþÖмÓÈëÏÂÃæÓï¾äÀ´ÊµÏÖ£º
#import "c:program filescommon filessystemadomsado15.dll"
no_namespace
rename ("EOF", "adoEOF")
ÆäÖз¾¶Ãû¿ÉÒÔ¸ù¾Ý×Ô¼ºÏµÍ³°²×°µÄADOÖ§³ÖÎļþµÄ·¾¶À´×ÔÐÐÉ趨¡£µ±±àÒëÆ÷Óöµ½#importÓï¾äʱ£¬Ëü»áΪÒýÓÃ×é¼þÀàÐÍ¿âÖеĽӿÚÉú³É°ü×°À࣬#importÓï¾äʵ¼ÊÉÏÏ൱ÓÚÖ´ÐÐÁËAPIºÊýLoadTypeLib()¡£#importÓï¾ä»áÔÚ¹¤³Ì¿ÉÖ´ÐгÌÐòÊä³öĿ¼ÖвúÉúÁ½¸öÎļþ£¬·Ö±ðΪ*.tlh(ÀàÐÍ¿âÍ·Îļþ)¼°*.tli(ÀàÐÍ¿âʵÏÖÎļþ)£¬ËüÃÇ·Ö±ðΪÿһ¸ö½Ó¿Ú²úÉúÖÇÄÜÖ¸Õ룬²¢Îª¸÷ÖÖ½Ó¿Ú·½·¨¡¢Ã¶¾ÙÀàÐÍ£¬CLSIDµÈ½øÐÐÉùÃ÷£¬´´½¨Ò»ÏµÁаü×°·½·¨¡£Óï¾äno_namespace˵Ã÷ADO¶ÔÏó²»Ê¹ÓÃÃüÃû¿Õ¼ä£¬rename ("EOF", "adoEOF")˵Ã÷½«ADOÖнáÊø±êÖ¾EOF¸ÄΪadoEOF£¬ÒÔ±ÜÃâºÍÆäËü¿âÖÐÃüÃûÏà³åÍ»¡£
2¡¢Æä´Î£¬ÔÚ³ÌÐò³õʼ¹ý³ÌÖÐÐèÒª³õʼ»¯×é¼þ£¬Ò»°ã¿ÉÒÔÓÃCoInitialize(NULL);À´ÊµÏÖ£¬ÕâÖÖ·½·¨ÔÚ½áÊøʱҪ¹Ø±Õ³õʼ»¯µÄCOM£¬¿ÉÒÔÓÃÏÂÃæÓï¾äCoUnInitialize();À´ÊµÏÖ¡£ÔÚMFCÖл¹¿ÉÒÔ²ÉÓÃÁíÒ»ÖÖ·½·¨À´ÊµÏÖ³õʼ»¯COM£¬ÕâÖÖ·½·¨Ö»ÐèÒªÒ»ÌõÓï¾ä±ã¿ÉÒÔ×Ô¶¯ÎªÎÒÃÇʵÏÖ³õʼ»¯COMºÍ½áÊøʱ¹Ø±ÕCOMµÄ²Ù×÷£¬Óï¾äÈçÏÂËùʾ£º AfxOleInit()¡£
BOOL CHighSpeedDlg::OnInitDialog()
{
CDialog::OnInitDialog();
CreateMutex(NULL,FALSE,"HighSpeed"); //±ÜÃâ³ÌÐòµÄ¶à´ÎʹÓÃ
if(GetLastError()==ERROR_ALREADY_EXISTS)
{
AfxMessageBox("¼Òôƽ̨ÒÑÆô¶¯!");
PostQuitMessage(0);
}
else
Ïà¹ØÎĵµ£º
½â¾ö°ì·¨£º
´Ó Windows µÄ“¿ªÊ¼”²Ëµ¥£¬Ö¸Ïò“³ÌÐò”¡¢ “Visual Studio .NET 2003”¡¢“Visual Studio .NET ¹¤¾ß”£¬È»ºóÑ¡Ôñ“Visual Studio .NET ÃüÁî Ìáʾ”¡£ÔÚ´°¿Ú´ò¿ªºó£¬¼üÈë aspnet_regiis /i¼´¿É¡£
²»¿ÉÐеķ½°¸£º
1¡¢ÖØÆôµçÄÔ¡£
2¡¢É¾³ý»º´æ¡£
3¡¢ÖØÐ ......
[oledb]
; Everything after this line is an OLE DB initstring
Provider=Microsoft.Jet.OLEDB.4.0;Password=ypbwkfyjhyhgzj;User ID=morningstar;Data Source=C:\Program Files\Kingdee\KIS\BZB\±±¼«ÐÇ.AIS;Persist Security Info=True;Jet OLEDB:System database=C:\Program Files\Kingdee\KIS\BZB\system.mda
......
1.´íÎóÀàÐÍ£º
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] ²Ù×÷±ØÐëʹÓÃÒ»¸ö¿É¸üеIJéѯ¡£
Õâ¸ö´íÎóÒ»°ãÖ»ÓÐÔÚʹÓÃACCESSÊý¾Ý¿âʱ²Å»á³öÏÖ¡£ÒòΪACCESSÔÚ´ò¿ªÊ±»áÉú³ÉÒ»¸öÁÙʱÎļþ.ldb£¬ÕâʱÎļþ¼ÐÈç¹ûûÓÐдÈëȨÏÞʱ£¬Ôò»á·¢Éú´íÎó¡£
½â¾ö·½·¨ÈçÏ£º
1 ......
Ò»¡¢SQL SERVER ºÍACCESSµÄÊý¾Ýµ¼Èëµ¼³ö
³£¹æµÄÊý¾Ýµ¼Èëµ¼³ö£º
ʹÓÃDTSÏòµ¼Ç¨ÒÆÄãµÄAccessÊý¾Ýµ½SQL Server£¬Äã¿ÉÒÔʹÓÃÕâЩ²½Öè:
¡¡¡¡¡ð1ÔÚSQL SERVERÆóÒµ¹ÜÀíÆ÷ÖеÄTools£¨¹¤¾ß£©²Ëµ¥ÉÏ£¬Ñ¡ÔñData Transformation
¡¡¡¡¡ð2Services£¨Êý¾Ýת»»·þÎñ£©£¬È»ºóÑ¡Ôñ czdImport Data£¨µ¼ÈëÊý¾Ý£©¡£
¡¡¡¡¡ ......