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 -- View this message in context: http://www.nabble.com/i5-OS-tf4232330s16154.html#a12052159 Sent from the Zend Framework mailing list archive at Nabble.com.
