{"id":2558,"date":"2018-02-02T11:09:57","date_gmt":"2018-02-02T10:09:57","guid":{"rendered":"http:\/\/www.capri-soft.de\/blog\/?p=2558"},"modified":"2018-02-03T13:41:29","modified_gmt":"2018-02-03T12:41:29","slug":"get-microsoft-jet-4-0-driver-working-on-64-bit-windows-server","status":"publish","type":"post","link":"https:\/\/www.capri-soft.de\/blog\/?p=2558","title":{"rendered":"Get Microsoft Jet 4.0 Driver working on 64-Bit Windows Server"},"content":{"rendered":"<h1>Problem<\/h1>\n<p>The Microsoft JET 4.0 Driver, which can open .MDB \/ Access Files, is only available for 32-Bit Systems<\/p>\n<h1>Ansatz &#8211; Approach<\/h1>\n<p>Register the DLLs for the operating system<\/p>\n<h1>L\u00f6sung &#8211; Solution<\/h1>\n<h2>Solution 1 (Especially for IIS)<\/h2>\n<p>In IIS 7.x click on the app pool of your application -> advanced settings and look at the &#8222;General&#8220; Section. The second Attribute is &#8222;Run in 32 Bit mode&#8220;. Check this.<br \/>\nRestart IIS.<br \/>\nIf it is still not working, go on with Solution 2. <\/p>\n<p>Im IIS Manager markiert man den AppPool der Anwendung und kann rechts auf &#8222;Advanced Settings&#8220; (Erweiterte Einstellungen) klicken. Im &#8222;General&#8220;-Abschnitt (Allgemein) kann man im 2. Attribut sagen, man m\u00f6chte im 32-Bit-Modus starten. Danach sollte der JET Treiber auch gehen.<\/p>\n<h2>Solution 2 (Especially for local applications)<\/h2>\n<p>The solution is to manually register those DLLs.<\/p>\n<p>go to Start->Run and type cmd<br \/>\nthis starts the Command Prompt<br \/>\n(also available from Start->Programs->Accessories->Command Prompt)<\/p>\n<p>type cd .. and press return<br \/>\ntype cd .. and press return again (keep doing this until the prompt shows :\\> )<\/p>\n<p>now you need to go to a special folder which might be c:\\windows\\system32 or it might be c:\\winnt\\system32 or it might be c:\\windows\\sysWOW64<br \/>\ntry typing each of these eg<br \/>\ncd c:\\windows\\sysWOW64<br \/>\n(if it says The system cannot find the path specified, try the next one)<br \/>\ncd c:\\windows\\system32<br \/>\ncd c:\\winnt\\system32<br \/>\nwhen one of those doesn&#8217;t cause an error, stop, you&#8217;ve found the correct folder.<\/p>\n<p>now you need to register the OLE DB 4.0 DLLs by typing these commands and pressing return after each<\/p>\n<p>regsvr32 Msjetoledb40.dll<br \/>\nregsvr32 Msjet40.dll<br \/>\nregsvr32 Mswstr10.dll<br \/>\nregsvr32 Msjter40.dll<br \/>\nregsvr32 Msjint40.dll<\/p>\n<iframe src=\"http:\/\/www.facebook.com\/plugins\/like.php?href=https%3A%2F%2Fwww.capri-soft.de%2Fblog%2F%3Fp%3D2558&amp;layout=standard&amp;show_faces=true&amp;width=450&amp;action=like&amp;colorscheme=light\" scrolling=\"no\" frameborder=\"0\" allowTransparency=\"true\" style=\"border:none; overflow:hidden; width:450px;margin-top:5px;\"><\/iframe>","protected":false},"excerpt":{"rendered":"<p>Problem The Microsoft JET 4.0 Driver, which can open .MDB \/ Access Files, is only available for 32-Bit Systems Ansatz &#8211; Approach Register the DLLs for the operating system L\u00f6sung &#8211; Solution Solution 1 (Especially for IIS) In IIS 7.x click on the app pool of your application -> advanced settings and look at the &hellip; <a href=\"https:\/\/www.capri-soft.de\/blog\/?p=2558\" class=\"more-link\"><span class=\"screen-reader-text\">Get Microsoft Jet 4.0 Driver working on 64-Bit Windows Server<\/span> weiterlesen <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":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"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":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[16],"tags":[],"class_list":["post-2558","post","type-post","status-publish","format-standard","hentry","category-access"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4yGeN-Fg","jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2558","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2558"}],"version-history":[{"count":3,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2558\/revisions"}],"predecessor-version":[{"id":2561,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2558\/revisions\/2561"}],"wp:attachment":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}