ADO ÅëÇØ Microsoft Access µ¥ÀÌÅͺ£À̽º¸¦ ¾ÐÃà ÇÏ´Â ¹æ¹ý

±â¼ú ÀÚ·á: 230501
¸ðµÎ È®´ë | ¸ðµÎ Ãà¼Ò

ÀÌ ÆäÀÌÁö¿¡¼­

¿ä¾à

ADO »ç¾ç °³Ã¼ compact Microsoft Access µ¥ÀÌÅͺ£À̽º¸¦ Á¦°ø ÇÏÁö´Â ¾ÊÁö¸¸,ÀÌ ±â´ÉÀº ADO È®ÀåÀ» »ç¿ë ÇÏ ¿© ¾òÀ» ¼ö ÀÖ½À´Ï´Ù: Microsoft Jet OLE DB °ø±ÞÀÚ ¹× º¹Á¦ °³Ã¼ (JRO). ÀÌ ±â´ÉÀº JRO ¹öÀü 2.1 (Msjro.dll) ¹× JET OLE DB °ø±ÞÀÚ ¹öÀü 4.0 (Msjetoledb40.dll)¿¡¼­ óÀ½À¸·Î ±¸Çö µÇ¾ú½À´Ï´Ù. ÀÌ·¯ÇÑ DLL ÆÄÀÏÀÇ MDAC 2.1 ¼³Ä¡ ÈÄ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ´ÙÀ½ À¥ »çÀÌÆ®¿¡¼­ MDACÀÇ ÃֽйöÀüÀ» ´Ù¿î·ÎµåÇÒ ¼ö ÀÖ½À´Ï´Ù.
¹ü¿ë µ¥ÀÌÅÍ ¾×¼¼½º À¥ »çÀÌÆ®

Ãß°¡ Á¤º¸

ADO¸¦ »ç¿ë ÇÏ ¿© Access µ¥ÀÌÅͺ£À̽º¸¦ ¾ÐÃà ÇÏ·Á¸é MDAC 2.1 ¶Ç´Â ³ªÁß¿¡ ÄÄÇ»ÅÍ¿¡ Á¦´ë·Î ¼³Ä¡ ÇØ¾ß ÇÕ´Ï´Ù. Visual Basic ¹× Visual c + +¸¦ »ç¿ë ÇÏ ¿© Microsoft Access µ¥ÀÌÅͺ£À̽º¸¦ ¾ÐÃà ÇÏ´Â ÁÖ¿ä ´Ü°è´Â ´ÙÀ½°ú °°½À´Ï´Ù.

Visual Basic: ADO ÅëÇØ Access µ¥ÀÌÅͺ£À̽º¸¦ ¾ÐÃàÇÕ´Ï´Ù.

  1. Visual Basic IDE¿¡¼­ ÇÁ·ÎÁ§Æ® ¸Þ´º¿¡¼­ ÂüÁ¶¸¦ Ŭ¸¯ ÇÕ´Ï´Ù.
  2. Microsoft Jet ¹× º¹Á¦ °³Ã¼ X.X ¶óÀ̺귯¸®¸¦Ãß°¡ÇÒ À§Ä¡ (X.X´Â º¸´Ù Å©°Å³ª 2.1).
  3. Visual Basic ÇÊ¿äÇÑ °æ¿ì µ¥ÀÌÅÍ ¿øº» ¹× ´ë»ó µ¥ÀÌÅͺ£À̽º °æ·Î ´ëü ÇÏ·Á¸é ÄÚµåÀÇ ´ÙÀ½ ÁÙÀ» Ãß°¡ ÇÕ´Ï´Ù.
    Dim jro As jro.JetEngine
    Set jro = New jro.JetEngine
    jro.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\nwind2.mdb;Jet OLEDB:Database Password=test", _ 
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\abbc2.mdb;Jet OLEDB:Engine Type=4;Jet OLEDB:Database Password=test"
    					
Âü°í: DAO 3.60¿¡¼­ °ÍÀÌ ¸Þ¼­µå´Â ´õ ÀÌ»ó »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. CompactDatabase ¸Þ¼­µå¸¦ »ç¿ë ÇÏ´Â À§ÀÇ Äڵ带 º¸¿© ÁÝ´Ï´Ù. ÀÌ ¸Þ¼­µå´Â DAO 3.5 °Í ¸Þ¼­µå¸¦ ´ëüÇÕ´Ï´Ù.

Visual c + +: ADO ÅëÇØ Access µ¥ÀÌÅͺ£À̽º¸¦ ¾ÐÃàÇÕ´Ï´Ù.

  1. ´ÙÀ½ # import ¹®Àº Ŭ·¡½º.cppÀ» JRO¿¡ ´ë ÇÑ ·¡ÆÛ Ŭ·¡½º¸¦ »ý¼ºÇÒ Msado15.dll (MDAC2.1) # import ¿Ü¿¡ Ãß°¡ (¶Ç´Â »ç¿ë ÇÏ´Â ·¡ÆÛ Ŭ·¡½º º¸´Ù È¿À²ÀûÀ¸·Î # import Àü󸮱⠹®ÀÇ no_implementation ¹× implementation_only Ư¼ºÀ» »ç¿ë ÇÏ ¿© »ý¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù):
    #import "C:\PROGRAM FILES\COMMON FILES\System\ado\MSJRO.DLL" no_namespace 
    					
  2. ´ÙÀ½ Ãß°¡ (»ç¿ëÀÚ °íÀ¯ÀÇ ¿øº» ¹× ´ë»ó µ¥ÀÌÅͺ£À̽º °æ·Î ÁöÁ¤) µ¥ÀÌÅͺ£À̽º¸¦ ¾ÐÃà ÇÏ·Á¸é.cpp ÆÄÀÏ:
    ...
    try
    {
       IJetEnginePtr jet(__uuidof(JetEngine));
      jet->CompactDatabase( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\nwind2.mdb;Jet OLEDB:Database Password=test", 
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\abbc.mdb;" \ 
    "Jet OLEDB:Engine Type=4;Jet OLEDB:Database Password=test");
    }
    catch(_com_error &e) 
    {       
       ::MessageBox(NULL, (LPCTSTR)e.Description( ), "", MB_OK) ;    
    }
    					
Âü°í: Jet OLEDB:Engine À¯Çü = 4¸¸ Jet 3.x Çü½Ä MDB ÆÄÀÏÀÔ´Ï´Ù. ÀÌ °ªÀ» µÎ¸é 4.0 ¹öÀüÀ¸·Î ÀÚµ¿À¸·Î µ¥ÀÌÅͺ£À̽º¸¦ ¾÷±×·¹À̵å (Jet OLEDB:Engine À¯Çü = 5). Jet OLEDB:Engine Çü½Ä¿¡ ´ë ÇÑ ÀûÀý ÇÑ °ª¿¡ ´ë ÇÑ ´ÙÀ½ Ç¥¸¦ ÂüÁ¶ ÇϽʽÿÀ.
Ç¥ Ãà¼ÒÇ¥ È®´ë
Jet OLEDB:Engine Çü½ÄÀÔ´Ï´Ù.Jet x.x MDB ÆÄÀÏ Çü½Ä
1JET10
2JET11
3JET2X
4JET3X
5JET4X

ÂüÁ¶

ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½À» ÂüÁ¶ ÇϽʽÿÀ Microsoft ±â¼ú ÀÚ·á ¹®¼­:
230496 OLE DB¸¦ ÅëÇØ Microsoft Access µ¥ÀÌÅͺ£À̽º ¾ÐÃà

¼Ó¼º

±â¼ú ÀÚ·á: 230501 - ¸¶Áö¸· °ËÅä: 2012³â 5¿ù 16ÀÏ ¼ö¿äÀÏ - ¼öÁ¤: 1.0
Ű¿öµå:?
kbhowto kbjet kbprovider kbmt KB230501 KbMtko
±â°è ¹ø¿ªµÈ ¹®¼­
Áß¿ä: º» ¹®¼­´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼­ ¹× ±â°è ¹ø¿ªµÈ ¹®¼­¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼­¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼­°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼­ ±â°è ¹ø¿ª ¹®¼­¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®Çϰí ÀÖ½À´Ï´Ù.
ÀÌ ¹®¼­ÀÇ ¿µ¹® ¹öÀü º¸±â:230501
´õ ÀÌ»ó Áö¿øµÇÁö ¾Ê´Â Á¦Ç°ÀÇ KB ³»¿ë¿¡ ´ëÇÑ °íÁö »çÇ×
ÀÌ ¹®¼­¿¡¼­´Â Microsoft¿¡¼­ ´õ ÀÌ»ó Áö¿øÇÏÁö ¾Ê´Â Á¦Ç°¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù. µû¶ó¼­ ÀÌ ¹®¼­´Â "ÀÖ´Â ±×´ë·Î" Á¦°øµÇ¸ç ¾÷µ¥ÀÌÆ®µÇÁö ¾Ê½À´Ï´Ù.

Çǵå¹é º¸³»±â