<br><b>Code</b>: rsb:print<br><b>Error</b>: Formatter [ extraconnectionnotes ] failed in the evaluation of <p> ???????Claris FileMaker (???FileMaker)?ESS(External SQL Source)????CData ODBC Driver?????SQL Gateway ?????[service] ??????????????????????? </p> <p>FileMaker ?ESS(External SQL Source)????FileMaker ?????????????????????????????????ODBC driver ??FileMaker ?????????????????????CData ODBC Drivers ?????????????????????????????????????CData ODBC Driver ?MySQL ?????????????????<a href="[x|UrlRoot]/sqlgateway"></a>SQL Gateway</p> ??????FileMaker ?ESS ????????MySQL ODBC Driver ????SQL Gateway ???[service] ???????????? <img src="../articles/odbc-filemaker-ess-1.png" title="Filemaker ?[service] ??????"/> <p>???????????????SQL Gateway ??????????????ODBC ????????????????????<a href="[x|UrlRoot]/kb/tech/[id]-odbc-filemaker-inport.rst">ODBC ?[service] ????Filemaker ??????</a></p> <p>???????????????????????????????</p> <ul> <li>[service] ????BI?ETL?????????????:<a href="[id]-article-list.rst">[service] ??????????????????????</a>?</li> <li>[service] Drivers ???????????:<a href="[x|UrlRoot]/drivers/[id]/">????????????</a>?</li> <li>???????????????:<a href="[x|UrlRoot]/drivers/">CData Drivers ??</a>?</li> <li>??????30???????????????:<a href="[x|UrlRoot]/drivers/[id]/download/">???????????????</a>?</li> <li>????????????????????:sales@cdata.co.jp ???????????????</li> </ul> <h2>ODBC Driver ?[service] ?????????</h2> <p> ???CData ODBC Driver for [service] ??????????? </p> <ol> <li><p> ???????????????????(DSN)???????????????????? </p> <p> [extraconnectionnotes] ?????????????????: </p> <p> [extraconnectionprops] </p> <img src="../articles/odbc-filemaker-ess-2.png" title="ODBC DSN ?[service] ????"/> <p> DSN ???????Microsoft ODBC ???????????????????????????????????????????????? Microsoft ODBC ????????????????????DSN ??????????????????????????????????????? </p> <h2>SQL Gateway ?[service] ODBC ????????</h2> <p>??SQL Gateway ??????????[service] ODBC DSN ?MySQL ????????????? </p> <ul> <li>CData ODBC Driver ?????????Windows ????????????????CData SQL Gateway????????</li> <li>?????CData SQL Gateway ????????????????????????????????????????????????????????????????????????????? <ul> <li><b>?????:</b>??(?????????????????????????????????????CData?)</li> <li><b>??(TDS(SQLServer)?MySQL)??????:</b>?MySQL????</li> <li><b>?????? :</b>CData ODBC Driver ?????DSN ????(?????CData [service] Sys)</li> <li><b>???:</b>?????MySQL ???????????????????3306?????????????????3307????</li> </ul> <img src="../articles/odbc-filemaker-ess-3.png" title="SQL Gateway ????????"/> </li> <li>?OK????????????????????????????????????????????????????????</li> <img src="../articles/odbc-filemaker-ess-4.png" title="SQL Gateway ????????????"/> <li>????????????????????????????????????????????????????????????????????????????????????????MySQL ?????????????????????????????</li> <img src="../articles/odbc-filemaker-ess-5.png" title="SQL Gateway ?????????"/> <li>??????????????????????????????????????????????????MySQL ???????????????????????????????</li> <img src="../articles/odbc-filemaker-ess-6.png" title="SQL Gateway ?[service] ????????"/> </ul> <h2>Claris Filemaker ?ESS ??[service] ???</h2> <h3>MySQL ODBC Driver ??????????</h3> <ul> <li><a href="https://dev.mysql.com/downloads/connector/odbc/">MySQL ODBC 8.0 Unicode Driver</a> ??64bit Windows???????????????????? </li> <li>?????????????Windows ??????odbc???????ODBC?????? (64bit)????????</li> <li>?????DSN??????????????????????? ?????????MySQL ODBC 8.0 Unicode Driver?????????????????????? </li> <img src="../articles/odbc-filemaker-ess-7.png" title="MySQL ODBC Driver ?DSN ????"/> <li> ?MySQL Connector/ODBC Data Source Configuration??????????????????? <ul> <li><b>Data Souce Name : </b>?????(??????CData?)</li> <li><b>TCP/IP Server : </b>CData SQL Gateway ???MySQL ???????????IP ????(??????????localhost?)</li> <li><b>Port : </b>SQL Gateway????????(??????3307????)</li> <li><b>User : </b>SQL Gateway??????????</li> <li><b>>Password : </b>SQL Gateway ???????????????</li> <li><b>Database : </b>????????????CData ODBC Driver ?DSN ???CData [Service] Sys????</li> </ul> </li> <img src="../articles/odbc-filemaker-ess-8.png" title="MySQl ODBC ?SQL Gateway ????????"/> <li>?Test????????????Connection Successful???????????????????????????OK??????????ODBC ?????? ??????????(64???)????????????????</li> </ul> <h3>FileMaker ESS ????[service] ??????</h3> <ul> <li>FileMaker ??????????????????????????????????????????????? ????ODBC ?????? ??????????</li> <img src="../articles/odbc-filemaker-ess-9.png" title="Filemaker ?????"/> <li>ODBC ??????????????MySQL ODBC Driver ????????????(?????MySQL ODBC 8.0 Unicode Driver ???)??????????????????CData ODBC Driver ??????? ?(CData [service] Sys)????????????</li> <img src="../articles/odbc-filemaker-ess-10.png" title="Filemaker ?????"/> <li>??????? ???????????????????OK????????????? <ul> <li><b>??:</b>??(?????CData?)</li> <li><b>??(?????????????) :</b>SQL Gateway ???????MySQL?????? ??????????????</li> <li><b>?????:</b>CData ODBC Driver ?DSN ?(CData [service] Sys)</li> </ul> </li> <img src="../articles/odbc-filemaker-ess-11.png" title="Filemaker ?????"/> <li>????????????????FileMaker ????????????????? ?????????????</li> <img src="../articles/odbc-filemaker-ess-12.png" title="Filemaker ?????"/> <li>???????????????????????????????????</li> <img src="../articles/odbc-filemaker-ess-13.png" title="Filemaker ??????"/> <li>???????????????????????????? ?????????????????</li> <img src="../articles/odbc-filemaker-ess-14.png" title="Filemaker ?????"/> </ul> <h2>???????</h2> <p> [company_name] ODBC Driver for [service] ?SQL Gateway ???????Filemaker ?[service] ????????????????????????<a href="../../drivers/[id]/download/odbc/">30???????</a> ????????? </p> </page>. The error was: The value of the attribute could not be accessed: The attribute does not exist.<br><b>URL</b>: /jp/kb/tech/sqlite-odbc-filemaker-ess.rst