{"id":1010,"date":"2016-08-17T18:46:10","date_gmt":"2016-08-17T16:46:10","guid":{"rendered":"http:\/\/blog.systemconnect.dk\/?p=1010"},"modified":"2016-10-25T09:43:02","modified_gmt":"2016-10-25T07:43:02","slug":"vandt-goliat-over-david","status":"publish","type":"post","link":"https:\/\/scblog.lynge.org\/?p=1010","title":{"rendered":"Vandt Goliat over David?"},"content":{"rendered":"<p>Nej, det gjorde han ikke og for dem der ikke kender deres bibelhistorie kan <a href=\"https:\/\/da.wikipedia.org\/wiki\/Goliat\" target=\"_blank\">https:\/\/da.wikipedia.org\/wiki\/Goliat<\/a> m\u00e5ske hj\u00e6lpe&#8230;<\/p>\n<p>&nbsp;<\/p>\n<p>Men her gik vi og troede at Klassisk Dynamics C5s Native database kunne v\u00e6re p\u00e5 op til 4GB (i hvert fald siden Klassisk Dynamics C5 version\u00a04.0 &#8211; <a href=\"http:\/\/blog.systemconnect.dk\/?p=247\">l\u00e6s\u00a0evt.\u00a0mere om det\u00a0ved at klikke her!<\/a>) og s\u00e5 viser det sig at der stadig er en 2GB begr\u00e6nsning &#8211; i hvert fald hvis man bruger C5s ODBC driver til Native databasen.<\/p>\n<p>&nbsp;<\/p>\n<p>Normalt anbefaler vi at man skifter til SQL databasen n\u00e5r man n\u00e5r ca. 400MB (det er baseret p\u00e5 en tidligere anbefaling fra Microsoft), men alligevel ramte en af vores kunder 2GB i sin Native database. Det gik fint nok inde i C5, men\u00a0da han ogs\u00e5 bruger ODBC til sin webshop, s\u00e5 var den del\u00a0ikke\u00a0nogen videre stor success.<\/p>\n<p>Test viste hurtigt at noget var helt galt &#8211; testede man ODBC-udtr\u00e6k fra Excel, PowerShell eller andre ODBC testprogrammer &#8211; ja s\u00e5 lukkede de bare uden fejl &#8211; og uden videre&#8230; Intet i eventviewer, intet i C5s logfiler og intet i ODBC debug loggen selvom den blev sl\u00e5et til.<\/p>\n<p>&nbsp;<\/p>\n<p>F\u00f8rst da vi fik slettet lidt i databasen og k\u00f8rt en export\/import fik vi gang i webshoppen igen. Men den l\u00f8sning har jo en levetid indtil databasen igen rammer 2GB. S\u00e5 det var ingen permanent l\u00f8sning:<\/p>\n<p>&nbsp;<\/p>\n<p>Fejlen blev derfor meldt til Microsoft, hvor gutterne i Kgs. Lyngby heldigvis fandt en l\u00f8sning i l\u00f8bet af\u00a0kort tid.\u00a0Vi har haft den til test\u00a0og kan oplyse at den b\u00e5de l\u00f8ser problemet og\u00a0ogs\u00e5 indeholder andre gode ting :-).<\/p>\n<p>Rettelsen er med i hotfix 12 til Klassisk Dynamics C5 2012 Service Pack 2 som blev frigivet\u00a0i oktober 2012. I sagens natur bliver problemet ikke l\u00f8st i \u00e6ldre C5 versioner end 2012,\u00a0da de ikke l\u00e6ngere supporteres.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nej, det gjorde han ikke og for dem der ikke kender deres bibelhistorie kan https:\/\/da.wikipedia.org\/wiki\/Goliat m\u00e5ske hj\u00e6lpe&#8230; &nbsp; Men her gik vi og troede at Klassisk Dynamics C5s Native database kunne v\u00e6re p\u00e5 op til 4GB (i hvert fald siden &hellip; <a href=\"https:\/\/scblog.lynge.org\/?p=1010\">L\u00e6s resten <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":{"footnotes":""},"categories":[37,6,4],"tags":[30,15,43,13,22,11,54,29,23,53,14,21,61,20,7],"class_list":["post-1010","post","type-post","status-publish","format-standard","hentry","category-klassisk-c5","category-klassisk-c5-support","category-klassisk-c5-teknik","tag-bug","tag-business-solutions","tag-c5","tag-damgaard-data","tag-database","tag-dynamics","tag-dynamics-c5","tag-fejl","tag-hint","tag-klassisk-c5","tag-microsoft","tag-native","tag-odbc","tag-udokumenteret","tag-versioner"],"_links":{"self":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/1010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1010"}],"version-history":[{"count":6,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/1010\/revisions"}],"predecessor-version":[{"id":1051,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/1010\/revisions\/1051"}],"wp:attachment":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}