{"id":58,"date":"2014-12-23T11:33:06","date_gmt":"2014-12-23T11:33:06","guid":{"rendered":"http:\/\/smartfoxserver.com\/blog\/?p=58"},"modified":"2014-12-23T17:11:51","modified_gmt":"2014-12-23T17:11:51","slug":"how-to-setup-a-connection-to-an-external-database","status":"publish","type":"post","link":"https:\/\/smartfoxserver.com\/blog\/how-to-setup-a-connection-to-an-external-database\/","title":{"rendered":"How to setup a connection to an external Database"},"content":{"rendered":"<p>SFS2X allows connecting to databases in a way that is very similar to its predecessor. All you need to do is downloading the JDBC connector from your Database vendor (e.g. MySQL or MSSQL) and drop the .jar in the\u00a0<strong>{SFS2XRoot}\/lib\/ folder<\/strong>.<\/p>\n<p>Of course if you use <strong>ODBC instead of JDBC<\/strong> you can even skip the driver deployment step. In fact the <strong>ODBC\u00a0<\/strong>driver is already provided by the Java Runtime.<\/p>\n<p>The following is a list of pages where you can find the JDBC drivers for the most common RDBMS:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.mysql.com\/products\/connector\/\" target=\"_blank\">MySQL JDBC Driver<\/a><\/li>\n<li><a href=\"http:\/\/msdn.microsoft.com\/en-us\/sqlserver\/aa937724.aspx\" target=\"_blank\">Microsoft SQLServer JDBC Driver<\/a><\/li>\n<li><a href=\"http:\/\/jdbc.postgresql.org\/\" target=\"_blank\">Postgres JDBC Driver<\/a><\/li>\n<li><a href=\"http:\/\/www.oracle.com\/technetwork\/database\/features\/jdbc\/index-091264.html\" target=\"_blank\">Oracle JDBC Driver<\/a><\/li>\n<\/ul>\n<p>The next step is running the SFS2X <strong>AdminTool<\/strong>, launch the <a href=\"http:\/\/docs2x.smartfoxserver.com\/GettingStarted\/admintool-ZoneConfigurator\">Zone Configurator<\/a> module, select your Zone and finally click on the <strong>Database manager<\/strong> tab to edit the configuration.<\/p>\n<p><a style=\"line-height: 1.714285714; font-size: 1rem;\" href=\"http:\/\/smartfoxserver.com\/blog\/wp-content\/uploads\/2014\/12\/db-setup.png\"><img loading=\"lazy\" class=\" wp-image-59 size-full aligncenter\" src=\"http:\/\/smartfoxserver.com\/blog\/wp-content\/uploads\/2014\/12\/db-setup.png\" alt=\"db setup dialog\" width=\"684\" height=\"326\" srcset=\"https:\/\/smartfoxserver.com\/blog\/wp-content\/uploads\/2014\/12\/db-setup.png 684w, https:\/\/smartfoxserver.com\/blog\/wp-content\/uploads\/2014\/12\/db-setup-300x143.png 300w, https:\/\/smartfoxserver.com\/blog\/wp-content\/uploads\/2014\/12\/db-setup-624x297.png 624w\" sizes=\"(max-width: 684px) 100vw, 684px\" \/><\/a><\/p>\n<p>At the end of the process click <strong>Submit<\/strong> and restart the server.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SFS2X allows connecting to databases in a way that is very similar to its predecessor. All you need to do is downloading the JDBC connector from your Database vendor (e.g. MySQL or MSSQL) and drop the .jar in the\u00a0{SFS2XRoot}\/lib\/ folder. Of course if you use ODBC instead of JDBC you can even skip the driver [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[21,7],"_links":{"self":[{"href":"https:\/\/smartfoxserver.com\/blog\/wp-json\/wp\/v2\/posts\/58"}],"collection":[{"href":"https:\/\/smartfoxserver.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/smartfoxserver.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/smartfoxserver.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/smartfoxserver.com\/blog\/wp-json\/wp\/v2\/comments?post=58"}],"version-history":[{"count":3,"href":"https:\/\/smartfoxserver.com\/blog\/wp-json\/wp\/v2\/posts\/58\/revisions"}],"predecessor-version":[{"id":69,"href":"https:\/\/smartfoxserver.com\/blog\/wp-json\/wp\/v2\/posts\/58\/revisions\/69"}],"wp:attachment":[{"href":"https:\/\/smartfoxserver.com\/blog\/wp-json\/wp\/v2\/media?parent=58"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smartfoxserver.com\/blog\/wp-json\/wp\/v2\/categories?post=58"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smartfoxserver.com\/blog\/wp-json\/wp\/v2\/tags?post=58"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}