{"id":565,"date":"2014-07-01T07:47:49","date_gmt":"2014-07-01T05:47:49","guid":{"rendered":"http:\/\/blog.systemconnect.dk\/?p=565"},"modified":"2014-07-01T07:51:14","modified_gmt":"2014-07-01T05:51:14","slug":"klassisk-c5-2012-for-sql-windows-8-1-og-microsoft-sql-servere-2005","status":"publish","type":"post","link":"https:\/\/scblog.lynge.org\/?p=565","title":{"rendered":"Klassisk C5 2012 for SQL, Windows 8 og SQL Server 2005"},"content":{"rendered":"<p>Siden Servicepack 1 til klassisk C5 2012 kom p\u00e5 gaden har databasekompatibilitetsdokument\u00a0indeholdt en note 11, der siger:<\/p>\n<ul>\n<li>[11] Microsoft SQL Server 2005 is not supported on Windows 8 and Windows Server 2012 and later. Please see <a href=\"http:\/\/support.microsoft.com\/kb\/2681562\" target=\"_blank\">http:\/\/support.microsoft.com\/kb\/2681562<\/a> for more information.<\/li>\n<\/ul>\n<p>&#8230;og det er jo meget godt. Men hvordan udm\u00f8nter det sig i praksis?<\/p>\n<p>Ja, f\u00e5r du mystiske fejl fra C5 under opstart &#8211; som fx:<\/p>\n<ul>\n<li>sp_cursorfetch: The cursor identifier value provided (x) is not valid<\/li>\n<li>Could not find prepared statement with handle x<\/li>\n<li>Regnskabet &#8220;dat&#8221; eksisterer ikke<\/li>\n<\/ul>\n<p>&#8230;ja s\u00e5 er du rendt ind i den her.<\/p>\n<p>&nbsp;<\/p>\n<p>&#8220;Fejlen&#8221; skyldes at den &#8220;SQL Driver&#8221; der leveres med Windows 8.1 IKKE fungerer med SQL Server 2005 &#8211; s\u00e5 det er s\u00e5dan set ikke C5s skyld.<\/p>\n<p>&nbsp;<\/p>\n<p>Den hurtigste l\u00f8sning er at hente en \u00e6ldre SQL driver &#8211; fx &#8220;Microsoft\u00ae ODBC Driver 11 for SQL Server\u00ae &#8211; Windows&#8221; fra adressen <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=36434\" target=\"_blank\">http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=36434<\/a>.<\/p>\n<p>Bem\u00e6rk dog at der ligger b\u00e5de en 32 bits (x86) og en 64 bits (x64) driver &#8211; og da C5 er et 32 bits program, er det 32 bits driveren du skal bruge.<\/p>\n<p>&nbsp;<\/p>\n<p>Det er dog ikke helt nok &#8211; for C5 defaulter til at bruge den i Windows indbyggede SQL-driver, s\u00e5 du skal lige have f\u00f8lgende i C5.ini (eller nok n\u00e6rmere p\u00e5 din genvej til\u00a0C5, s\u00e5\u00a0du ikke forstyrrer andre, \u00e6ldre\u00a0Windows&#8217;er i din installation): &#8220;-z@driver={ODBC Driver 11 for SQL Server}&#8221;. Se evt. <a title=\"@!\u00a4%&amp;\u00a8^\u00a4%@$ og andre m\u00e6rkelige tegn i c5.ini p\u00e5 Klassisk C5 for SQL\" href=\"http:\/\/blog.systemconnect.dk\/?p=450\" target=\"_blank\">dette indl\u00e6g<\/a> om hvad den g\u00f8r.<\/p>\n<p>&nbsp;<\/p>\n<p>F\u00e5r du stadig fejlen derefter?<\/p>\n<p>Pr\u00f8v lige engang mere uden Tuborg-parenteserne &#8211; dvs. &#8220;-z@driver=ODBC Driver 11 for SQL Server&#8221;. Der er desv\u00e6rre i skrivende stund lidt forskellige meninger om hvorvidt de skal v\u00e6re der :-).<\/p>\n<p>&nbsp;<\/p>\n<p>Bem\u00e6rk at:<\/p>\n<ul>\n<li>Det er ikke kun Windows 8.1 der har dette problem\u00a0med manglende SQL 2005 driver\u00a0&#8211; Windows Server 2012 R2 har samme problem<\/li>\n<li>Microsoft XAL helt sikker lider af samme fejl &#8211; der dog formentligt kan l\u00f8ses p\u00e5 samme m\u00e5de<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Siden Servicepack 1 til klassisk C5 2012 kom p\u00e5 gaden har databasekompatibilitetsdokument\u00a0indeholdt en note 11, der siger: [11] Microsoft SQL Server 2005 is not supported on Windows 8 and Windows Server 2012 and later. Please see http:\/\/support.microsoft.com\/kb\/2681562 for more information. &hellip; <a href=\"https:\/\/scblog.lynge.org\/?p=565\">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":[15,43,13,22,11,54,29,23,53,14,28,9,7,24],"class_list":["post-565","post","type-post","status-publish","format-standard","hentry","category-klassisk-c5","category-klassisk-c5-support","category-klassisk-c5-teknik","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-sql","tag-udgivelse","tag-versioner","tag-xal"],"_links":{"self":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/565","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=565"}],"version-history":[{"count":9,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/565\/revisions"}],"predecessor-version":[{"id":567,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/565\/revisions\/567"}],"wp:attachment":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}