{"id":102,"date":"2011-12-06T08:25:43","date_gmt":"2011-12-06T06:25:43","guid":{"rendered":"http:\/\/www.caw.co.za\/?p=102"},"modified":"2011-12-06T09:54:29","modified_gmt":"2011-12-06T07:54:29","slug":"sms-clinet-multiuser","status":"publish","type":"post","link":"https:\/\/www.caw.co.za\/?p=102","title":{"rendered":"Sharing the SMS Client Database"},"content":{"rendered":"<p>The SMS Client database can be shared between different users if all the following conditions are met:<\/p>\n<li>All the computers using SMS Client are on the same network<\/li>\n<li>The SMS Client database is copied to a shared location on the network that is accessible to all the computers<\/li>\n<li>The configuration file on each computer is updated to point to the shared database<\/li>\n<p><em>Note<\/em><br \/>\nWhen a new release or update of SMS Client is installed the changes to the configuration files have to be made again.<\/p>\n<p><strong>Procedure<\/strong><br \/>\n1. Create a shared folder on the network.<br \/>\nThe shared location should be accessible to all the computers. Ensure that all the users can write to the share. Test the share by copying a file to the shared folder from each of the computers.<br \/>\n2. Copy the SMS Client database to the shared location on the network.<br \/>\nThe SMS Client database is displayed on the main screen of SMS Client<\/p>\n<figure id=\"attachment_107\" aria-describedby=\"caption-attachment-107\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/www.caw.co.za\/wp-content\/uploads\/2011\/12\/smsmu2.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-medium wp-image-107\" title=\"SMS Client Database\" src=\"http:\/\/www.caw.co.za\/wp-content\/uploads\/2011\/12\/smsmu2-300x210.png\" alt=\"\" width=\"300\" height=\"210\" srcset=\"https:\/\/www.caw.co.za\/wp-content\/uploads\/2011\/12\/smsmu2-300x210.png 300w, https:\/\/www.caw.co.za\/wp-content\/uploads\/2011\/12\/smsmu2.png 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-107\" class=\"wp-caption-text\">Path to the SMS Client database in the status bar<\/figcaption><\/figure>\n<p>3. Update the SMS Client configuration file to point it to the new database location.<\/p>\n<li>Open a new Command Prompt window.<br \/>\nWindows XP users: Click on Start-&gt;All Programs-&gt;Accessories-&gt;Command Prompt.<br \/>\nWindows Vista or Windows 7 users: Click on Start-&gt;All Programs-&gt;Accessories and the <em>right-click<\/em> on Command Prompt, and click on Run as administrator<\/li>\n<li>Type the following:<br \/>\n<code>cd \"C:\\Program Files\\C.A &amp; W Services CC\\SMS Client\"<\/code><br \/>\nand press enter<\/li>\n<li>Type the following:<br \/>\n<code>copy SMSClient.exe.config SMSClient.exe.config.save<\/code><br \/>\nand press enter<\/li>\n<li>Type the following:<br \/>\n<code>notepad SMSClient.exe.config<\/code><br \/>\nand press enter<\/li>\n<li>Find the line that reads (line 78):\n<pre>connectionString=\"Data Source=&amp;quot;C:\\ProgramData\\SMSClient\\SMS.sdf&amp;quot;\"<\/pre>\n<p>and replace the <strong>C:\\ProgramData\\SMSClient\\SMS.sdf<\/strong> section with the full path for the SMS Client database in the shared folder (Step 2). Do not replace any of the other characters in the string.<\/p>\n<p><em>Be careful not to change anything else in the file. If this edit is not made correctly then SMS Client will fail to run<\/em><br \/>\nSave the file.<\/li>\n<p>4. Run SMS Client and check that the Database information now points to the shared database. (See the picture at Step 2)<\/p>\n<p><strong>Troubleshooting<\/strong><br \/>\n1. SMS Client fails to start after the edit<br \/>\nThis could be the result of the edit of SMSClient.exe.config changing some text or the structure of the file. Restore the backup configuration file:<\/p>\n<li>Open a new Command Prompt window. Windows XP users: Click on Start-&gt;All Programs-&gt;Accessories-&gt;Command Prompt. Windows Vista or Windows 7 users: Click on Start-&gt;All Programs-&gt;Accessories and the <em>right-click<\/em> on Command Prompt, and click on Run as administrator<\/li>\n<li>Type the following: <code>cd \"C:\\Program Files\\C.A &amp; W Services CC\\SMS Client\\\"<\/code> and press enter<\/li>\n<li><code>copy SMSClient.exe.config.save SMSClient.exe.config<\/code><\/li>\n<p>Redo the step 1 to 4 and ensure no changes are made except the path to the database.<br \/>\n2. SMS Client cannot connect to the database<\/p>\n<li>Check that the database is in the expected shared location<\/li>\n<li>Confirm that <em>write<\/em> access is enabled for the user to the shared folder<\/li>\n","protected":false},"excerpt":{"rendered":"<p>The SMS Client database can be shared between different users if all the following conditions are met: All the computers using SMS Client are on the same network The SMS Client database is copied to a shared location on the network that is accessible to all the computers The configuration file on each computer is&hellip;&nbsp;<a href=\"https:\/\/www.caw.co.za\/?p=102\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Sharing the SMS Client Database<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-102","post","type-post","status-publish","format-standard","hentry","category-sms-client"],"_links":{"self":[{"href":"https:\/\/www.caw.co.za\/index.php?rest_route=\/wp\/v2\/posts\/102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.caw.co.za\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.caw.co.za\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.caw.co.za\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.caw.co.za\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=102"}],"version-history":[{"count":21,"href":"https:\/\/www.caw.co.za\/index.php?rest_route=\/wp\/v2\/posts\/102\/revisions"}],"predecessor-version":[{"id":127,"href":"https:\/\/www.caw.co.za\/index.php?rest_route=\/wp\/v2\/posts\/102\/revisions\/127"}],"wp:attachment":[{"href":"https:\/\/www.caw.co.za\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.caw.co.za\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.caw.co.za\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}