2009年4月22日星期三

[fw-db] Zend_Db_Adapter_Db2 and Zend_Db_Adapter_Pdo_Ibm set AUTHORIZATION param

Hi to all,

I'm playing with Db2 on AS/400 and Zend Framework.

I've just found that the db2exc V9.5 client for Db2 can use the param
"AUTHORIZATION" in the connection string which can be "server",
"server_encrypt" and "data_encrypt", however it's impossible to set
this options into the adapter config.

Without this option, you can occur in this error:

[IBM][CLI Driver] SQL30082N Security processing failed with reason
"17" ("UNSUPPORTED FUNCTION"). SQLSTATE=08001 SQLCODE=-30082

So, the new connection string should be:

"DRIVER={IBM DB2 ODBC DRIVER};DATABASE=MyDBName;HOSTNAME=IP-
Address
;PORT
=446;PROTOCOL=TCPIP;UID=Username;PWD=Password;AUTHENTICATION=server"

What do you think?
Maybe someone (more expert than me) can open an issue about this?

---
Emanuele Deserti
Netwing S.r.l.
<emanuele.deserti@netwing.it>
Tel. 0532-1915183
http://www.netwing.it

没有评论: