{"id":240,"date":"2016-01-22T13:24:37","date_gmt":"2016-01-22T11:24:37","guid":{"rendered":"http:\/\/www.caw.co.za\/?p=240"},"modified":"2016-05-24T10:55:11","modified_gmt":"2016-05-24T08:55:11","slug":"sms-client-the-database-file-is-larger-than-the-configured-maximum-database-size","status":"publish","type":"post","link":"https:\/\/www.caw.co.za\/?p=240","title":{"rendered":"SMSClient &#8211; The database file is larger than the configured maximum database size"},"content":{"rendered":"<h2>Overview<\/h2>\n<p>When starting SMSClient the following message is displayed:<\/p>\n<blockquote><p><em>The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only. [ Required Max Database Size (in MB; 0 if unknown) = 257 ]<\/em><\/p><\/blockquote>\n<h3>Description<\/h3>\n<p>The default maximum size for a Microsoft CE database is 256MB. (SMSClient version 3.2 and later set the default to 1024MB). The database has now reached the maximum size.<\/p>\n<h3>Solution<\/h3>\n<p>Update the SMSClient configuration file to allow a larger database.<\/p>\n<ul>\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, 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 in the command window that just opened:<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 add the text <strong>Max Database Size=1024;<\/strong> at the end of the connection string (note the &#8216;;&#8217; at the end of the text). Do not replace any of the other characters in the string.<br \/>\n<i>If the maximum size is already set at 1024 and it still proves insufficient, set it to a larger number such as 2048 or 4096. Do not set it higher that 1048576. <\/i><\/li>\n<\/ul>\n<p><strong>Example:<\/strong><\/p>\n<pre>connectionString=\"Data Source=&amp;quot;C:\\ProgramData\\SMSClient\\SMS.sdf&amp;quot;\"<\/pre>\n<p>becomes<\/p>\n<pre>connectionString=\"Data Source=&amp;quot;C:\\ProgramData\\SMSClient\\SMS.sdf&amp;quot;;<b>Max Database Size=1024;<b>\"<\/b><\/b><\/pre>\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><\/p>\n<p>Save the file and start SMSClient.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview When starting SMSClient the following message is displayed: The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only. [ Required Max Database Size (in MB; 0 if unknown) = 257 ] Description The default maximum size for a Microsoft CE database is&hellip;&nbsp;<a href=\"https:\/\/www.caw.co.za\/?p=240\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">SMSClient &#8211; The database file is larger than the configured maximum database size<\/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":[1],"tags":[],"class_list":["post-240","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.caw.co.za\/index.php?rest_route=\/wp\/v2\/posts\/240","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=240"}],"version-history":[{"count":7,"href":"https:\/\/www.caw.co.za\/index.php?rest_route=\/wp\/v2\/posts\/240\/revisions"}],"predecessor-version":[{"id":251,"href":"https:\/\/www.caw.co.za\/index.php?rest_route=\/wp\/v2\/posts\/240\/revisions\/251"}],"wp:attachment":[{"href":"https:\/\/www.caw.co.za\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.caw.co.za\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.caw.co.za\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}