{"id":4163,"date":"2016-12-01T06:24:02","date_gmt":"2016-12-01T06:24:02","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=4163"},"modified":"2020-08-20T11:51:58","modified_gmt":"2020-08-20T18:51:58","slug":"where-to-set-up-your-database-connection","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/where-to-set-up-your-database-connection\/","title":{"rendered":"Where to Set Up Your Database Connection"},"content":{"rendered":"<p>You have a choice to make when you define your eFORMz database connection:<\/p>\n<ul>\n<li>Define the connection in the eFORMz Composer.<\/li>\n<li>Define the connection through the Director Toolkit.<\/li>\n<\/ul>\n<p><strong>eFORMz Composer database definition<\/strong><\/p>\n<p>This method defines a database connection in the project&#8217;s properties. The database connection is used only by the project on which it is defined. You can save the database connection to a file and import the connection to other projects, including projects on different systems.<\/p>\n<ol>\n<li>Start the eFORMz Composer and open the project.<\/li>\n<li>Right click the project in the Project window &gt; Properties &gt; Databases.<\/li>\n<li>Click New.<\/li>\n<li>Define the database connection. You might want to refer to the list of <a href=\"https:\/\/www.minisoft.com\/support\/index.php\/database-url-and-driver-classes\/\">supported databases and their URLs.<\/a><\/li>\n<li>Note that there are fields for \u2018user\u2019 and \u2018password\u2019. <a href=\"https:\/\/minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-8358\" src=\"https:\/\/minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3.png\" alt=\"\" width=\"647\" height=\"401\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3.png 647w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-300x186.png 300w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-150x93.png 150w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-250x155.png 250w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-550x341.png 550w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-290x180.png 290w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-484x300.png 484w\" sizes=\"(max-width: 647px) 100vw, 647px\" \/><\/a>These need to be filled in rather than being embedded in the connection string. If they are not provided you will get the following error: <a href=\"https:\/\/minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-error.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-8360\" src=\"https:\/\/minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-error.png\" alt=\"\" width=\"1358\" height=\"129\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-error.png 1358w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-error-300x28.png 300w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-error-1024x97.png 1024w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-error-768x73.png 768w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-error-150x14.png 150w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-error-250x24.png 250w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-error-550x52.png 550w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-error-800x76.png 800w\" sizes=\"(max-width: 1358px) 100vw, 1358px\" \/><\/a><\/li>\n<li>Alternatively, you can click Load from file if you have a database connection file that was saved from another project.<\/li>\n<li>Click Activate.<\/li>\n<li>Click Test. You should receive a successful confirmation in a few seconds or less.<\/li>\n<li>Click OK, return to the eFORMz Composer, and save your change.<\/li>\n<\/ol>\n<p><strong>Director Toolkit database definition<\/strong><\/p>\n<p>This method defines a database connection in the Director Toolkit. The database connection is available to all projects. To make this connection active while you are editing a project in the eFORMz Composer, you must select &#8220;Active in the eFORMz Composer&#8217;s viewer.&#8221;<\/p>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"647\" height=\"401\" src=\"https:\/\/minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3.png\" alt=\"\" class=\"wp-image-8358\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3.png 647w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-300x186.png 300w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-150x93.png 150w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-250x155.png 250w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-550x341.png 550w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-290x180.png 290w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2016\/12\/DB_v11_3-484x300.png 484w\" sizes=\"(max-width: 647px) 100vw, 647px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>You have a choice to make when you define your eFORMz database connection: Define the connection in the eFORMz Composer. Define the connection through the Director Toolkit. eFORMz Composer database definition This method defines a database connection in the project&#8217;s properties. The database connection is used only by the project on which it is defined. [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/4163"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=4163"}],"version-history":[{"count":7,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/4163\/revisions"}],"predecessor-version":[{"id":8361,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/4163\/revisions\/8361"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=4163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=4163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=4163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}