mysql.data.dllÊÇMySQL¹Ù·½ADO.NETÊý¾ÝÇý¶¯ºËÐÄ×é¼þ£¬Ö÷ÒªÓÃÓÚ.NET³ÌÐò¶Ô½ÓMySQLÊý¾Ý¿â£¬¹ã·ºÓ¦ÓÃÓÚ¸÷ÀàÓÎÏ··þÎñ¶Ë¡¢ºǫ́³ÌÐò¿ª·¢²¿Ê𳡾°£¬ÄæË®º®·þÎñ¶Ë³ÌÐòÔËÐйý³ÌÖУ¬¸ß¶ÈÒÀÀµ¸Ã¶¯Ì¬Á´½Ó¿âÍê³ÉÊý¾Ý¿â¶Áд¡¢Êý¾Ýͬ²½¡¢ÅäÖüÓÔØµÈºËÐIJÙ×÷¡£¶àÊý²¿Ê𳡾°ÖУ¬¿ª·¢Õß»áÓöµ½Windowsϵͳע²áÕý³£¡¢Linuxϵͳ²¿Êð±¨´í¡¢×é¼þ¼ÓÔØÊ§°Ü¡¢³ÌÐòÎÞ·¨Æô¶¯¡¢Êý¾Ý¿âÁ¬½ÓÖжϵÈÎÊÌ⣬ºËÐÄÔ´ÓÚÁ½´óϵͳ¶Ôdll×é¼þµÄÔËÐлúÖÆ¡¢×¢²á¹æÔò¡¢ÒÀÀµ»·¾³´æÔÚ±¾ÖʲîÒì¡£±¾ÎÄÈ«Ãæ²ð½âmysql.data.dllÔÚWindows¡¢LinuxϵͳϵÄ×¢²á²¿ÊðÂß¼¡¢³£¼û±¨´í³ÉÒò¡¢²îÒ컯²¿Êð·½°¸Óë±ê×¼»¯Â䵨Á÷³Ì£¬½â¾ö¿çϵͳÊÊÅä¹ÊÕÏ¡£
Ò»¡¢mysql.data.dllºËÐÄÔËÐлúÖÆÓë¿çϵͳ²¿Êð±¾ÖʲîÒì
mysql.data.dllÊôÓÚ.NETƽ̨ÍйÜÀද̬Á´½Ó¿â£¬ÔÉúÊÊÅäWindowsϵͳÔËÐмܹ¹£¬ÒÀÍÐWindows×¢²á±í¡¢COM×é¼þ»úÖÆ¡¢.NET FrameworkÔËÐл·¾³Íê³É×¢²áÓë¼ÓÔØ£¬ÊÇWindowsƽ̨.NET³ÌÐò¶Ô½ÓMySQLµÄ±ê×¼×é¼þ¡£ÔÚWindowsϵͳÖУ¬¸Ã×é¼þÖ§³ÖÊÖ¶¯×¢²á¡¢È«¾ÖÒýÓá¢ÏîÄ¿ÄÚǶµ÷ÓÃÁ½ÖÖÔËÐÐģʽ£¬¼æÈÝÐÔÎȶ¨£¬ÊÊÅä¸÷Àà.NET°æ±¾ÓëÊý¾Ý¿âÔËÐл·¾³¡£
LinuxϵͳÎÞÔÉúdll×é¼þ×¢²á»úÖÆ£¬²»Ö§³ÖWindowsÌåϵµÄCOM×¢²á¡¢×¢²á±í¹ÒÔØÔËÐÐģʽ£¬ÕâÒ²ÊÇLinux²¿Êðmysql.data.dllƵ·±±¨´íµÄºËÐÄÔÒò¡£LinuxϵͳÔËÐÐÒÀÀµ.NET Core¡¢.NET¿çƽ̨ÔËÐÐʱ£¬ÞðÆú´«Í³dll×¢²áÂß¼£¬ÒÔ×é¼þÒýÓá¢ÒÀÀµ°ü¹ÒÔØµÄ·½Ê½Íê³É¼ÓÔØ£¬Ö±½ÓÌ×ÓÃWindows×¢²á²¿Êð·½Ê½»á³öÏÖ×é¼þ²»Ê¶±ð¡¢¼ÓÔØÊ§°Ü¡¢È¨ÏÞ±¨´í¡¢³ÌÐòÉÁÍ˵ÈÎÊÌâ¡£
ÄæË®º®·þÎñ¶Ë³ÌÐò¿çϵͳ²¿Êðʱ£¬Êý¾Ý¿â½»»¥Ä£¿éÍêÈ«ÒÀÍÐmysql.data.dllÇý¶¯£¬×é¼þ²¿ÊðÒì³£»áÖ±½Óµ¼Ö·þÎñ¶ËÊý¾Ý³õʼ»¯Ê§°Ü¡¢½ÇÉ«Êý¾Ý¶ÁÈ¡Òì³£¡¢·þÎñÆ÷µÇ¼УÑéʧЧ¡¢Íæ·¨ÅäÖüÓÔØ²»È«µÈ¹ÊÕÏ£¬Òò´ËÐèÒª¸ù¾Ý²Ù×÷ϵͳÊÊÅä¶ÔÓ¦µÄ²¿Êð×¢²á·½°¸£¬²»ÄÜͨÓÃÒ»Ìײ¿ÊðÂß¼¡£
¶þ¡¢Windowsϵͳmysql.data.dll±ê×¼×¢²áÓ벿ÊðÁ÷³Ì
WindowsϵͳÍêÕûÖ§³Ömysql.data.dll×¢²á²¿Ê𣬷ÖΪϵͳȫ¾Ö×¢²á¡¢ÏîÄ¿±¾µØÒýÓÃÁ½ÖÖ·½Ê½£¬ÊÊÅäÄæË®º®·þÎñ¶Ë±¾µØµ÷ÊÔ¡¢Windows·þÎñÆ÷²¿Ê𳡾°£¬Á½ÖÖ·½Ê½¾ù¿ÉÎȶ¨ÊµÏÖÊý¾Ý¿âÕý³£¶Ô½Ó¡£
ϵͳȫ¾Ö×¢²áÊÊÓÃÓÚ¶àÏîÄ¿¹²ÓÃ×é¼þ¡¢·þÎñÆ÷È«¾ÖÊÊÅ䳡¾°¡£Ê×ÏÈÈ·ÈÏϵͳƥÅäµÄ×é¼þ°æ±¾£¬Çø·Ö32λÓë64λmysql.data.dll£¬¸ù¾ÝϵͳλÊýÑ¡Ôñ¶ÔÓ¦Îļþ£¬±ÜÃâλÊý²»Æ¥Åäµ¼ÖµÄ×¢²áʧ°Ü¡£½«¶ÔÓ¦°æ±¾µÄmysql.data.dll·ÅÖÃÔÚϵͳָ¶¨Ä¿Â¼£¬64λϵͳ·ÅÖÃÓÚSystem32Îļþ¼Ð£¬32λ×é¼þ·ÅÖÃÓÚSysWOW64Îļþ¼Ð¡£
´ò¿ª¹ÜÀíԱȨÏÞÃüÁîÌáʾ·û£¬Ö´ÐÐ×é¼þ×¢²áÖ¸Áͨ¹ýregsvr32¹¤¾ßÍê³Édll×é¼þ×¢²á±í¹ÒÔØÓëϵͳʶ±ð¡£Ö¸ÁîÖ´Ðгɹ¦ºó£¬ÏµÍ³»áÌáʾע²á³É¹¦µ¯´°£¬´Ëʱϵͳȫ¾Ö»·¾³ÒѼÓÔØMySQLÊý¾ÝÇý¶¯£¬ËùÓÐ.NET³ÌÐò¾ù¿Éµ÷ÓøÃ×é¼þÍê³ÉÊý¾Ý¿âÁ¬½Ó¡£×¢²áÍê³Éºó£¬ÖØÆôÄæË®º®·þÎñ¶Ë³ÌÐò£¬¼´¿ÉÕý³£¶ÁÈ¡Êý¾Ý¿âÅäÖá¢Íê³ÉÊý¾Ý½»»¥¡£
ÏîÄ¿±¾µØÒýÓò¿ÊðÎÞÐèϵͳȫ¾Ö×¢²á£¬ÊÊÅäµ¥ÏîÄ¿¶ÀÁ¢²¿ÊðÐèÇó¡£Ö±½ÓÔÚVisual Studio»ò·þÎñ¶ËÏîÄ¿ÅäÖÃÎļþÖУ¬ÊÖ¶¯Ìí¼Ómysql.data.dllÒýÓã¬Ö¸¶¨×é¼þ±¾µØÂ·¾¶£¬ÅäÖÃÏîÄ¿ÒÀÀµ°æ±¾£¬Ëø¶¨×é¼þµ÷ÓÃÓÅÏȼ¶¡£¸Ã·½Ê½²»ÐÞ¸Äϵͳע²á±í£¬½öÕë¶Ôµ±Ç°ÏîÄ¿ÉúЧ£¬²¿ÊðÎȶ¨ÐÔ¸ü¸ß£¬²»»á³öÏÖ¶à°æ±¾×é¼þ³åÍ»ÎÊÌ⣬ÊʺÏÄæË®º®·þÎñ¶Ë¶¨ÖÆ»¯²¿Ê𳡾°¡£
Windowsϵͳ²¿Êð³£¼ûÎÊÌ⼯ÖÐÔÚ°æ±¾²»¼æÈÝ¡¢È¨ÏÞ²»×ã¡¢×é¼þËð»µÈýÀà¡£ÀϾÉ.NET Framework°æ±¾ÎÞ·¨ÊÊÅä¸ß°æ±¾mysql.data.dll£¬»á³öÏÖ¼ÓÔØÊ§°Ü£»·Ç¹ÜÀíԱȨÏÞÖ´ÐÐ×¢²áÖ¸Á»áÌáʾȨÏ޾ܾø£»×é¼þ´«Êä¹ý³ÌÖÐÎļþË𻵡¢È±Ê§£¬»áµ¼ÖÂ×¢²áÖ¸ÁîÖ´ÐÐʧЧ£¬¶ÔÓ¦Ìæ»»ÊÊÅä°æ±¾¡¢¿ªÆô¹ÜÀíԱȨÏÞ¡¢ÖØÐ»ñÈ¡ÍêÕû×é¼þ°ü¼´¿É½â¾ö¡£
Èý¡¢Linuxϵͳmysql.data.dll²¿ÊðºËÐÄÎÊÌâÓëÕýÈ··½°¸
Linuxϵͳ²»´æÔÚdll×é¼þ×¢²á¸ÅÄregsvr32×¢²áÖ¸ÁîÎÞ·¨Ê¶±ð¡¢ÎÞ×¢²á±í¹ÒÔØÇþµÀ£¬Ç¿ÐÐÑØÓÃWindows×¢²á·½Ê½»áÖ±½Ó±¨´í£¬ÕâÊÇ¿çϵͳ²¿ÊðµÄºËÐÄÎóÇø¡£ÄæË®º®·þÎñ¶Ë²¿ÊðÔÚLinux·þÎñÆ÷ʱ£¬±ØÐëÞðÆú´«Í³×¢²áÂß¼£¬ÒÀÍÐ.NET¿çƽ̨ÔËÐÐʱÍê³É×é¼þ¼ÓÔØÓëÊÊÅä¡£
Linuxϵͳ²¿ÊðǰÖÃÌõ¼þΪ°²×°ÊÊÅä°æ±¾µÄ.NET Core»ò.NETÔËÐÐʱ»·¾³£¬ÏµÍ³È±ÉÙ¶ÔÓ¦ÔËÐÐÒÀÀµÊÇ×é¼þ¼ÓÔØÊ§°ÜµÄÖ÷ÒªÓÕÒò¡£Í¨¹ýϵͳ°ü¹ÜÀíÆ÷°²×°ÍêÕû.NETÔËÐл·¾³£¬°üº¬»ù´¡ÔËÐп⡢Êý¾Ý¿â½»»¥ÒÀÀµ¡¢¿çƽ̨¼æÈÝ×é¼þ£¬È·±£¾ß±¸ÍйÜdllÎļþµÄÔËÐлù´¡¡£»·¾³°²×°Íê³Éºó£¬ÎÞÐè×¢²ámysql.data.dll£¬½öÐ轫×é¼þÎļþ·ÅÖÃÔÚ·þÎñ¶Ë³ÌÐòÔËÐиùĿ¼£¬Óë³ÌÐò¿ÉÖ´ÐÐÎļþͬ¼¶´æ·Å¡£
ͨ¹ýNuGet°üÊÊÅ䲿ÊðΪLinux×îÓÅ·½°¸£¬³¹µ×¹æ±ÜÊÖ¶¯²¿ÊðµÄ¼æÈÝÎÊÌâ¡£ÔÚLinux·þÎñ¶ËÏîÄ¿ÖУ¬ÔÚÏß°²×°MySQL¹Ù·½Connector/NETÒÀÀµ°ü£¬°²×°Íê³Éºóϵͳ»á×Ô¶¯ÊÊÅäÉú³É¶ÔÓ¦mysql.data.dll×é¼þ£¬×Ô¶¯Æ¥Åä.NETÔËÐа汾ÓëLinuxϵͳ¼Ü¹¹£¬ÎÞÐèÊÖ¶¯¸´ÖÆ¡¢×¢²á¡¢ÅäÖã¬×é¼þ¼æÈÝÐÔ¡¢Îȶ¨ÐÔÔ¶³¬ÊÖ¶¯²¿Êð£¬ÊÊÅäÄæË®º®·þÎñ¶Ë³¤ÆÚÔËÐÐÐèÇó¡£
LinuxϵͳÊÖ¶¯²¿ÊðÐèÒªÅäÖÃÎļþȨÏÞÓëÔËÐвÎÊý£¬·ÅÖÃ×é¼þºó¸³ÓèÎļþ¶ÁдִÐÐȨÏÞ£¬±ÜÃâȨÏÞ²»×ãµ¼ÖµÄ×é¼þ¼ÓÔØÀ¹½Ø¡£Í¬Ê±Ð޸ijÌÐòÔËÐÐÅäÖ㬹رÕϵͳCOM×é¼þУÑé¡¢×¢²á±íÒÀÀµ¼ì²â£¬ÊÊÅäLinuxÎÞ×¢²á»úÖÆµÄÔËÐÐÂß¼£¬·ÀÖ¹³ÌÐòÆô¶¯Ê±Ð£ÑéWindows×¢²á¹æÔòÒý·¢ÉÁÍË¡¢±¨´í¡£
Linux²¿Êð¸ßƵ±¨´í°üº¬×é¼þ¼Ü¹¹²»Æ¥Åä¡¢ÔËÐÐʱȱʧ¡¢Â·¾¶ÖÐÎĿոñÈýÀ࣬64λLinuxϵͳÎÞ·¨¼æÈÝ32λdll×é¼þ£¬È±ÉÙ.NETÔËÐÐʱ»áÖ±½ÓÌø¹ý×é¼þ¼ÓÔØ£¬Îļþ·¾¶´æÔÚÌØÊâ×Ö·û»áµ¼ÖÂ×é¼þѰַʧ°Ü£¬Í³Ò»Ìæ»»¶ÔÓ¦¼Ü¹¹×é¼þ¡¢²¹È«ÔËÐл·¾³¡¢¹æ·¶´æ·Å·¾¶¼´¿É³¹µ×ÐÞ¸´¡£
ËÄ¡¢ÄæË®º®¿çϵͳ²¿Êðmysql.data.dllÊÊÅäÒªµã
ÄæË®º®·þÎñ¶Ë³ÌÐò¶Ômysql.data.dll×é¼þ°æ±¾Óй̶¨ÊÊÅäÒªÇó£¬Ð¾ɰ汾×é¼þ´æÔÚº¯Êý½Ó¿Ú²îÒì£¬ËæÒâÌæ»»°æ±¾»áµ¼ÖÂÊý¾Ý¿â¶Áд½Ó¿Ú²»Æ¥Å䣬³öÏÖ½ÇÉ«Êý¾Ý¼ÓÔØÊ§°Ü¡¢ÅäÖöÁÈ¡Òì³£¡¢·þÎñÆ÷¶Ë¿Ú°ó¶¨Ê§Ð§µÈÎÊÌâ¡£WindowsÓëLinux²¿ÊðÐèͳһ×é¼þ°æ±¾£¬½öÊÊÅ䲿Êð·½Ê½£¬²»ËæÒâ¸ü»»×é¼þ°æ±¾£¬±£Ö¤¿çϵͳÊý¾Ý½»»¥Âß¼Ò»Ö¡£
Windows·þÎñÆ÷ÓÅÏȲÉÓÃÏîÄ¿±¾µØÒýÓÃģʽ£¬¹æ±Üϵͳȫ¾Ö¶à°æ±¾³åÍ»£¬±£Ö¤·þÎñ¶Ë³ÌÐò¶ÀÁ¢µ÷ÓÃרÊô×é¼þ£¬²»ÊÜϵͳÆäËûÏîÄ¿×é¼þÓ°Ïì¡£Linux·þÎñÆ÷ÓÅÏȲÉÓÃNuGet×Ô¶¯²¿Êðģʽ£¬ÒÀÍйٷ½ÊÊÅä°ü½â¾ö¿çƽ̨¼æÈÝÎÊÌ⣬ÎÞÐèÈ˹¤¸ÉԤע²áÓëÊÊÅ䣬½µµÍ²¿Êð¹ÊÕϸÅÂÊ¡£
¿çÏµÍ³Ç¨ÒÆ²¿Êðʱ£¬½ûÖ¹Ö±½Ó¸´ÖÆWindows×¢²áºóµÄ×é¼þÅäÖÃÎļþ£¬LinuxÎÞ·¨Ê¶±ð×¢²á±íÅäÖÃÓëCOM×é¼þ²ÎÊý£¬Ö±½ÓÇ¨ÒÆ»áµ¼Ö³ÌÐòÆô¶¯Òì³£¡£Ç¨Òƹý³Ì½ö±£Áô´¿¾»dll×é¼þÎļþ£¬ÖØÐÂÊÊÅä¶ÔӦϵͳµÄ²¿Êð¹æÔòÓëÔËÐл·¾³£¬ÖØÖÃÒÀÀµÅäÖá£
Îå¡¢¿çϵͳ²¿Êð³£¼û±¨´í»ã×ÜÓ뾫׼½â¾ö·½Ê½
WindowsϵͳÌáʾ“×¢²áʧ°Ü£¬ÕÒ²»µ½Èë¿Úµã”£¬³ÉÒòÊÇ×é¼þ°æ±¾ÓëϵͳλÊý¡¢.NET°æ±¾²»Æ¥Å䣬½â¾ö·½Ê½ÎªÌæ»»¶ÔӦλÊý¡¢¶ÔÓ¦¿ò¼ÜÊÊÅä°æ±¾µÄmysql.data.dll£¬ÖØÐÂÖ´ÐÐ×¢²áÖ¸Áî¡£
Windows³ÌÐòÆô¶¯Ìáʾ“δÄܼÓÔØÎļþ»ò³ÌÐò¼¯”£¬³ÉÒòÊÇ×é¼þÎļþË𻵡¢ÒÀÀµ¿âȱʧ£¬½â¾ö·½Ê½ÎªÖØÐ»ñÈ¡ÍêÕû×é¼þ£¬²¹È«.NET FrameworkÔËÐÐÒÀÀµ£¬ÇåÀíÎÞЧע²á±í²ÐÁôºóÖØÐ²¿Êð¡£
LinuxϵͳÌáʾ“ÎÞЧµÄWin32¿ÉÖ´ÐÐÎļþ”£¬³ÉÒòÊÇÖ´ÐÐWindows×¢²áÖ¸Áî»òÇ¿ÐмÓÔØ×¢²á±í»úÖÆ£¬½â¾ö·½Ê½Îª·ÅÆú×¢²á²Ù×÷£¬°²×°.NET¿çƽ̨ÔËÐÐʱ£¬Í¨¹ýNuGetÖØÐÂÊÊÅä×é¼þ¡£
Linux³ÌÐòÆô¶¯Êý¾Ý¿âÁ¬½Óʧ°Ü£¬³ÉÒòÊÇ×é¼þȨÏÞ²»×㡢·¾¶´íÎó¡¢ÔËÐÐʱȱʧ£¬½â¾ö·½Ê½Îª¸³Óè×é¼þÍêÕûÔËÐÐȨÏÞ£¬µ÷ÕûÎļþÖÁ³ÌÐò¸ùĿ¼£¬²¹È«È«Ì×.NETÔËÐÐÒÀÀµ¡£
Áù¡¢±ê×¼»¯¿çϵͳ²¿ÊðÂ䵨¹æ·¶
WindowsÉú²ú»·¾³²¿Êð£¬ÓÅÏÈÑ¡ÓÃÏîÄ¿ÄÚǶÒýÓÃģʽ£¬Ëø¶¨mysql.data.dll°æ±¾£¬¹Ø±Õϵͳȫ¾Öµ÷Ó㬱ÜÃâ°æ±¾³åÍ»£¬²¿ÊðÍê³Éºó²âÊÔÊý¾Ý¿âÁ¬½Ó¡¢Êý¾Ý¶Áд¡¢·þÎñ¶ËÆô¶¯È«Á÷³Ì£¬È·±£×é¼þÕý³£¼ÓÔØ¡£
LinuxÉú²ú»·¾³²¿Êð£¬È«³Ì²ÉÓÃNuGet¹Ù·½ÒÀÀµ°²×°·½Ê½£¬×Ô¶¯ÊÊÅäϵͳ¼Ü¹¹ÓëÔËÐа汾£¬²»ÊÖ¶¯¸´ÖƵÚÈý·½dllÎļþ£¬¶Å¾ø¼æÈÝÒþ»¼£¬²¿Êðºóͨ¹ýÖ¸ÁîУÑé×é¼þ¼ÓÔØ×´Ì¬£¬È·ÈÏÊý¾Ý¿â½»»¥Ä£¿éÕý³£ÔËÐС£
ÕûÌå¶øÑÔ£¬mysql.data.dllÔÚWindowsÓëLinuxϵͳµÄ²¿ÊðÂß¼ÍêÈ«²»Í¬£¬WindowsÒÀÀµÏµÍ³×¢²áÓë×¢²á±í»úÖÆÊµÏÖ×é¼þ¼ÓÔØ£¬LinuxÒÀÍÐ.NET¿çƽ̨ÔËÐÐʱÓëÒÀÀµ°ü¹ÒÔØÔËÐУ¬ÎÞÈκÎ×¢²áÁ÷³Ì¡£ÄæË®º®·þÎñ¶Ë¿çϵͳ²¿ÊðÐèÑϸñÇø·ÖÁ½Ì×ÊÊÅä·½°¸£¬ÞðÆúͨÓò¿Êð˼ά£¬Õë¶ÔÐÔ½â¾öϵͳ¼æÈÝ¡¢°æ±¾Æ¥Åä¡¢»·¾³ÒÀÀµÎÊÌ⣬¼´¿É³¹µ×¶Å¾ø×é¼þ¼ÓÔØÊ§°Ü¡¢Êý¾Ý¿âÁ¬½ÓÒì³£µÈ²¿Êð¹ÊÕÏ¡£
Ò»¡¢mysql.data.dllºËÐÄÔËÐлúÖÆÓë¿çϵͳ²¿Êð±¾ÖʲîÒì
mysql.data.dllÊôÓÚ.NETƽ̨ÍйÜÀද̬Á´½Ó¿â£¬ÔÉúÊÊÅäWindowsϵͳÔËÐмܹ¹£¬ÒÀÍÐWindows×¢²á±í¡¢COM×é¼þ»úÖÆ¡¢.NET FrameworkÔËÐл·¾³Íê³É×¢²áÓë¼ÓÔØ£¬ÊÇWindowsƽ̨.NET³ÌÐò¶Ô½ÓMySQLµÄ±ê×¼×é¼þ¡£ÔÚWindowsϵͳÖУ¬¸Ã×é¼þÖ§³ÖÊÖ¶¯×¢²á¡¢È«¾ÖÒýÓá¢ÏîÄ¿ÄÚǶµ÷ÓÃÁ½ÖÖÔËÐÐģʽ£¬¼æÈÝÐÔÎȶ¨£¬ÊÊÅä¸÷Àà.NET°æ±¾ÓëÊý¾Ý¿âÔËÐл·¾³¡£
LinuxϵͳÎÞÔÉúdll×é¼þ×¢²á»úÖÆ£¬²»Ö§³ÖWindowsÌåϵµÄCOM×¢²á¡¢×¢²á±í¹ÒÔØÔËÐÐģʽ£¬ÕâÒ²ÊÇLinux²¿Êðmysql.data.dllƵ·±±¨´íµÄºËÐÄÔÒò¡£LinuxϵͳÔËÐÐÒÀÀµ.NET Core¡¢.NET¿çƽ̨ÔËÐÐʱ£¬ÞðÆú´«Í³dll×¢²áÂß¼£¬ÒÔ×é¼þÒýÓá¢ÒÀÀµ°ü¹ÒÔØµÄ·½Ê½Íê³É¼ÓÔØ£¬Ö±½ÓÌ×ÓÃWindows×¢²á²¿Êð·½Ê½»á³öÏÖ×é¼þ²»Ê¶±ð¡¢¼ÓÔØÊ§°Ü¡¢È¨ÏÞ±¨´í¡¢³ÌÐòÉÁÍ˵ÈÎÊÌâ¡£
ÄæË®º®·þÎñ¶Ë³ÌÐò¿çϵͳ²¿Êðʱ£¬Êý¾Ý¿â½»»¥Ä£¿éÍêÈ«ÒÀÍÐmysql.data.dllÇý¶¯£¬×é¼þ²¿ÊðÒì³£»áÖ±½Óµ¼Ö·þÎñ¶ËÊý¾Ý³õʼ»¯Ê§°Ü¡¢½ÇÉ«Êý¾Ý¶ÁÈ¡Òì³£¡¢·þÎñÆ÷µÇ¼УÑéʧЧ¡¢Íæ·¨ÅäÖüÓÔØ²»È«µÈ¹ÊÕÏ£¬Òò´ËÐèÒª¸ù¾Ý²Ù×÷ϵͳÊÊÅä¶ÔÓ¦µÄ²¿Êð×¢²á·½°¸£¬²»ÄÜͨÓÃÒ»Ìײ¿ÊðÂß¼¡£
¶þ¡¢Windowsϵͳmysql.data.dll±ê×¼×¢²áÓ벿ÊðÁ÷³Ì
WindowsϵͳÍêÕûÖ§³Ömysql.data.dll×¢²á²¿Ê𣬷ÖΪϵͳȫ¾Ö×¢²á¡¢ÏîÄ¿±¾µØÒýÓÃÁ½ÖÖ·½Ê½£¬ÊÊÅäÄæË®º®·þÎñ¶Ë±¾µØµ÷ÊÔ¡¢Windows·þÎñÆ÷²¿Ê𳡾°£¬Á½ÖÖ·½Ê½¾ù¿ÉÎȶ¨ÊµÏÖÊý¾Ý¿âÕý³£¶Ô½Ó¡£
ϵͳȫ¾Ö×¢²áÊÊÓÃÓÚ¶àÏîÄ¿¹²ÓÃ×é¼þ¡¢·þÎñÆ÷È«¾ÖÊÊÅ䳡¾°¡£Ê×ÏÈÈ·ÈÏϵͳƥÅäµÄ×é¼þ°æ±¾£¬Çø·Ö32λÓë64λmysql.data.dll£¬¸ù¾ÝϵͳλÊýÑ¡Ôñ¶ÔÓ¦Îļþ£¬±ÜÃâλÊý²»Æ¥Åäµ¼ÖµÄ×¢²áʧ°Ü¡£½«¶ÔÓ¦°æ±¾µÄmysql.data.dll·ÅÖÃÔÚϵͳָ¶¨Ä¿Â¼£¬64λϵͳ·ÅÖÃÓÚSystem32Îļþ¼Ð£¬32λ×é¼þ·ÅÖÃÓÚSysWOW64Îļþ¼Ð¡£
´ò¿ª¹ÜÀíԱȨÏÞÃüÁîÌáʾ·û£¬Ö´ÐÐ×é¼þ×¢²áÖ¸Áͨ¹ýregsvr32¹¤¾ßÍê³Édll×é¼þ×¢²á±í¹ÒÔØÓëϵͳʶ±ð¡£Ö¸ÁîÖ´Ðгɹ¦ºó£¬ÏµÍ³»áÌáʾע²á³É¹¦µ¯´°£¬´Ëʱϵͳȫ¾Ö»·¾³ÒѼÓÔØMySQLÊý¾ÝÇý¶¯£¬ËùÓÐ.NET³ÌÐò¾ù¿Éµ÷ÓøÃ×é¼þÍê³ÉÊý¾Ý¿âÁ¬½Ó¡£×¢²áÍê³Éºó£¬ÖØÆôÄæË®º®·þÎñ¶Ë³ÌÐò£¬¼´¿ÉÕý³£¶ÁÈ¡Êý¾Ý¿âÅäÖá¢Íê³ÉÊý¾Ý½»»¥¡£
ÏîÄ¿±¾µØÒýÓò¿ÊðÎÞÐèϵͳȫ¾Ö×¢²á£¬ÊÊÅäµ¥ÏîÄ¿¶ÀÁ¢²¿ÊðÐèÇó¡£Ö±½ÓÔÚVisual Studio»ò·þÎñ¶ËÏîÄ¿ÅäÖÃÎļþÖУ¬ÊÖ¶¯Ìí¼Ómysql.data.dllÒýÓã¬Ö¸¶¨×é¼þ±¾µØÂ·¾¶£¬ÅäÖÃÏîÄ¿ÒÀÀµ°æ±¾£¬Ëø¶¨×é¼þµ÷ÓÃÓÅÏȼ¶¡£¸Ã·½Ê½²»ÐÞ¸Äϵͳע²á±í£¬½öÕë¶Ôµ±Ç°ÏîÄ¿ÉúЧ£¬²¿ÊðÎȶ¨ÐÔ¸ü¸ß£¬²»»á³öÏÖ¶à°æ±¾×é¼þ³åÍ»ÎÊÌ⣬ÊʺÏÄæË®º®·þÎñ¶Ë¶¨ÖÆ»¯²¿Ê𳡾°¡£
Windowsϵͳ²¿Êð³£¼ûÎÊÌ⼯ÖÐÔÚ°æ±¾²»¼æÈÝ¡¢È¨ÏÞ²»×ã¡¢×é¼þËð»µÈýÀà¡£ÀϾÉ.NET Framework°æ±¾ÎÞ·¨ÊÊÅä¸ß°æ±¾mysql.data.dll£¬»á³öÏÖ¼ÓÔØÊ§°Ü£»·Ç¹ÜÀíԱȨÏÞÖ´ÐÐ×¢²áÖ¸Á»áÌáʾȨÏ޾ܾø£»×é¼þ´«Êä¹ý³ÌÖÐÎļþË𻵡¢È±Ê§£¬»áµ¼ÖÂ×¢²áÖ¸ÁîÖ´ÐÐʧЧ£¬¶ÔÓ¦Ìæ»»ÊÊÅä°æ±¾¡¢¿ªÆô¹ÜÀíԱȨÏÞ¡¢ÖØÐ»ñÈ¡ÍêÕû×é¼þ°ü¼´¿É½â¾ö¡£
Èý¡¢Linuxϵͳmysql.data.dll²¿ÊðºËÐÄÎÊÌâÓëÕýÈ··½°¸
Linuxϵͳ²»´æÔÚdll×é¼þ×¢²á¸ÅÄregsvr32×¢²áÖ¸ÁîÎÞ·¨Ê¶±ð¡¢ÎÞ×¢²á±í¹ÒÔØÇþµÀ£¬Ç¿ÐÐÑØÓÃWindows×¢²á·½Ê½»áÖ±½Ó±¨´í£¬ÕâÊÇ¿çϵͳ²¿ÊðµÄºËÐÄÎóÇø¡£ÄæË®º®·þÎñ¶Ë²¿ÊðÔÚLinux·þÎñÆ÷ʱ£¬±ØÐëÞðÆú´«Í³×¢²áÂß¼£¬ÒÀÍÐ.NET¿çƽ̨ÔËÐÐʱÍê³É×é¼þ¼ÓÔØÓëÊÊÅä¡£
Linuxϵͳ²¿ÊðǰÖÃÌõ¼þΪ°²×°ÊÊÅä°æ±¾µÄ.NET Core»ò.NETÔËÐÐʱ»·¾³£¬ÏµÍ³È±ÉÙ¶ÔÓ¦ÔËÐÐÒÀÀµÊÇ×é¼þ¼ÓÔØÊ§°ÜµÄÖ÷ÒªÓÕÒò¡£Í¨¹ýϵͳ°ü¹ÜÀíÆ÷°²×°ÍêÕû.NETÔËÐл·¾³£¬°üº¬»ù´¡ÔËÐп⡢Êý¾Ý¿â½»»¥ÒÀÀµ¡¢¿çƽ̨¼æÈÝ×é¼þ£¬È·±£¾ß±¸ÍйÜdllÎļþµÄÔËÐлù´¡¡£»·¾³°²×°Íê³Éºó£¬ÎÞÐè×¢²ámysql.data.dll£¬½öÐ轫×é¼þÎļþ·ÅÖÃÔÚ·þÎñ¶Ë³ÌÐòÔËÐиùĿ¼£¬Óë³ÌÐò¿ÉÖ´ÐÐÎļþͬ¼¶´æ·Å¡£
ͨ¹ýNuGet°üÊÊÅ䲿ÊðΪLinux×îÓÅ·½°¸£¬³¹µ×¹æ±ÜÊÖ¶¯²¿ÊðµÄ¼æÈÝÎÊÌâ¡£ÔÚLinux·þÎñ¶ËÏîÄ¿ÖУ¬ÔÚÏß°²×°MySQL¹Ù·½Connector/NETÒÀÀµ°ü£¬°²×°Íê³Éºóϵͳ»á×Ô¶¯ÊÊÅäÉú³É¶ÔÓ¦mysql.data.dll×é¼þ£¬×Ô¶¯Æ¥Åä.NETÔËÐа汾ÓëLinuxϵͳ¼Ü¹¹£¬ÎÞÐèÊÖ¶¯¸´ÖÆ¡¢×¢²á¡¢ÅäÖã¬×é¼þ¼æÈÝÐÔ¡¢Îȶ¨ÐÔÔ¶³¬ÊÖ¶¯²¿Êð£¬ÊÊÅäÄæË®º®·þÎñ¶Ë³¤ÆÚÔËÐÐÐèÇó¡£
LinuxϵͳÊÖ¶¯²¿ÊðÐèÒªÅäÖÃÎļþȨÏÞÓëÔËÐвÎÊý£¬·ÅÖÃ×é¼þºó¸³ÓèÎļþ¶ÁдִÐÐȨÏÞ£¬±ÜÃâȨÏÞ²»×ãµ¼ÖµÄ×é¼þ¼ÓÔØÀ¹½Ø¡£Í¬Ê±Ð޸ijÌÐòÔËÐÐÅäÖ㬹رÕϵͳCOM×é¼þУÑé¡¢×¢²á±íÒÀÀµ¼ì²â£¬ÊÊÅäLinuxÎÞ×¢²á»úÖÆµÄÔËÐÐÂß¼£¬·ÀÖ¹³ÌÐòÆô¶¯Ê±Ð£ÑéWindows×¢²á¹æÔòÒý·¢ÉÁÍË¡¢±¨´í¡£
Linux²¿Êð¸ßƵ±¨´í°üº¬×é¼þ¼Ü¹¹²»Æ¥Åä¡¢ÔËÐÐʱȱʧ¡¢Â·¾¶ÖÐÎĿոñÈýÀ࣬64λLinuxϵͳÎÞ·¨¼æÈÝ32λdll×é¼þ£¬È±ÉÙ.NETÔËÐÐʱ»áÖ±½ÓÌø¹ý×é¼þ¼ÓÔØ£¬Îļþ·¾¶´æÔÚÌØÊâ×Ö·û»áµ¼ÖÂ×é¼þѰַʧ°Ü£¬Í³Ò»Ìæ»»¶ÔÓ¦¼Ü¹¹×é¼þ¡¢²¹È«ÔËÐл·¾³¡¢¹æ·¶´æ·Å·¾¶¼´¿É³¹µ×ÐÞ¸´¡£
ËÄ¡¢ÄæË®º®¿çϵͳ²¿Êðmysql.data.dllÊÊÅäÒªµã
ÄæË®º®·þÎñ¶Ë³ÌÐò¶Ômysql.data.dll×é¼þ°æ±¾Óй̶¨ÊÊÅäÒªÇó£¬Ð¾ɰ汾×é¼þ´æÔÚº¯Êý½Ó¿Ú²îÒì£¬ËæÒâÌæ»»°æ±¾»áµ¼ÖÂÊý¾Ý¿â¶Áд½Ó¿Ú²»Æ¥Å䣬³öÏÖ½ÇÉ«Êý¾Ý¼ÓÔØÊ§°Ü¡¢ÅäÖöÁÈ¡Òì³£¡¢·þÎñÆ÷¶Ë¿Ú°ó¶¨Ê§Ð§µÈÎÊÌâ¡£WindowsÓëLinux²¿ÊðÐèͳһ×é¼þ°æ±¾£¬½öÊÊÅ䲿Êð·½Ê½£¬²»ËæÒâ¸ü»»×é¼þ°æ±¾£¬±£Ö¤¿çϵͳÊý¾Ý½»»¥Âß¼Ò»Ö¡£
Windows·þÎñÆ÷ÓÅÏȲÉÓÃÏîÄ¿±¾µØÒýÓÃģʽ£¬¹æ±Üϵͳȫ¾Ö¶à°æ±¾³åÍ»£¬±£Ö¤·þÎñ¶Ë³ÌÐò¶ÀÁ¢µ÷ÓÃרÊô×é¼þ£¬²»ÊÜϵͳÆäËûÏîÄ¿×é¼þÓ°Ïì¡£Linux·þÎñÆ÷ÓÅÏȲÉÓÃNuGet×Ô¶¯²¿Êðģʽ£¬ÒÀÍйٷ½ÊÊÅä°ü½â¾ö¿çƽ̨¼æÈÝÎÊÌ⣬ÎÞÐèÈ˹¤¸ÉԤע²áÓëÊÊÅ䣬½µµÍ²¿Êð¹ÊÕϸÅÂÊ¡£
¿çÏµÍ³Ç¨ÒÆ²¿Êðʱ£¬½ûÖ¹Ö±½Ó¸´ÖÆWindows×¢²áºóµÄ×é¼þÅäÖÃÎļþ£¬LinuxÎÞ·¨Ê¶±ð×¢²á±íÅäÖÃÓëCOM×é¼þ²ÎÊý£¬Ö±½ÓÇ¨ÒÆ»áµ¼Ö³ÌÐòÆô¶¯Òì³£¡£Ç¨Òƹý³Ì½ö±£Áô´¿¾»dll×é¼þÎļþ£¬ÖØÐÂÊÊÅä¶ÔӦϵͳµÄ²¿Êð¹æÔòÓëÔËÐл·¾³£¬ÖØÖÃÒÀÀµÅäÖá£
Îå¡¢¿çϵͳ²¿Êð³£¼û±¨´í»ã×ÜÓ뾫׼½â¾ö·½Ê½
WindowsϵͳÌáʾ“×¢²áʧ°Ü£¬ÕÒ²»µ½Èë¿Úµã”£¬³ÉÒòÊÇ×é¼þ°æ±¾ÓëϵͳλÊý¡¢.NET°æ±¾²»Æ¥Å䣬½â¾ö·½Ê½ÎªÌæ»»¶ÔӦλÊý¡¢¶ÔÓ¦¿ò¼ÜÊÊÅä°æ±¾µÄmysql.data.dll£¬ÖØÐÂÖ´ÐÐ×¢²áÖ¸Áî¡£
Windows³ÌÐòÆô¶¯Ìáʾ“δÄܼÓÔØÎļþ»ò³ÌÐò¼¯”£¬³ÉÒòÊÇ×é¼þÎļþË𻵡¢ÒÀÀµ¿âȱʧ£¬½â¾ö·½Ê½ÎªÖØÐ»ñÈ¡ÍêÕû×é¼þ£¬²¹È«.NET FrameworkÔËÐÐÒÀÀµ£¬ÇåÀíÎÞЧע²á±í²ÐÁôºóÖØÐ²¿Êð¡£
LinuxϵͳÌáʾ“ÎÞЧµÄWin32¿ÉÖ´ÐÐÎļþ”£¬³ÉÒòÊÇÖ´ÐÐWindows×¢²áÖ¸Áî»òÇ¿ÐмÓÔØ×¢²á±í»úÖÆ£¬½â¾ö·½Ê½Îª·ÅÆú×¢²á²Ù×÷£¬°²×°.NET¿çƽ̨ÔËÐÐʱ£¬Í¨¹ýNuGetÖØÐÂÊÊÅä×é¼þ¡£
Linux³ÌÐòÆô¶¯Êý¾Ý¿âÁ¬½Óʧ°Ü£¬³ÉÒòÊÇ×é¼þȨÏÞ²»×㡢·¾¶´íÎó¡¢ÔËÐÐʱȱʧ£¬½â¾ö·½Ê½Îª¸³Óè×é¼þÍêÕûÔËÐÐȨÏÞ£¬µ÷ÕûÎļþÖÁ³ÌÐò¸ùĿ¼£¬²¹È«È«Ì×.NETÔËÐÐÒÀÀµ¡£
Áù¡¢±ê×¼»¯¿çϵͳ²¿ÊðÂ䵨¹æ·¶
WindowsÉú²ú»·¾³²¿Êð£¬ÓÅÏÈÑ¡ÓÃÏîÄ¿ÄÚǶÒýÓÃģʽ£¬Ëø¶¨mysql.data.dll°æ±¾£¬¹Ø±Õϵͳȫ¾Öµ÷Ó㬱ÜÃâ°æ±¾³åÍ»£¬²¿ÊðÍê³Éºó²âÊÔÊý¾Ý¿âÁ¬½Ó¡¢Êý¾Ý¶Áд¡¢·þÎñ¶ËÆô¶¯È«Á÷³Ì£¬È·±£×é¼þÕý³£¼ÓÔØ¡£
LinuxÉú²ú»·¾³²¿Êð£¬È«³Ì²ÉÓÃNuGet¹Ù·½ÒÀÀµ°²×°·½Ê½£¬×Ô¶¯ÊÊÅäϵͳ¼Ü¹¹ÓëÔËÐа汾£¬²»ÊÖ¶¯¸´ÖƵÚÈý·½dllÎļþ£¬¶Å¾ø¼æÈÝÒþ»¼£¬²¿Êðºóͨ¹ýÖ¸ÁîУÑé×é¼þ¼ÓÔØ×´Ì¬£¬È·ÈÏÊý¾Ý¿â½»»¥Ä£¿éÕý³£ÔËÐС£
ÕûÌå¶øÑÔ£¬mysql.data.dllÔÚWindowsÓëLinuxϵͳµÄ²¿ÊðÂß¼ÍêÈ«²»Í¬£¬WindowsÒÀÀµÏµÍ³×¢²áÓë×¢²á±í»úÖÆÊµÏÖ×é¼þ¼ÓÔØ£¬LinuxÒÀÍÐ.NET¿çƽ̨ÔËÐÐʱÓëÒÀÀµ°ü¹ÒÔØÔËÐУ¬ÎÞÈκÎ×¢²áÁ÷³Ì¡£ÄæË®º®·þÎñ¶Ë¿çϵͳ²¿ÊðÐèÑϸñÇø·ÖÁ½Ì×ÊÊÅä·½°¸£¬ÞðÆúͨÓò¿Êð˼ά£¬Õë¶ÔÐÔ½â¾öϵͳ¼æÈÝ¡¢°æ±¾Æ¥Åä¡¢»·¾³ÒÀÀµÎÊÌ⣬¼´¿É³¹µ×¶Å¾ø×é¼þ¼ÓÔØÊ§°Ü¡¢Êý¾Ý¿âÁ¬½ÓÒì³£µÈ²¿Êð¹ÊÕÏ¡£

