{"id":884,"date":"2016-02-02T16:56:41","date_gmt":"2016-02-02T15:56:41","guid":{"rendered":"http:\/\/blog.systemconnect.dk\/?p=884"},"modified":"2015-12-03T14:11:10","modified_gmt":"2015-12-03T13:11:10","slug":"klassisk-dynamics-c5-ramte-forbi-lade-porten","status":"publish","type":"post","link":"https:\/\/scblog.lynge.org\/?p=884","title":{"rendered":"Klassisk Dynamics C5 ramte forbi (lade-)porten"},"content":{"rendered":"

Vi har i enkelte tilf\u00e6lde oplevet at Klassisk Dynamics C5 til SQL, har problemer med at koble op til SQL-serveren.<\/p>\n

Typisk er det p\u00e5 64 bits systemer, hvor det fungerer fint hvis man tester forbindelsen med 64 bits ODBC-manageren, men ikke virker med 32 bits ODBC-manageren.<\/p>\n

En l\u00f8sning vi har brugt er at \u00e6ndre SQL-serverens konfiguration s\u00e5 den bruger standard SQL TCP-porten 1433, fremfor dynamisk portnummer (s\u00e5 st\u00e5r der 0 i ops\u00e6tningen):<\/p>\n

\"Ops\u00e6tning<\/a><\/p>\n

 <\/p>\n

Herefter kan forbindelsen gennemf\u00f8res ogs\u00e5 med 32 bits ODBC-manageren, n\u00e5r den ogs\u00e5 konfigureres til at bruge en statisk port 1433.<\/p>\n

\"2\"<\/a><\/p>\n

 <\/p>\n

Men hvordan hulen angiver man port-nummeret Klassisk Dynamics C5 skal bruge?<\/p>\n

Jo – det foreg\u00e5r i C5.INI (eller direkte som parameter p\u00e5 C5-genvejen). Men syntaxen er lidt speciel, for det er ikke en separat setting man kan angive. I stedet skal det angives efter SQL-servernavnet (hvor evt. SQL-instansen ogs\u00e5 er tilf\u00f8jet efter et backslash) – dvs. i -ZSRVR. Der skal ganske simpelt tilf\u00f8jes et komma og s\u00e5 portnummeret – fx:<\/p>\n

-ZSRVR=SBSSRV\\SQLEXPRESS,1433<\/pre>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Vi har i enkelte tilf\u00e6lde oplevet at Klassisk Dynamics C5 til SQL, har problemer med at koble op til SQL-serveren. Typisk er det p\u00e5 64 bits systemer, hvor det fungerer fint hvis man tester forbindelsen med 64 bits ODBC-manageren, men … L\u00e6s resten →<\/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,23,53,14,28,20,24],"class_list":["post-884","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-hint","tag-klassisk-c5","tag-microsoft","tag-sql","tag-udokumenteret","tag-xal"],"_links":{"self":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/884","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=884"}],"version-history":[{"count":1,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/884\/revisions"}],"predecessor-version":[{"id":887,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/884\/revisions\/887"}],"wp:attachment":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}