{"id":651,"date":"2009-12-29T04:32:34","date_gmt":"2009-12-29T02:32:34","guid":{"rendered":"https:\/\/foton.no-ip.com\/BLOG\/?p=651"},"modified":"2010-04-17T00:08:17","modified_gmt":"2010-04-16T22:08:17","slug":"mysql-odbc","status":"publish","type":"post","link":"https:\/\/foton.szikraistvan.hu\/blog\/?p=651","title":{"rendered":"MySQL ODBC"},"content":{"rendered":"<p>Ezzel mindig meggyulik a bajom gep installalas utan. Most 64 bites Win 2003 -ra kellett megoldanom, hogy normaliasn lefusson\u00a0a regota hasznalt VBScript.<\/p>\n<p>Az alabbi filokat tettem fel (sorrendben):<br \/>\nmysql-connector-odbc-3.51.27-win32.msi<br \/>\nWindowsServer2003.WindowsXP-KB948459-v2-x64-ENU.exe<br \/>\nmysql-connector-odbc-noinstall-3.51.27-winx64.zip<\/p>\n<p>Az elso utan az Administrative Tools &#8211; Data Sources (ODBC) (%SystemRoot%\\system32\\odbcad32.exe)- nal nem jelenik meg a MySQL ODBC drivere. A 32 bites drivereketet egy masik programmal lehet megnezni: %SystemRoot%\\sysWOW64\\odbcad32.exe<\/p>\n<p>A script folyamatosan ADODB.Connection errorral alt le a Providerre panaszkodva, igy jutottam el oda, hogy talan az MSDASQL provider hianyzik:<br \/>\n<a href=\"http:\/\/www.microsoft.com\/downloads\/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&#038;displaylang=en\">64-Bit OLEDB Provider for ODBC (MSDASQL)<\/a><\/p>\n<p>Ezutan mar a datasource-re panaszkodott. Igy hat jott a 64 bites odbc install (&#8220;install.bat 0&#8221;). <\/p>\n<p>Most mar mukodik<br \/>\n<code>Set Conn = CreateObject(\"ADODB.Connection\")<br \/>\nConn.Provider = \"MSDASQL\"<br \/>\nConn.Open \"Driver={MySQL ODBC 3.51 Driver}; Server=\"&MysqlServer&\"; Database=\"&MysqlDB&\";\", MysqlUser, MysqlPassword<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ezzel mindig meggyulik a bajom gep installalas utan. Most 64 bites Win 2003 -ra kellett megoldanom, hogy normaliasn lefusson\u00a0a regota hasznalt VBScript. Az alabbi filokat tettem fel (sorrendben): mysql-connector-odbc-3.51.27-win32.msi WindowsServer2003.WindowsXP-KB948459-v2-x64-ENU.exe mysql-connector-odbc-noinstall-3.51.27-winx64.zip Az elso utan az Administrative Tools &#8211; Data Sources &hellip; <a href=\"https:\/\/foton.szikraistvan.hu\/blog\/?p=651\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[22],"tags":[71,72],"class_list":["post-651","post","type-post","status-publish","format-standard","hentry","category-informatics","tag-develop","tag-install"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p3E7AZ-av","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/foton.szikraistvan.hu\/blog\/index.php?rest_route=\/wp\/v2\/posts\/651","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/foton.szikraistvan.hu\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/foton.szikraistvan.hu\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/foton.szikraistvan.hu\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/foton.szikraistvan.hu\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=651"}],"version-history":[{"count":3,"href":"https:\/\/foton.szikraistvan.hu\/blog\/index.php?rest_route=\/wp\/v2\/posts\/651\/revisions"}],"predecessor-version":[{"id":704,"href":"https:\/\/foton.szikraistvan.hu\/blog\/index.php?rest_route=\/wp\/v2\/posts\/651\/revisions\/704"}],"wp:attachment":[{"href":"https:\/\/foton.szikraistvan.hu\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/foton.szikraistvan.hu\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/foton.szikraistvan.hu\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}