Eddie Wilson wrote: > > > Bill Karwin wrote: >> >> 1. Open <zf-home>/library/Zend/Db/Adapter/Db2.php >> >> 2. Go approximately to line 280. Find the line in function listTables() >> that reads: >> $stmt = db2_tables($this->_connection); >> >> 3. Edit it and add lines so it looks like this: >> var_dump($this->_connection); >> $stmt = db2_tables($this->_connection); >> var_dump($stmt); >> >> 5. Run your test application (the zfgrid demo). >> >> Here's what I see in the output: >> >> resource(557) of type (DB2 Connection) >> resource(589) of type (DB2 Statement) >> >> I have specified the username and password in my Zend_Db options. If I >> don't I get errors indicating that those options are required. >> >> If the first var_dump() shows anything other than a resource of type DB2 >> Connection, you probably have a problem connecting to the database. If >> the second var_dump() shows anything other than a resource of type DB2 >> Statement, you have a problem fetching a list of tables. Did you >> specify a database? Do you have any tables in this database? >> >> > > The output without a username or password is: > resource(110) of type (DB2 Connection) bool(false) > Warning: db2_fetch_assoc() expects parameter 1 to be resource, boolean > given in /usr/local/Zend/ZendFramework/library/Zend/Db/Adapter/Db2.php on > line 266 > > The database specified is the same that I am using with non-ZF php scripts > on the same machine. They also do not use a userid/password with > db2_connect. > > I think what I am missing here is the ability to specify a schema. I think > that is required by ZC for i5/OS. > > Thanks, > Eddie >
Would it make sense to move this to the Zend DB forum? Thanks, Eddie -- View this message in context: http://www.nabble.com/i5-OS-tf4232330s16154.html#a12064958 Sent from the Zend Framework mailing list archive at Nabble.com.
