[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

mysql:1881

From: Hirotaka Kondo ¶áÆ£¿Òδ <Hirotaka Kondo ¶áÆ£¿Òδ <hiro@xxxxxxxxxx>>
Date: Wed, 12 Apr 2000 20:20:19 +1000
Subject: [mysql 01881] Re: Access ¤«¤é¤Î¥¨¥¯¥¹¥Ý¡¼¥È¥¨¥é¡¼

On Wed, 12 Apr 2000 11:19:46 +0900
Kengo Jinno <kengo@xxxxxxxxxx> wrote:

>¿ÀÌî¤Ç¤¹¡£

¤Û¤ª¤¯¡Ä¤È°ì±þ̾¾è¤Ã¤Æ¤¤¤ë¤Î¤Ç¤¹¤¬¡¢ËÜ̾¤ÎÊý¤¬¤è¤¤¤«¤Ê¡Ä
¶áÆ£¤È¸À¤¤¤Þ¤¹¡£

>ľÀÜAccess¤Ï»È¤Ã¤Æ¤Ê¤¤¤Î¤Ç¤¹¤¬¡¢Ê̤μԤ¬Ã´Åö¤·¤Æ¤Þ¤¹¡£
>¡ô»ä¤Ï¡¢MyODBC+MS-VC

ôÅö¤¬°ã¤¦¤Î¤Ë¡¢¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£

>Tue, 11 Apr 2000 23:16:30 +1000 ¤´¤í¤Ë
><38F325AE32A.450FHIRO@xxxxxxxxxx> ¤Î
>"[mysql 01879] Access ¤«¤é¤Î¥¨¥¯¥¹¥Ý¡¼¥È¥¨¥é¡¼" ¤Î¥á¡¼¥ë¤Ç
>Hirotaka Kondo ¶áÆ£¿Òδ <hiro@xxxxxxxxxx> ¤µ¤ó¤Ï½ñ¤­¤Þ¤·¤¿¡£
>>¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÀ߷פ¬¥³¥ó¥½¡¼¥ë¤Ç¤ÏÌÌÅݤΤ¿¤á¡¢Access¤Ç´ðÁäòºî¤í¤¦¤È¥È¥é
>>¥¤¤·¤è¤¦¤È¤·¤Æ¤¤¤ë¤Î¤Ç¤¹¤¬¡¢¤¦¤Þ¤¯¤¤¤­¤Þ¤»¤ó¡£
>¥³¥ó¥½¡¼¥ë¤ÇSQLʸ»È¤Ã¤¿Êý¤¬¤¤¤¤¤È»×¤¤¤Þ¤¹¤è¡£
>¥µ¡¼¥Ð¡¼¤âWin32¤Ê¤ó¤Ç¤¹¤Í¡©¡¡¤È¤Ê¤ë¤È¡¢DOSÁ볫¤¤¤Æmysql.exe(?)¤ò
>»È¤¦¤³¤È¤Ë¤Ê¤ë¤È»×¤¤¤Þ¤¹¡£
>¤½¤³¤Ç´°Á´¤Ë¼êÂǤÁ¤¹¤ë¤Î¤ÏÌÌÅÝ(¥¨¥Ç¥£¥Ã¥Èµ¡Ç½¤¬Éϼå¤À¤í¤¦¤·)
>¤Ç¤¹¤¬¡¢Â¾¤Ë¥¨¥Ç¥£¥¿¤ò³«¤¤¤Æ¤½¤³¤«¤é¥³¥Ô¡¼¡õ¥Ú¡¼¥¹¥È¤¹¤ì¤Ð
>¤É¤¦¤Ç¤·¤ç¤¦¡©

¤Ê¤ë¤Û¤É¡Ä¤½¤¦¤¤¤¦¼ê¤â¤¢¤ê¤Þ¤¹¤Í¡£
Access¤Ç¤â¡¢·ë¶ÉExport¤Ç¤¹¤·¡Ä

>>¥Æ¡¼¥Ö¥ë¤òAccess¤ÇºîÀ®¤·¡¢¤¤¤¶¥¨¥¯¥¹¥Ý¡¼¥È¤·¤è¤¦¤È¤¹¤ë¤È¡¢
>>>ODBC-¸Æ¤Ó½Ð¤·¤¬¼ºÇÔ¤·¤Þ¤·¤¿¡£
>>>[Microsoft][ODBC Driver Manager] ¾ðÊó¥Ç¡¼¥¿·¿¤¬Í­¸úÈϰϤˤ¢¤ê¤Þ¤»¤ó¡£(#0)
>>¤È¸À¤¦¥¨¥é¡¼¤¬½Ð¤Æ¡¢¤½¤ì°Ê¾åÀè¤Ë¿Ê¤ß¤Þ¤»¤ó¡£
>>ODBC¤Î¥Ø¥ë¥×¤¬¸«¤¢¤¿¤é¤Ê¤¤¤¿¤á¡¢°ÕÌ£¤¬¤è¤¯Ê¬¤«¤ê¤Þ¤»¤ó¡£
>>¥Ç¡¼¥¿·¿¤È¸À¤Ã¤Æ¤â¡¢¥Æ¥¹¥È¤Ê¤Î¤Ç¡¢¥Æ¥­¥¹¥È·¿°ì¤Ä¤Î¤ß¤Î´Êñ¤Ê¥Æ¡¼¥Ö¥ë¤ÇÃí
>>°Õ½ñ¤­¤Ç¤¢¤Ã¤¿¤è¤¦¤Ë¡¢¼ç¥­¡¼¤â»ØÄꤷ¤Æ¤¤¤Þ¤¹¡£
>¤½¤Î¥á¥Ã¥»¡¼¥¸¤Ïʬ¤«¤ê¤Þ¤»¤ó¡£
>¤Þ¤º¡¢create table¤·¤Æ¤¤¤ë¤È»×¤¦¤Î¤Ç¤¹¤¬¡¢¼ç¥­¡¼Name¤Ï
>¡ÖNULLÉԲġפËÀßÄꤵ¤ì¤Æ¤¤¤ë¤Ç¤·¤ç¤¦¤«¡©
>¥µ¡¼¥Ð¡¼¤âMyODBC¤â»ä¤¬»È¤Ã¤Æ¤¤¤ë¤Î¤È¥Ð¡¼¥¸¥ç¥ó¤¬°ã¤¤¤Þ¤¹¤¬¡¢
>MySQL¤Ç¤Ï¥­¡¼¤ÏNULLÉԲĤǤʤ¤¤È¤¤¤±¤Þ¤»¤ó¡£
>¡ôAccess¤Ç¤Ï¡¢NULL²Ä¤Î¥Õ¥£¡¼¥ë¥É¤ò¥­¡¼¤Ë¤Ç¤­¤¿¤È»×¤¤¤Þ¤¹¡£

¤½¤Î¤è¤¦¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤·¤¿

>¤µ¤é¤Ë¾Ü¤·¤¤¤³¤È¤Ï¡¢MyODBC¤«¤é¥Ç¥Ð¥Ã¥°¥í¥°¤ò½ÐÎϤµ¤»¤Æ¤ß¤Æ¡¢
>¼ÂºÝ¤Ë²¿¤ò¹Ô¤Ê¤ª¤¦¤È¤·¤Æ¥¨¥é¡¼¤Ë¤Ê¤Ã¤Æ¤¤¤ë¤Î¤«³Î¤«¤á¤ëɬÍפ¬
>¤¢¤ë¤È»×¤¤¤Þ¤¹¡£
>AUTOEXEC.BAT¤Ë
>set MYSQL_DEBUG=d:t:O,c::\myodbc.log
>¤òÄɲ䷤ƺƵ¯Æ°¤¹¤ë¤È¡¢c:\myodbc.log¤Ë¥í¥°¤¬½ñ¤­½Ð¤µ¤ì¤Þ¤¹¡£
>¡ôODBC¥Ç¡¼¥¿¥½¡¼¥¹¤ÎOptions¤Ç4¤òÄɲ乤ë¤Î¤ÈƱ¤¸¡£
>¥Ð¡¼¥¸¥ç¥ó¤¬°ã¤¦¤È°ã¤¦¤«¤â¤·¤ì¤Þ¤»¤ó¤Î¤Ç¡¢MyODBC¤Îreadme¤Ç
>³Îǧ¤·¤Æ¤¯¤À¤µ¤¤¡£
>¤â¤·¤«¤·¤¿¤é¡¢MyODBC¤ËÅþ㤹¤ëÁ°¤Ë¥¨¥é¡¼¤Ë¤Ê¤Ã¤Æ¤¤¤ë¤«¤â
>¤·¤ì¤Þ¤»¤ó¤·¡£
>¡ôODBC¥Ç¡¼¥¿¥½¡¼¥¹¤ÎÀßÄ꤬°ã¤¦¤È¤«¡£

¥¢¥É¥Ð¥¤¥¹¤Ë½¾¤¤¥í¥°¤òºî¤Ã¤Æ¡¢¸Æ¤ó¤Ç¤ß¤Þ¤·¤¿¡£

´ò¤·¤¤¤³¤È¤Ë
ºîÀ®¤Ë¼ºÇÔ¤¹¤ë¸¶°ø¤¬¤ï¤«¤ê¤Þ¤·¤¿¡£

¤·¤«¤·¡¢¥¨¥é¡¼¤¬µ¯¤³¤ë¸¶°ø¤¬Ê¬¤«¤ê¤Þ¤»¤ó¤Ç¤·¤¿¡Ê¡¨¡²¡¨¡Ë

¡äCREATE TABLE Test (Name varchar(50))
¤³¤ì¤¬ODBC¤¬Àµ¾ï¤ËÆ°ºî¤·¤Æ¤¤¤ëʸ¤Ç¡¢¤³¤ì¤ÈƱ¤¸¥Æ¡¼¥Ö¥ë¤òAccess¤ÇExport¤·
¤è¤¦¤È¤¹¤ë¤È¡¢¤Ê¤¼¤À¤«Ê¬¤«¤ê¤Þ¤»¤ó¤¬¡¢

>CREATE TABLE  ( varchar(50))
¤È¤Ê¤Ã¤Æ¤¤¤ë¤³¤È¤¬Ê¬¤«¤ê¤Þ¤·¤¿¡£¥Æ¡¼¥Ö¥ë̾¤È¥Õ¥£¡¼¥ë¥É̾¤¬Æþ¤Ã¤Æ¤¤¤Þ¤»¤ó¡£
¤³¤¦¤Ê¤ëÍýͳ¤¬Á´¤¯Ê¬¤«¤ê¤Þ¤»¤ó¡£

²¿¤«ÀßÄ꤬´Ö°ã¤Ã¤Æ¤¤¤ë¤Î¤Ç¤·¤ç¤¦¤«(¡©_¡©)

---------------------------------------
Hirotaka Kondo ¶áÆ£¿Òδ  IRC:#!Silver-Forest
hiro@xxxxxxxxxx UIN:10034131
http://www.silver-forest.com/

[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

      1879 2000-04-11 22:16 [Hirotaka Kondo ¶áÆ£¿] Access ¤«¤é¤Î¥¨¥¯¥¹¥Ý¡¼¥È¥¨¥é¡¼         
      1880 2000-04-12 11:19 ¨±[Kengo Jinno <kengo@x]                                       
->    1881 2000-04-12 19:20 ¡¡¨±[Hirotaka Kondo ¶áÆ£¿]                                     
      1882 2000-04-12 21:56 ¡¡¡¡¨±[Kengo Jinno <kengo@x]                                   
      1883 2000-04-14 19:45 ¡¡¡¡¡¡¨±[Hirotaka Kondo ¶áÆ£¿]