Technocrat
-
Posts
29 -
Joined
-
Last visited
Posts posted by Technocrat
-
-
What I want to do is from a linux box with Zend Server 5.3 connect to an iSeries DB2 and simply do SELECT statements against it.
I have installed php-5.2-pdo-ibm-zend-server & php-5.2-ibmdb2-zend-server, and they show green in the server console.
I would think using the PDO would be the easiest. However I am having a hell of a time. Anyone have any tutorials on getting this to work?
I have tried:
$db = new PDO("ibm:DRIVER={IBM DB2 ODBC DRIVER};DATABASE=S104557f;HOSTNAME=10.*.*.*;PORT=8472;PROTOCOL=TCPIP;", "****", "*****");
But I get:
SQLSTATE= , SQLDriverConnect: -1390 [iBM][CLI Driver] SQL10007N Message "0" could not be retrieved. Reason code: "3".Any help?
-
Try port 389
-
I am using the php zip library to unzip some files. The problem I am having is those files (and folders) that are created are unable to be deleted by PHP. When trying to use touch() to remove them I get operation denied. I have tried to use chmod() on them as well but that returns the same error. Any ideas on what I should do?
Thanks
DB2 Connection
in PHP Coding Help
Posted
Thanks for your response.
I think the message is trying to tell me that it can't make a connection. If I mess around with the settings the message is the same. Even with the wrong IP. So at least I understand why the error, I guess.
I am trying to get to the AS/400 from Linux, and you can do it as I can do the exact same thing with Windows using the Windows ODBC driver. However...its Windows and I rather get this working on Linux.
I did not install any clients as it looks like I can do it without, unless I am mistaken.
One thing I have not done is create a DSN. I would think I can use the string to get by with out it, however I might be mistaken there too.