{"id":352,"date":"2009-05-25T11:01:47","date_gmt":"2009-05-25T09:01:47","guid":{"rendered":"http:\/\/michauko.org\/blog\/?p=352"},"modified":"2014-03-31T08:25:09","modified_gmt":"2014-03-31T07:25:09","slug":"windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri","status":"publish","type":"post","link":"https:\/\/michauko.org\/blog\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\/","title":{"rendered":"Windows [Server] 64 bits + ODBC Oracle + Office 32 bits = bug pourri"},"content":{"rendered":"<p>Description d&rsquo;un bug qui m&rsquo;a valu quelques heures de recherche gal\u00e8re sur Google.<\/p>\n<h1>Contexte<\/h1>\n<ul>\n<li>Sur un Windows Server 2003 64 bits &#8211; \u00e7a doit \u00eatre pareil sur un XP 64<\/li>\n<li>ODBC Oracle (version je sais pas quoi ; il semblerait que des versions plus r\u00e9centes corrigent le bug ; pas s\u00fbr et pas facile dans mon cas de faire l&rsquo;upgrade du client Oracle)<\/li>\n<li>Office 2007 pour faire du \u00ab\u00a0reporting fa\u00e7on tableau crois\u00e9 dynamique depuis Excel en tapant directement dans la base\u00a0\u00bb. Oui c&rsquo;est une m\u00e9thode assez discutable, mais pratique pour l&rsquo;utilisateur lambda, habitu\u00e9 d&rsquo;Excel, <\/li>\n<\/ul>\n<p><!--more--><\/p>\n<h1>Le bug qui tue<\/h1>\n<p>Si Office (ou n&rsquo;importe quelle application) est install\u00e9e dans <code>C:\\Program Files (x86)<\/code> qui est le r\u00e9pertoire par d\u00e9faut pour les applications 32 bits sur un OS Windows 64 bits, l&rsquo;appel du client Oracle via ODBC \u00e9choue \u00e0 cause du fait que : <strong>le-programme-appelant-est-install\u00e9-dans-un-r\u00e9pertoire-contenant-une-parenth\u00e8se &#8482;<\/strong>. C&rsquo;est pas beau \u00e7a ?<\/p>\n<p>Le sympt\u00f4me est que toute la connectivit\u00e9 fonctionne (NET assistant, SQLPlus), mais qu&rsquo;Office (Excel) ou une autre application install\u00e9e dans c:\\blabla(x86) g\u00e9n\u00e8re une erreur ORA-06413<br \/>\nNe pas confondre avec l&rsquo;erreur ORA-12154 qui elle indique plut\u00f4t que votre tnsnames.ora est foireux.<\/p>\n<p>C&rsquo;est vaguement expliqu\u00e9 dans un <a href=\"http:\/\/forums.oracle.com\/forums\/thread.jspa?messageID=1943221&#038;\">forum Oracle parlant de TOAD<\/a>.<br \/>\nA noter que dans le <code>sqlnet.log<\/code>, vous verrez vaguement un message indiquant que <code>C:\\Program Files (x86)\\bla\\excel.exe<\/code> a g\u00e9n\u00e9r\u00e9 une erreur ORA-06413, mais c&rsquo;est tout.<\/p>\n<h1>Contournement<\/h1>\n<h2>Version facile pour tester<\/h2>\n<p>Lancez excel depuis une fen\u00eatre DOS (ou modifiez son chemin de lancement), depuis le r\u00e9pertoire <code>C:\\PROGRA~2\\Office\\Office12\\EXCEL.EXE<\/code><br \/>\nLe fait d&rsquo;utiliser le \u00ab\u00a0nom court\u00a0\u00bb PROGRA~2 (PROGRA~1 est le <code>c:\\Program Files<\/code> \u00ab\u00a0normal\u00a0\u00bb, pas le x86) suffit \u00e0 faire fonctionner la chose. C&rsquo;est pas \u00e9norme \u00e7a ????<\/p>\n<h2>Version moyenne<\/h2>\n<p>Installer Office dans <code>C:\\bugdemerde\\Office<\/code><\/p>\n<h2>Version durable<\/h2>\n<p>Upgradez le client Oracle.<br \/>\nJe n&rsquo;ai aucune id\u00e9e de la version \u00e9radiquant le bug, si tant est qu&rsquo;elle existe. Je suis preneur d&rsquo;infos<\/p>\n<p>A+<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Description d&rsquo;un bug qui m&rsquo;a valu quelques heures de recherche gal\u00e8re sur Google. Contexte Sur un Windows Server 2003 64 bits &#8211; \u00e7a doit \u00eatre pareil sur un XP 64 ODBC Oracle (version je sais &hellip;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[9,4],"tags":[318,319,321,320],"class_list":["post-352","post","type-post","status-publish","format-standard","hentry","category-bugs","category-windows","tag-excel","tag-odbc","tag-ora-06413","tag-x86"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Windows [Server] 64 bits + ODBC Oracle + Office 32 bits = bug pourri - Le blog de Michauko<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/michauko.org\/blog\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Windows [Server] 64 bits + ODBC Oracle + Office 32 bits = bug pourri - Le blog de Michauko\" \/>\n<meta property=\"og:description\" content=\"Description d&rsquo;un bug qui m&rsquo;a valu quelques heures de recherche gal\u00e8re sur Google. Contexte Sur un Windows Server 2003 64 bits &#8211; \u00e7a doit \u00eatre pareil sur un XP 64 ODBC Oracle (version je sais &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/michauko.org\/blog\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\/\" \/>\n<meta property=\"og:site_name\" content=\"Le blog de Michauko\" \/>\n<meta property=\"article:published_time\" content=\"2009-05-25T09:01:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-03-31T07:25:09+00:00\" \/>\n<meta name=\"author\" content=\"michauko\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"michauko\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\\\/\"},\"author\":{\"name\":\"michauko\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#\\\/schema\\\/person\\\/0cd9f3d9ce4dccc05df81a5b27051ea9\"},\"headline\":\"Windows [Server] 64 bits + ODBC Oracle + Office 32 bits = bug pourri\",\"datePublished\":\"2009-05-25T09:01:47+00:00\",\"dateModified\":\"2014-03-31T07:25:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\\\/\"},\"wordCount\":328,\"commentCount\":13,\"keywords\":[\"excel\",\"odbc\",\"ORA-06413\",\"x86\"],\"articleSection\":[\"bugs\",\"windows\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/michauko.org\\\/blog\\\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\\\/\",\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\\\/\",\"name\":\"Windows [Server] 64 bits + ODBC Oracle + Office 32 bits = bug pourri - Le blog de Michauko\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#website\"},\"datePublished\":\"2009-05-25T09:01:47+00:00\",\"dateModified\":\"2014-03-31T07:25:09+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#\\\/schema\\\/person\\\/0cd9f3d9ce4dccc05df81a5b27051ea9\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/michauko.org\\\/blog\\\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/michauko.org\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Windows [Server] 64 bits + ODBC Oracle + Office 32 bits = bug pourri\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/\",\"name\":\"Le blog de Michauko\",\"description\":\"Si tu ne comprends pas le titre de l&#039;article, passe ton chemin\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/michauko.org\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#\\\/schema\\\/person\\\/0cd9f3d9ce4dccc05df81a5b27051ea9\",\"name\":\"michauko\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g\",\"caption\":\"michauko\"},\"sameAs\":[\"http:\\\/\\\/michauko.org\\\/\"],\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/author\\\/randomized2\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Windows [Server] 64 bits + ODBC Oracle + Office 32 bits = bug pourri - Le blog de Michauko","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/michauko.org\/blog\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\/","og_locale":"fr_FR","og_type":"article","og_title":"Windows [Server] 64 bits + ODBC Oracle + Office 32 bits = bug pourri - Le blog de Michauko","og_description":"Description d&rsquo;un bug qui m&rsquo;a valu quelques heures de recherche gal\u00e8re sur Google. Contexte Sur un Windows Server 2003 64 bits &#8211; \u00e7a doit \u00eatre pareil sur un XP 64 ODBC Oracle (version je sais &hellip;","og_url":"https:\/\/michauko.org\/blog\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\/","og_site_name":"Le blog de Michauko","article_published_time":"2009-05-25T09:01:47+00:00","article_modified_time":"2014-03-31T07:25:09+00:00","author":"michauko","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"michauko","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/michauko.org\/blog\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\/#article","isPartOf":{"@id":"https:\/\/michauko.org\/blog\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\/"},"author":{"name":"michauko","@id":"https:\/\/michauko.org\/blog\/#\/schema\/person\/0cd9f3d9ce4dccc05df81a5b27051ea9"},"headline":"Windows [Server] 64 bits + ODBC Oracle + Office 32 bits = bug pourri","datePublished":"2009-05-25T09:01:47+00:00","dateModified":"2014-03-31T07:25:09+00:00","mainEntityOfPage":{"@id":"https:\/\/michauko.org\/blog\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\/"},"wordCount":328,"commentCount":13,"keywords":["excel","odbc","ORA-06413","x86"],"articleSection":["bugs","windows"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/michauko.org\/blog\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/michauko.org\/blog\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\/","url":"https:\/\/michauko.org\/blog\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\/","name":"Windows [Server] 64 bits + ODBC Oracle + Office 32 bits = bug pourri - Le blog de Michauko","isPartOf":{"@id":"https:\/\/michauko.org\/blog\/#website"},"datePublished":"2009-05-25T09:01:47+00:00","dateModified":"2014-03-31T07:25:09+00:00","author":{"@id":"https:\/\/michauko.org\/blog\/#\/schema\/person\/0cd9f3d9ce4dccc05df81a5b27051ea9"},"breadcrumb":{"@id":"https:\/\/michauko.org\/blog\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/michauko.org\/blog\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/michauko.org\/blog\/windows-server-64-bits-odbc-oracle-office-32-bits-bug-pourri-352\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/michauko.org\/blog\/"},{"@type":"ListItem","position":2,"name":"Windows [Server] 64 bits + ODBC Oracle + Office 32 bits = bug pourri"}]},{"@type":"WebSite","@id":"https:\/\/michauko.org\/blog\/#website","url":"https:\/\/michauko.org\/blog\/","name":"Le blog de Michauko","description":"Si tu ne comprends pas le titre de l&#039;article, passe ton chemin","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/michauko.org\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/michauko.org\/blog\/#\/schema\/person\/0cd9f3d9ce4dccc05df81a5b27051ea9","name":"michauko","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g","caption":"michauko"},"sameAs":["http:\/\/michauko.org\/"],"url":"https:\/\/michauko.org\/blog\/author\/randomized2\/"}]}},"_links":{"self":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts\/352","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/comments?post=352"}],"version-history":[{"count":7,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts\/352\/revisions"}],"predecessor-version":[{"id":1580,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts\/352\/revisions\/1580"}],"wp:attachment":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/media?parent=352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/categories?post=352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/tags?post=352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}