{"id":11106,"date":"2022-12-11T16:11:47","date_gmt":"2022-12-11T07:11:47","guid":{"rendered":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/?p=11106"},"modified":"2022-12-11T20:05:24","modified_gmt":"2022-12-11T11:05:24","slug":"win-odbc","status":"publish","type":"post","link":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/2022\/12\/11\/win-odbc\/","title":{"rendered":"Windows\u306bMySQL\u7528\u306eODBC\u30c9\u30e9\u30a4\u30d0\u5165\u308c\u305f\u3051\u3069\u30af\u30bd\u30cf\u30de\u3063\u305f\u306e\u3067\u66f8\u304d\u7559\u3081\u3066\u304a\u304f"},"content":{"rendered":"<p>ExcelVBA\u3067MySQL\u306b\u30a2\u30af\u30bb\u30b9\u3057\u305f\u3044\u3068\u601d\u3063\u3066MySQL\u7528\u306eODBC\u30c9\u30e9\u30a4\u30d0\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u306e\u3067\u3059\u304c\u3001\u3044\u308d\u3044\u308d\u30cf\u30de\u3063\u305f\u306e\u3067\uff08\u4eca\u306f\u7121\u4e8b\u89e3\u6c7a\uff09\u5171\u6709\u306e\u305f\u3081\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u624b\u9806\u3092\u66f8\u304d\u7559\u3081\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<h2>MySQL\u7528\u306eODBC\u30c9\u30e9\u30a4\u30d0\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n<p>\u4ee5\u4e0b\u306eMicrosoft\u516c\u5f0f\u30da\u30fc\u30b8\u304b\u3089ODBC\u30c9\u30e9\u30a4\u30d0\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002Windows\/Excel\u3068\u3082\u306b64bit\u7248\u306a\u306e\u3067\u8d64\u77e2\u5370\u306e64bit\u7248\u3092\u9078\u3073\u307e\u3057\u305f\u3002\u30cd\u30c3\u30c8\u60c5\u5831\u306b\u3088\u308b\u3068Windows\u304c64bit\u7248\u3067\u3082Excel\u304c32bit\u7248\u306a\u308932bit\u7248\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u30fc\u3092\u9078\u3076\u5fc5\u8981\u304c\u3042\u308b\u3089\u3057\u3044\u3067\u3059\u3002\uff08\u8a66\u3057\u3066\u3044\u306a\u3044\u306e\u3067\u5b9a\u304b\u3067\u306f\u306a\u3044\uff09<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/dev.mysql.com\/downloads\/connector\/odbc\/\" target=\"_blank\" rel=\"noopener\">https:\/\/dev.mysql.com\/downloads\/connector\/odbc\/<\/a><\/p>\n<p><a href=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-11107\" src=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba01-700x462.png\" alt=\"\" width=\"700\" height=\"462\" srcset=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba01-700x462.png 700w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba01-900x594.png 900w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba01.png 1359w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>Login \u307e\u305f\u306f Sign Up\u3092\u6c42\u3081\u3089\u308c\u307e\u3059\u304c\u3001\u4e0b\u306b\u300cNo thanks&#8230;\u300d\u3068\u3044\u3046\u30ea\u30f3\u30af\u3067\u30e6\u30fc\u30b6\u30fc\u767b\u9332\u306a\u304f\u9032\u3081\u307e\u3059\u3002<\/p>\n<p><a href=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-11108\" src=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba02-700x569.png\" alt=\"\" width=\"700\" height=\"569\" srcset=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba02-700x569.png 700w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba02-900x731.png 900w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba02.png 1089w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u30fc\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u307e\u3057\u305f\u3002<\/p>\n<p><a href=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-11109\" src=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba03-700x528.png\" alt=\"\" width=\"700\" height=\"528\" srcset=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba03-700x528.png 700w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba03-900x678.png 900w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba03.png 1182w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u3055\u3066\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3060\u3068\u601d\u3063\u3066\u8d77\u52d5\u3059\u308b\u3068\u9014\u4e2d\uff08\u5e8f\u76e4\uff09\u3067\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u3002Visual Studio\u3092\u694a\u91cd\u3055\u308c\u307e\u3057\u305f\u3002\u3053\u308c\u304c\u6700\u521d\u306e\u8e93\u304d\u3002<\/p>\n<p><a href=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-11110\" src=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba04.png\" alt=\"\" width=\"566\" height=\"268\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2>VS2019\u3092\u8981\u6c42\u3055\u308c\u305f\u306e\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n<p>\u306a\u306e\u3067\u3001\u540c\u3058\u304fMicrosoft\u516c\u5f0f\u30b5\u30a4\u30c8\u304b\u3089Visual Studio\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u306e\u3067\u3059\u304c&#8230;.<\/p>\n<ul>\n<li><strong>\u6700\u65b0\u7248\u306eVisual Studio 2022\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3000\u2192\u3000<span style=\"color: #ff0000;\">\u30c0\u30e1<\/span><\/strong><\/li>\n<li><strong>\u4ee5\u524d\u30d0\u30fc\u30b8\u30e7\u30f3\u306e2019\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3000\u2192\u3000<span style=\"color: #ff0000;\">\u30c0\u30e1<\/span><\/strong><\/li>\n<\/ul>\n<p>\u3069\u3046\u3084\u3063\u3066\u3082\u4e0a\u306e\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u73fe\u308c\u307e\u3059\u3002<\/p>\n<p>\u3067\u3001\u30e1\u30c3\u30bb\u30fc\u30b8\u306b\u66f8\u304b\u308c\u3066\u3044\u305f\u901a\u308a\u300cVisual studio 2019 x64 Redistributable\u300d\u3092\u30ad\u30fc\u306b\u691c\u7d22\u3057\u305f\u3068\u3053\u308d\u4ee5\u4e0b\u306eIBM\u30b5\u30a4\u30c8\u306b\u884c\u304d\u3064\u304d\u307e\u3057\u305f\u3002Redistributable\u307e\u3067\u304c\u30bd\u30d5\u30c8\u540d\u3060\u3063\u305f\u3093\u3067\u3059\u306d\u3002\u8d64\u77e2\u5370\u306e\u30ea\u30f3\u30af\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u30fc\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u307e\u3057\u305f\u3002<\/p>\n<p><a href=\"https:\/\/www.ibm.com\/links?url=https%3A%2F%2Faka.ms%2Fvs%2F16%2Frelease%2Fvc_redist.x64.exe\" target=\"_blank\" rel=\"noopener\">https:\/\/www.ibm.com\/links?url=https%3A%2F%2Faka.ms%2Fvs%2F16%2Frelease%2Fvc_redist.x64.exe<\/a><\/p>\n<p><a href=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba14.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-11121\" src=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba14-700x400.png\" alt=\"\" width=\"700\" height=\"400\" srcset=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba14-700x400.png 700w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba14-900x514.png 900w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba14-1536x877.png 1536w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba14.png 1628w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u30fc\u3092\u8d77\u52d5\u3059\u308b\u3068\u6614\u3063\u307d\u3044UI\u306e\u753b\u9762\u304c\u73fe\u308c\u307e\u3057\u305f\u3002\u6307\u793a\u306b\u5f93\u3063\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba05.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-11111\" src=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba05-700x433.png\" alt=\"\" width=\"700\" height=\"433\" srcset=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba05-700x433.png 700w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba05.png 726w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2>\u6539\u3081\u3066ODBC\u30c9\u30e9\u30a4\u30d0\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n<p>vc_redist.x64.exe\u306a\u308b\u3082\u306e\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5f8c\u3001\u6539\u3081\u3066ODBC\u30c9\u30e9\u30a4\u30d0\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u9032\u3081\u305f\u3068\u3053\u308d\u3001\u30a8\u30e9\u30fc\u306a\u304f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u307e\u3057\u305f\uff01<\/p>\n<p><a href=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba06.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-11112\" src=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba06-700x530.png\" alt=\"\" width=\"700\" height=\"530\" srcset=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba06-700x530.png 700w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba06.png 783w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2>ODBC\u30c9\u30e9\u30a4\u30d0\u306e\u8a2d\u5b9a<\/h2>\n<p>\u6700\u5f8c\u306e\u8e93\u304d\u304cODBC\u30c9\u30e9\u30a4\u30d0\u306e\u8a2d\u5b9a\u3067\u30cf\u30de\u3063\u305f\u3053\u3068\u3067\u3059\u3002\u3069\u3046\u3084\u3063\u3066\u3082\u4ee5\u4e0b\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u73fe\u308c\u307e\u3057\u305f\u3002\u5f8c\u8ff0\u3057\u307e\u3059\u304c\u5358\u7d14\u306b\u30c9\u30e9\u30a4\u30d0\u306e\u9078\u629e\u30df\u30b9\u3067\u3059\u3002<\/p>\n<p><strong>Connection failed with the following error:<\/strong><br \/>\n<strong>[MySQL][ODBC 8.0(w) Driver] Lost connection to MySQL server at &#8216;reading<\/strong><br \/>\n<strong>initial communication packet&#8217;, system error: 0[08S01]<\/strong><\/p>\n<p><a href=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11119\" src=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba13.png\" alt=\"\" width=\"603\" height=\"237\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u30bf\u30b9\u30af\u30d0\u30fc\u306e\u30a6\u30a3\u30f3\u30c9\u30a6\u30a2\u30a4\u30b3\u30f3\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u30d5\u30a1\u30a4\u30eb\u540d\u3092\u6307\u5b9a\u3057\u3066\u5b9f\u884c\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba07.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-11113\" src=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba07-700x364.png\" alt=\"\" width=\"700\" height=\"364\" srcset=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba07-700x364.png 700w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba07.png 705w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u4ee5\u4e0b\u306e\u753b\u9762\u304c\u73fe\u308c\u305f\u3089\u300codbcad32.exe\u300d\u3068\u5165\u529b\u3057\u300cOK\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba08.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-11114\" src=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba08.png\" alt=\"\" width=\"571\" height=\"338\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u4ee5\u4e0b\u306e\u30a6\u30a3\u30f3\u30c9\u30a6\u304c\u73fe\u308c\u308b\u306e\u3067\u3001\u300c\u30c9\u30e9\u30a4\u30d0\u30fc\u300d\u30bf\u30d6\u3092\u958b\u304f\u3068\u300cMySQL ODBC &#8230;\u300d\u304c\u78ba\u8a8d\u3067\u304d\u308b\u3068\u601d\u3044\u307e\u3059\u3002\u3053\u3053\u306f\u78ba\u8a8d\u3059\u308b\u306e\u307f\u3002<\/p>\n<p><a href=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba09.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-11115\" src=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba09-700x484.png\" alt=\"\" width=\"700\" height=\"484\" srcset=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba09-700x484.png 700w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba09-900x622.png 900w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba09.png 1038w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u300c\u30e6\u30fc\u30b6\u30fcDSN\u300d\u30bf\u30d6\u3092\u958b\u304d\u3001\u300c\u8ffd\u52a0\u300d\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n<p><a href=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-11116\" src=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba10-700x484.png\" alt=\"\" width=\"700\" height=\"484\" srcset=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba10-700x484.png 700w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba10-900x622.png 900w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba10.png 1038w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u30ea\u30b9\u30c8\u306e\u4e2d\u304b\u3089\u300cMySQL ODBC X.X <strong>ANSI<\/strong> Driver\u300d\u3092\u9078\u3093\u3067\u300c\u5b8c\u4e86\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u3053\u3053\u3067<strong>Unicode\u7248\u3092\u9078\u3093\u3067\u3057\u307e\u3046\u3068\u5192\u982d\u306e\u30a8\u30e9\u30fc\u304c\u767a\u751f<\/strong>\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba11.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-11117\" src=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba11-700x517.png\" alt=\"\" width=\"700\" height=\"517\" srcset=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba11-700x517.png 700w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba11.png 813w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u5fc5\u8981\u4e8b\u9805\u3092\u5165\u529b\u3057\u307e\u3059\u3002\u6700\u521d\u306e\u300cData Source Name\u300d\u306f\u4efb\u610f\u306e\u540d\u524d\u3067OK\u3067\u3059\u3002\u3042\u3068\u306fMySQL\u3067\u8a2d\u5b9a\u3057\u3066\u3044\u308bUser\/Pass\u306a\u3069\u3092\u5165\u529b\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n<p><a href=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba12.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-11118\" src=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba12-700x501.png\" alt=\"\" width=\"700\" height=\"501\" srcset=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba12-700x501.png 700w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba12.png 855w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u300cTest\u300d\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u3066\u4ee5\u4e0b\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u73fe\u308c\u305f\u3089\u63a5\u7d9a\u6210\u529f\u3067\u3059\u3002\uff08\u3053\u306e\u30bf\u30a4\u30df\u30f3\u30b0\u3067\u5192\u982d\u306e\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\u308f\u3051\u3067\u3059\uff09<\/p>\n<p><a href=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba15c.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-11124\" src=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba15c-700x501.png\" alt=\"\" width=\"700\" height=\"501\" srcset=\"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba15c-700x501.png 700w, http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-content\/uploads\/2022\/12\/mysql_vba15c.png 713w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u3053\u3053\u307e\u3067\u3084\u308c\u3070Excel\/VBA\u304b\u3089MySQL\u306b\u63a5\u7d9a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002VBA\u306b\u3064\u3044\u3066\u306f\u5225\u9014\u66f8\u304d\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>ExcelVBA\u3067MySQL\u306b\u30a2\u30af\u30bb\u30b9\u3057\u305f\u3044\u3068\u601d\u3063\u3066MySQL\u7528\u306eODBC\u30c9\u30e9\u30a4 &#8230; <\/p>\n","protected":false},"author":1,"featured_media":11127,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58,10],"tags":[],"class_list":["post-11106","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-windows"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/posts\/11106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/comments?post=11106"}],"version-history":[{"count":7,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/posts\/11106\/revisions"}],"predecessor-version":[{"id":11129,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/posts\/11106\/revisions\/11129"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/media\/11127"}],"wp:attachment":[{"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/media?parent=11106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/categories?post=11106"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/pineplanter.moo.jp\/non-it-salaryman\/wp-json\/wp\/v2\/tags?post=11106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}