{"id":311,"date":"2017-04-23T22:34:24","date_gmt":"2017-04-23T18:34:24","guid":{"rendered":"https:\/\/bukleev.ru\/?page_id=311"},"modified":"2017-11-03T02:24:31","modified_gmt":"2017-11-02T22:24:31","slug":"%d0%b4%d0%be%d0%b1%d0%b0%d0%b2%d0%bb%d0%b5%d0%bd%d0%b8%d0%b5-odbc-mysql","status":"publish","type":"page","link":"https:\/\/bukleev.ru\/?page_id=311","title":{"rendered":"\u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 ODBC Mysql"},"content":{"rendered":"<ul>\n<li>\u0421\u043a\u0430\u0447\u0438\u0432\u0430\u0435\u043c ODBC \u0434\u0440\u0430\u0439\u0432\u0435\u0440 MySQL<\/li>\n<li>\u041e\u0442\u043a\u0440\u044b\u0432\u0430\u0435\u043c \u041f\u0430\u043d\u0435\u043b\u044c \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f -&gt; \u0410\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 -&gt; \u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 (ODBC) -&gt; \u0421\u0438\u0441\u0442\u0435\u043c\u043d\u044b\u0439 DSN (\u0412\u043e\u0437\u043c\u043e\u0436\u043d\u043e \u043f\u0440\u0438\u0434\u0435\u0442\u0441\u044f \u0437\u0430\u043f\u0443\u0441\u0442\u0438\u0442\u044c odbcad32.exe \u043e\u0442 \u0438\u043c\u0435\u043d\u0438 \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0430\u0442\u043e\u0440\u0430)<\/li>\n<li>\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c MySQL ODBC 5.3 Unicode Driver<\/li>\n<li>\u0423\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f:<\/li>\n<\/ul>\n<p>Data Source Name &#8212; OTRS<\/p>\n<pre>TCP\/IP Server - \u0423\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u043c IP \u0430\u0434\u0440\u0435\u0441 OTRS\r\nPort - 3306\r\nUser - \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c mysql\r\nPassword - \u043f\u0430\u0440\u043e\u043b\u044c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f\u00a0\r\nDatabase - otrs<\/pre>\n<p>\u041e\u0442\u043a\u0440\u044b\u0432\u0430\u0435\u043c Details<\/p>\n<p>\u0423\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c \u043d\u0430 \u0432\u043a\u043b\u0430\u0434\u043a\u0435 Connection<\/p>\n<pre>Allow big result set - V\r\nUse compression - V\r\nDon't prompt when connecting - V\r\nCharacter set - cp1251<\/pre>\n<p>\u0423\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c \u043d\u0430 \u0432\u043a\u043b\u0430\u0434\u043a\u0435 Connection<\/p>\n<pre>Include table name in SQLDescribeCol() - V<\/pre>\n<p>\u0423\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c \u043d\u0430 \u0432\u043a\u043b\u0430\u0434\u043a\u0435\u00a0Misc<\/p>\n<pre>Enable safe options - V\r\nIgnore space after function names - V\r\nDisable transaction support - V<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0421\u043a\u0430\u0447\u0438\u0432\u0430\u0435\u043c ODBC \u0434\u0440\u0430\u0439\u0432\u0435\u0440 MySQL \u041e\u0442\u043a\u0440\u044b\u0432\u0430\u0435\u043c \u041f\u0430\u043d\u0435\u043b\u044c \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f -&gt; \u0410\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 -&gt; \u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 (ODBC) -&gt; \u0421\u0438\u0441\u0442\u0435\u043c\u043d\u044b\u0439 DSN (\u0412\u043e\u0437\u043c\u043e\u0436\u043d\u043e \u043f\u0440\u0438\u0434\u0435\u0442\u0441\u044f \u0437\u0430\u043f\u0443\u0441\u0442\u0438\u0442\u044c odbcad32.exe \u043e\u0442 \u0438\u043c\u0435\u043d\u0438 \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0430\u0442\u043e\u0440\u0430) \u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c MySQL ODBC 5.3 Unicode Driver \u0423\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f: Data Source Name &#8212; OTRS TCP\/IP Server &#8212; \u0423\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u043c<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-311","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages\/311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bukleev.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=311"}],"version-history":[{"count":3,"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages\/311\/revisions"}],"predecessor-version":[{"id":539,"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages\/311\/revisions\/539"}],"wp:attachment":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}