<br><b>Code</b>: rsb:print<br><b>Error</b>: Formatter [ extraconnectionprops ] failed in the evaluation of <p> [company_name] ODBC Driver for [service] ??PHP ???????????[service] ?????????????????????[service] ????PHP ??????ODBC ???????????????????? </p> <h2>DSN ???</h2> <p> [service] ?????DSN ???????</p> <p> ?????????: </p> <p> [extraconnectionprops] </p> <p> ???????????????????????DSN ??????????????????????????????????????????????????ODBC ????????????????[service] ?????DSN ??????????????? </p> <h2>[service] ???????</h2> <p><tt>odbc_connect</tt> ???????[service] ?????????? <tt>odbc_pconnect</tt> ????????????????????????<tt>odbc_close</tt> ????<tt>odbc_close_all</tt> ??????</p> <code> $conn = odbc_connect("[company_name] ODBC [service] Source","user","password"); </code> <p>???????<tt>odbc_connect</tt> ?????????????????????<tt>odbc_pconnect</tt> ???????????????????????????????????????????????????????????????????????????????:</p> <code> $conn = odbc_pconnect("[company_name] ODBC [service] Source","user","password"); ... odbc_close($conn); //persistent connection must be closed explicitly </code> <h2>????????</h2> <p> <tt>odbc_prepare</tt> ?????Prepared ????????????????????????????? </p> <code> $query = odbc_prepare($conn, "SELECT * FROM [extable] WHERE [exselectwherecol] = ?"); </code> <h2>??????</h2> <p> Prepared ????????<tt>odbc_execute</tt> ?????????? </p> <code> $conn = odbc_connect("[company_name] ODBC [service] Source","user","password"); $query = odbc_prepare($conn, "SELECT * FROM [extable] WHERE [exselectwherecol] = ?"); $success = odbc_execute($query, array('[exselectwherecolequals]')); </code> <p> Non-Parameterized ?????<tt>odbc_exec</tt> ?????? </p> <code> $conn = odbc_connect("[company_name] ODBC [service] Source","user","password"); $query = odbc_exec($conn, "SELECT * FROM [extable]"); </code> <h2>?????</h2> <p><tt>odbc_fetch_array</tt> ??????????????????????????</p> <code> $conn = odbc_connect("[company_name] ODBC [datasource] Source","user","password"); $query = odbc_exec($conn, "SELECT * FROM [extable]"); while($row = odbc_fetch_array($query)){ echo $row\["[excol#1]"] . "\\n"; } </code> <p><tt>odbc_result_all</tt> ???????????????HTML ?????????????</p> <code> $conn = odbc_connect("[company_name] ODBC [datasource] Source","user","password"); $query = odbc_prepare($conn, "SELECT * FROM [extable] WHERE [exselectwherecol] = ?"); $success = odbc_execute($query, array('[exselectwherecolequals]')); if($success) odbc_result_all($query); </code> </li> </ol> <h2>???????????</h2> <p> ?????????????????????????PHP ?????????????????????????????: </p> <ol> <li><p>PHP ?????????????????</p> <li><p>??????????????</p> <li><p>????????</p> <li><p>php.ini-development ?php.ini ????</p> <li><p>????????????????????????????????</p> <code> php -S localhost:8000 -t C:\path-to-your-scripts -c C:\path-to-php\php.ini </code> </li> </ol> <h2>?????????</h2> <p> ?????????SQL ????????????????????????????????<a href="https://php.net/manual/en/ref.uodbc.php">PHP community documentation for all ODBC functions</a> ?[service] ?????????? </p>. The error was: The value of the attribute could not be accessed: The attribute does not exist.<br><b>URL</b>: /jp/kb/tech/adp-odbc-php.rst