{"id":3866,"date":"2022-05-03T19:17:57","date_gmt":"2022-05-03T18:17:57","guid":{"rendered":"https:\/\/www.lieben.nu\/liebensraum\/?p=3866"},"modified":"2022-05-03T19:17:57","modified_gmt":"2022-05-03T18:17:57","slug":"odbc-sql-driver-error","status":"publish","type":"post","link":"https:\/\/lieben.nu\/liebensraum\/2022\/05\/odbc-sql-driver-error\/","title":{"rendered":"ODBC SQL driver error"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2022\/05\/image.png\"><img loading=\"lazy\" decoding=\"async\" width=\"369\" height=\"208\" src=\"https:\/\/www.lieben.nu\/liebensraum\/wp-content\/uploads\/2022\/05\/image.png\" alt=\"\" class=\"wp-image-3868\" srcset=\"https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2022\/05\/image.png 369w, https:\/\/lieben.nu\/liebensraum\/wp-content\/uploads\/2022\/05\/image-300x169.png 300w\" sizes=\"auto, (max-width: 369px) 100vw, 369px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">If you know how to clear the ODBC Driver 17&#8217;s token cache, please comment \ud83d\ude42<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br>Ran into the following error today and putting it here for searches as literally nothing came up:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Run-time error '-2147467259 (80004005)':<br>&#91;Microsoft]&#91;ODBC Driver 17 for SQL Server]&#91;SQL Server]User option must be specified, if Authentication option is 'ActiveDirectoryInteractive'.<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This was through an excel Macro, connecting to an Azure PaaS database. All other users were just getting prompted, but one kept having this issue.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We managed to &#8216;solve&#8217; the issue by going into the macro properties and adding User ID=xxx@xxx.com to the connection string where xxx@xxx.com was the user&#8217;s actual UPN. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you know how to clear the ODBC Driver 17&#8217;s token cache, please comment \ud83d\ude42 Ran into the following error today and putting it here for searches as literally nothing came up: This was through an excel Macro, connecting to an Azure PaaS database. All other users were just getting prompted, but one kept having &hellip; <a href=\"https:\/\/lieben.nu\/liebensraum\/2022\/05\/odbc-sql-driver-error\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">ODBC SQL driver error<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[4,7],"tags":[],"class_list":["post-3866","post","type-post","status-publish","format-standard","hentry","category-automation","category-azuread"],"_links":{"self":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts\/3866","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/comments?post=3866"}],"version-history":[{"count":0,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/posts\/3866\/revisions"}],"wp:attachment":[{"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/media?parent=3866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/categories?post=3866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lieben.nu\/liebensraum\/wp-json\/wp\/v2\/tags?post=3866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}