<br><b>Code</b>: rsb:print<br><b>Error</b>: Formatter [ extraconnectionprops ] failed in the evaluation of <p> [company_name] ODBC Driver for [service] ????? ODBC ????????????????????????????????????Oracle Database Gateway for ODBC ??ODBC ???????????Oracle ???????????????????Heterogeneous Services agent (????????????)??????????[company_name] ODBC Driver for [service] ????[service] ??Oracle ?????????????????????SQL*Plus ???????[datasource] ?????????????????SQL Developer ??????????????????????????????? <img src="../articles/odbc-oracle-hs-1.png" title="The DSN configuration window. (Salesforce is shown.)"/> <h2>Oracle ODBC Gateway ??????????????</h2> <p>?????????????????????Oracle ????????????[datasource] ??????????SQL*Plus ???SQL Developer ?[datasource] ??????????????????????Oracle ODBC Gateway ????????????????????????????????????????????????????????</p> <ul> <li><p>MapToWVarchar=False</p> <p>????????SQL_WVARCHAR ?????SQL_VARCHAR ??????????????????????????????????????????????????????????????SQL_WVARCHAR ??????unicode ???????????????????????ORA-28528 Heterogeneous Services ??????????????????????</p> <li><p>MaximumColumnSize=4000</p> <p>???????????????????????4000?????????Oracle Database Gateway ??????????????????4000???????????</p> <li><p>UpperCaseIdentifiers=True</p> <p>????????????????????????????????????????????????Oracle ?????????Oracle ??????????????????????????????????????????????</p> <li><p>IncludeDualTable=True</p> <p>?????????????Oracle DUAL ?????????SQL Developer ?????????????????????</p> </li> </ul> <h2>Heterogeneous Service Agent ????</h2> <p> ?????????ODBC Gateway ?[datasource] ??????????[datasource] ?Oracle ????????????????????????? </p> <ol> <li>??????????????????DSN (???????)??????Microsoft ODBC ????????????????????ODBC DSN ?????????????</p> <p> ?????????????????: </p> <p> [extraconnectionprops] </p> <p>Microsoft ODBC ???????????????????????????????????????????????????????????</p> </li> <li> <p><i>oracle-home-directory</i>\hs\admin ?????initmy[id]db.ora ????????????????????:</p> <code>HS_FDS_CONNECT_INFO = "Your-[rootadoname]-DSN"</code></li> <li> <p> <i>oracle-home-directory</i>\NETWORK\admin ???listener.ora ??????????????????:</p> <code> SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = my[id]db) (ORACLE_HOME = your-oracle-home) (PROGRAM = dg4odbc) ) ) </code> </li> <li> <p> <i>oracle-home-directory</i>\NETWORK\admin ???tnsnames.ora ???????????????????????:</p> <code> my[id]db = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)) (CONNECT_DATA=(SID=my[id]db)) (HS=OK) ) </code> </li> <li><p>???????????????????:</p> <code>tnsping my[id]db</code> </li> <li> <p>SQL*Plus ???????????????????????????:</p><code>CREATE DATABASE LINK MY[id|toupper]DB CONNECT TO "user" IDENTIFIED BY "password" USING 'my[id]db';</code> </li> </ol> <p> ????SQL*Plus ????????????????: </p> <code> SELECT * from [extable]@my[id]db; </code>. The error was: The value of the attribute could not be accessed: The attribute does not exist.<br><b>URL</b>: /jp/kb/tech/veevacrm-odbc-oracle-hs.rst