{"id":6351,"date":"2018-02-19T10:34:20","date_gmt":"2018-02-19T09:34:20","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=6351&#038;lang=en"},"modified":"2020-06-03T12:23:03","modified_gmt":"2020-06-03T11:23:03","slug":"odbc-data-source-administrator","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=6351","title":{"rendered":"Create ODBC Data Source"},"content":{"rendered":"<p>To install a new Data Source follow the procedure below:<\/p>\n<ol>\n<li>Locate the ODBC Data Source Administrator clicking on the Windows Start menu and typing ODBC . You should see the following:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6387\" style=\"margin-bottom: 20px;\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC99.png\" alt=\"\" width=\"392\" height=\"218\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC99.png 392w, https:\/\/sdna.lu\/wp-content\/uploads\/ODBC99-300x167.png 300w\" sizes=\"auto, (max-width: 392px) 100vw, 392px\" \/><\/li>\n<li>Double-click on the ODBC Data Sources (32-bit) to launch the ODBC Data Source Administrator and go to the System DSN tab:<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-6350\" style=\"margin-bottom: 20px;\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC1.png\" alt=\"\" width=\"594\" height=\"421\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC1.png 594w, https:\/\/sdna.lu\/wp-content\/uploads\/ODBC1-300x213.png 300w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><\/li>\n<li>Click on the Add button, choose the SQL Server driver and click on the Finish button:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6354\" style=\"margin-bottom: 20px;\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC2.png\" alt=\"\" width=\"464\" height=\"352\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC2.png 464w, https:\/\/sdna.lu\/wp-content\/uploads\/ODBC2-300x228.png 300w\" sizes=\"auto, (max-width: 464px) 100vw, 464px\" \/><\/li>\n<li>\u00a0On the screen below give a Name, a Description and choose the SQL server you use: (*Go to the end of the document for the default values)<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6356\" style=\"margin-bottom: 20px;\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC4.png\" alt=\"\" width=\"506\" height=\"362\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC4.png 506w, https:\/\/sdna.lu\/wp-content\/uploads\/ODBC4-300x215.png 300w\" sizes=\"auto, (max-width: 506px) 100vw, 506px\" \/><\/li>\n<li>Clicking on the Next button displays the Authentication screen where you will choose the authentication method to use:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6357\" style=\"margin-bottom: 20px;\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC5.png\" alt=\"\" width=\"506\" height=\"362\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC5.png 506w, https:\/\/sdna.lu\/wp-content\/uploads\/ODBC5-300x215.png 300w\" sizes=\"auto, (max-width: 506px) 100vw, 506px\" \/><\/li>\n<li>If you want to change the network library used to communicate with SQL Server click on the Client Configuration button:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6358\" style=\"margin-bottom: 20px;\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC6.png\" alt=\"\" width=\"586\" height=\"313\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC6.png 586w, https:\/\/sdna.lu\/wp-content\/uploads\/ODBC6-300x160.png 300w\" sizes=\"auto, (max-width: 586px) 100vw, 586px\" \/><\/li>\n<li>Now go back to the Authentication screen and click on the Next button so the following screen is displayed where you can select the default database.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6359\" style=\"margin-bottom: 20px;\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC7.png\" alt=\"\" width=\"506\" height=\"362\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC7.png 506w, https:\/\/sdna.lu\/wp-content\/uploads\/ODBC7-300x215.png 300w\" sizes=\"auto, (max-width: 506px) 100vw, 506px\" \/><\/li>\n<li>Clicking on the Next button displays the following screen where you can select some options &#8211; language, encryption, log files:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6360\" style=\"margin-bottom: 20px;\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC8.png\" alt=\"\" width=\"506\" height=\"362\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC8.png 506w, https:\/\/sdna.lu\/wp-content\/uploads\/ODBC8-300x215.png 300w\" sizes=\"auto, (max-width: 506px) 100vw, 506px\" \/><\/li>\n<li>Then a screen is displayed with a summary of the previously selected parameters:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6361\" style=\"margin-bottom: 20px;\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC9.png\" alt=\"\" width=\"364\" height=\"386\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC9.png 364w, https:\/\/sdna.lu\/wp-content\/uploads\/ODBC9-283x300.png 283w\" sizes=\"auto, (max-width: 364px) 100vw, 364px\" \/><\/li>\n<li>You can now test the created data source. If the test is successful the screen below is displayed:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6362\" style=\"margin-bottom: 20px;\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC10.png\" alt=\"\" width=\"364\" height=\"386\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/ODBC10.png 364w, https:\/\/sdna.lu\/wp-content\/uploads\/ODBC10-283x300.png 283w\" sizes=\"auto, (max-width: 364px) 100vw, 364px\" \/><\/li>\n<li>You have to do all the procedure a second time for the Licence Database.<\/li>\n<li>You can now close the ODBC administrator.<\/li>\n<\/ol>\n<p>* By default at the installation the Name of the ODBC are : SQLServer-DeMaSy and SQLServer-Licence<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To install a new Data Source follow the procedure below: Locate the ODBC Data Source Administrator clicking on the Windows Start menu and typing ODBC . You should see the following: Double-click on the ODBC Data Sources (32-bit) to launch the ODBC Data Source Administrator and go to the System DSN tab: Click on the [&hellip;]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-6351","post","type-post","status-publish","format-standard","hentry","category-non-classe"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/6351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6351"}],"version-history":[{"count":12,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/6351\/revisions"}],"predecessor-version":[{"id":7745,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/6351\/revisions\/7745"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}