At work, I’m in charge of getting information into and out of a big database of orders. \u00a0 That includes linking the shipping information to the UPS WorldShip program that our fulfillment team uses to automatically buy UPS service.<\/p>\n
When the computer they’d been using out there for years just got too terribly slow, we got a new machine from our corporate overlords and I set up WorldShip and a ODBC connection to my MySQL database on it. \u00a0 But every time I tried to set up a “import map” in WorldShip (the part that tells it, “This <\/em>field in the MySQL table is what you should use for that <\/em>field in the shipment”), the program would crash.<\/p>\n I checked in the ODBC administrator that my connection was valid. \u00a0 I reinstalled WorldShip several times. \u00a0 I talked to WorldShip tech support for almost an hour. \u00a0 (The Tier 1 guy wasn’t a lot of help, but the Tier 2 woman seemed pretty helpful, checking a bunch of log files on my computer that I would have had no idea how to find, let alone interpret. \u00a0 She didn’t end up helping me much, but she seemed very knowledgable as we went through the detective process together, and she definitively told me that it was a problem with the ODBC driver.)<\/p>\n I even went so far as to reinstall Windows on the new machine, to ensure that there wasn’t some weird setting left on the computer from our other shop. \u00a0 But every time I tried to make that map in WorldShip, it was the same result: crash, crash, crash.<\/p>\n After beating my head against a wall for three days, I finally found the answer by going to another machine that was running WorldShip fine, including the connection to my database. \u00a0 I checked the MySQL ODBC driver there and it was an older version (3.51<\/a>). \u00a0 But for the new machine, I had naively grabbed the latest version of the driver (5.1<\/a>). \u00a0 I tried getting rid of 5.1 and installing 3.51 on the new computer, and it worked the first time. \u00a0 Success!<\/p>\n This entry is not<\/em> intended to bore the daylights out of my family and friends. \u00a0 Instead, I write it so that the next time some poor sucker searches Google for “UPS WorldShip MySQL ODBC crash”, that person finds something more useful than I did.<\/p>\n","protected":false},"excerpt":{"rendered":" At work, I’m in charge of getting information into and out of a big database of orders. \u00a0 That includes linking the shipping information to the UPS WorldShip program that our fulfillment team uses to automatically buy UPS service. When the computer they’d been using out there for years just got too terribly slow, we… Continue reading UPS WorldShip crashes caused by new version of MySQL ODBC driver<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,17],"tags":[38,156,19,37,159],"class_list":["post-75","post","type-post","status-publish","format-standard","hentry","category-programming","category-work","tag-mysql","tag-programming","tag-rocky-mountain-printing","tag-ups-worldship","tag-work","entry"],"_links":{"self":[{"href":"https:\/\/www.curtisgibby.com\/blog\/wp-json\/wp\/v2\/posts\/75","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.curtisgibby.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.curtisgibby.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.curtisgibby.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.curtisgibby.com\/blog\/wp-json\/wp\/v2\/comments?post=75"}],"version-history":[{"count":2,"href":"https:\/\/www.curtisgibby.com\/blog\/wp-json\/wp\/v2\/posts\/75\/revisions"}],"predecessor-version":[{"id":290,"href":"https:\/\/www.curtisgibby.com\/blog\/wp-json\/wp\/v2\/posts\/75\/revisions\/290"}],"wp:attachment":[{"href":"https:\/\/www.curtisgibby.com\/blog\/wp-json\/wp\/v2\/media?parent=75"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.curtisgibby.com\/blog\/wp-json\/wp\/v2\/categories?post=75"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.curtisgibby.com\/blog\/wp-json\/wp\/v2\/tags?post=75"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}