{"id":654,"date":"2016-02-04T21:02:25","date_gmt":"2016-02-04T21:02:25","guid":{"rendered":"http:\/\/192.168.1.102\/?p=654"},"modified":"2016-02-04T21:02:25","modified_gmt":"2016-02-04T21:02:25","slug":"jdbc-connector-to-mssql-2014","status":"publish","type":"post","link":"https:\/\/digitalsos.net\/?p=654","title":{"rendered":"JDBC connector to MSSQL 2014"},"content":{"rendered":"<p>YAFD (Yet another fucking developer) that needs to use java to connect to YAFDB (Yet Another Fucking DataBase).<\/p>\n<p>So start off and install Oracle java JRE 8 on your sql server.\u00a0 Then go here and get the latest Microsoft JDBC Driver, 4.2 <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=11774\" target=\"_blank\">http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=11774<\/a><\/p>\n<p>Go to your control Panel &#8211;&gt; System and Security &#8211;&gt; System. Click on the left side &#8220;Advanced system settings&#8221;.\u00a0 Click Environmental Variables.\u00a0 Click on NEW in the System variables and for the name use CLASSPATH.\u00a0 And if you extracted the zip correctly you can use this for the value: C:\\Program Files\\Microsoft JDBC Driver 4.2 for SQL Server\\sqljdbc_4.2\\enu\\sqljdbc42.jar<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/192.168.1.102\/wp-content\/uploads\/2015\/08\/EnvVar.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-655\" src=\"https:\/\/i0.wp.com\/192.168.1.102\/wp-content\/uploads\/2015\/08\/EnvVar-300x169.png?resize=300%2C169\" alt=\"EnvVar\" width=\"300\" height=\"169\" srcset=\"https:\/\/i0.wp.com\/digitalsos.net\/wp-content\/uploads\/2015\/08\/EnvVar.png?resize=300%2C169&amp;ssl=1 300w, https:\/\/i0.wp.com\/digitalsos.net\/wp-content\/uploads\/2015\/08\/EnvVar.png?w=960&amp;ssl=1 960w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>So now we need to build the connection string as outlined here: <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms378428%28v=sql.110%29.aspx\" target=\"_blank\">https:\/\/msdn.microsoft.com\/en-us\/library\/ms378428%28v=sql.110%29.aspx<\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>YAFD (Yet another fucking developer) that needs to use java to connect to YAFDB (Yet Another Fucking DataBase). So start off and install Oracle java JRE 8 on your sql server.\u00a0 Then go here and get the latest Microsoft JDBC Driver, 4.2 http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=11774 Go to your control Panel &#8211;&gt; System and Security &#8211;&gt; System. Click<\/p>\n<div class=\"read-more-wrapper\"><a class=\"read-more\" href=\"https:\/\/digitalsos.net\/?p=654\" title=\"Read More\"> <span class=\"button \">Read More<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[],"class_list":["post-654","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pgxmGV-ay","_links":{"self":[{"href":"https:\/\/digitalsos.net\/index.php?rest_route=\/wp\/v2\/posts\/654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/digitalsos.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/digitalsos.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/digitalsos.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/digitalsos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=654"}],"version-history":[{"count":1,"href":"https:\/\/digitalsos.net\/index.php?rest_route=\/wp\/v2\/posts\/654\/revisions"}],"predecessor-version":[{"id":656,"href":"https:\/\/digitalsos.net\/index.php?rest_route=\/wp\/v2\/posts\/654\/revisions\/656"}],"wp:attachment":[{"href":"https:\/\/digitalsos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/digitalsos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/digitalsos.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}