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

mysql:1880

From: Kengo Jinno <Kengo Jinno <kengo@xxxxxxxxxx>>
Date: Wed, 12 Apr 2000 11:19:46 +0900
Subject: [mysql 01880] Re: Access ¤«¤é¤Î¥¨¥¯¥¹¥Ý¡¼¥È¥¨¥é¡¼

¿ÀÌî¤Ç¤¹¡£

ľÀÜ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(?)¤ò
»È¤¦¤³¤È¤Ë¤Ê¤ë¤È»×¤¤¤Þ¤¹¡£
¤½¤³¤Ç´°Á´¤Ë¼êÂǤÁ¤¹¤ë¤Î¤ÏÌÌÅÝ(¥¨¥Ç¥£¥Ã¥Èµ¡Ç½¤¬Éϼå¤À¤í¤¦¤·)
¤Ç¤¹¤¬¡¢Â¾¤Ë¥¨¥Ç¥£¥¿¤ò³«¤¤¤Æ¤½¤³¤«¤é¥³¥Ô¡¼¡õ¥Ú¡¼¥¹¥È¤¹¤ì¤Ð
¤É¤¦¤Ç¤·¤ç¤¦¡©

> ¥Æ¡¼¥Ö¥ë¤ÏTest1¤È¸À¤¦Ì¾Á°¤Ç
> Name¤È¸À¤¦¥Õ¥£¡¼¥ë¥É¤¬¥Æ¥­¥¹¥È·¿¤Ç¼ç¥­¡¼¡£¤½¤ì¤Î¤ß¡£
> ¥Ç¡¼¥¿¤Ï¤¢¤ê¤Þ¤»¤ó¡£

¤³¤ì¤À¤Ã¤Æ¡¢
¡Öcreate table Test1 ( Name char(255) not null, primary key (Name) );¡×
¤È´Êñ¤Ë¸À¤¨¤Þ¤¹¤·¡£

> ¥Æ¡¼¥Ö¥ë¤ò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¥Ç¡¼¥¿¥½¡¼¥¹¤ÎÀßÄ꤬°ã¤¦¤È¤«¡£

-----------------------------
¿ÀÌî·ò¸ã <kengo@xxxxxxxxxx>


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

      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 ¶áÆ£¿]