{"id":2293,"date":"2022-09-27T11:19:00","date_gmt":"2022-09-27T09:19:00","guid":{"rendered":"http:\/\/www.sfsoft.it\/blog\/?p=2293"},"modified":"2022-09-27T11:19:00","modified_gmt":"2022-09-27T09:19:00","slug":"accesso-ad-una-basedati-as400-da-php-su-debian-11","status":"publish","type":"post","link":"http:\/\/www.sfsoft.it\/blog\/2022\/09\/27\/accesso-ad-una-basedati-as400-da-php-su-debian-11\/","title":{"rendered":"Accesso ad una basedati AS400 da PHP su Debian 11"},"content":{"rendered":"<p>Innanzi tutto occorre scaricare\/avere i driver iAccess IBM, in questo caso su Linux il pacchetto <em>ibm-iaccess-1.1.0.15-1.0.amd64.deb<\/em><\/p>\n<p>Per interfacciarsi si passa attraverso una chiamata ODBC, quindi:<\/p>\n<pre class=\"lang:default decode:true\">apt-get install unixodbc unixodbc-dev\r\ndpkg -i ibm-iaccess-1.1.0.15-1.0.amd64.deb\r\napt-get install php-odbc\r\nodbcinst -i -d -f \/opt\/ibm\/iaccess\/unixodbcregistration\r\nnano \/etc\/odbc.ini<\/pre>\n<p>Nel file di configurazione:<\/p>\n<pre class=\"lang:default decode:true \">[MyDSN]\r\nDescription             = Company DB\r\nDriver                  = IBM i Access ODBC Driver\r\nSystem                  = myserver.mycompany.local\r\nUserID                  = username\r\nPassword                = password\r\nNaming                  = 0\r\nDefaultLibraries        = mylibrary\r\nDatabase                =\r\nConnectionType          = 1 (0=read\/write; 1=readonly)\r\nBlockFetch              = 1\r\nBlockSizeKB             = 512\r\n\r\n[MyDSN2]\r\nDescription             = Company DB2\r\nDriver                  = IBM i Access ODBC Driver\r\nSystem                  = myserver2.mycompany.local\r\nUserID                  = username\r\nPassword                = password\r\nNaming                  = 0\r\nDefaultLibraries        = mylibrary\r\nDatabase                =\r\nConnectionType          = 1\r\nBlockFetch              = 1\r\nBlockSizeKB             = 512<\/pre>\n<p>Esempio di accesso tramite PDO:<\/p>\n<pre class=\"lang:default decode:true \">$pdo = new PDO(\"odbc:MyDSN\");\r\n$stmt = $pdo-&gt;query(\"SELECT * FROM mytable\");\r\nwhile ($row = $stmt-&gt;fetch()) {\r\n        print_r($row);\r\n}<\/pre>\n<p>Fonte: <a href=\"https:\/\/www.pizzolongo.com\/2019\/08\/setup-odbc-to-as400-iseries-on-debian-9-and-php\/\" target=\"_blank\" rel=\"noopener\">setup odbc to AS400 (iSeries) on Debian 9 and PHP<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Innanzi tutto occorre scaricare\/avere i driver iAccess IBM, in questo caso su Linux il pacchetto ibm-iaccess-1.1.0.15-1.0.amd64.deb Per interfacciarsi si passa attraverso una chiamata ODBC, quindi: apt-get install unixodbc unixodbc-dev dpkg -i ibm-iaccess-1.1.0.15-1.0.amd64.deb apt-get install php-odbc odbcinst -i -d -f \/opt\/ibm\/iaccess\/unixodbcregistration nano \/etc\/odbc.ini Nel file di configurazione: [MyDSN] Description = Company DB Driver = IBM i [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[62,166,15,255],"tags":[64,152,167,16,286,256],"_links":{"self":[{"href":"http:\/\/www.sfsoft.it\/blog\/wp-json\/wp\/v2\/posts\/2293"}],"collection":[{"href":"http:\/\/www.sfsoft.it\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.sfsoft.it\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.sfsoft.it\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sfsoft.it\/blog\/wp-json\/wp\/v2\/comments?post=2293"}],"version-history":[{"count":1,"href":"http:\/\/www.sfsoft.it\/blog\/wp-json\/wp\/v2\/posts\/2293\/revisions"}],"predecessor-version":[{"id":2294,"href":"http:\/\/www.sfsoft.it\/blog\/wp-json\/wp\/v2\/posts\/2293\/revisions\/2294"}],"wp:attachment":[{"href":"http:\/\/www.sfsoft.it\/blog\/wp-json\/wp\/v2\/media?parent=2293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sfsoft.it\/blog\/wp-json\/wp\/v2\/categories?post=2293"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sfsoft.it\/blog\/wp-json\/wp\/v2\/tags?post=2293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}