Need info on how to connect to Db2

chris_hird · #1 (**permalink**) 02-18-2007, 02:06 AM

Hi

I have gone through the manual with out being able to find any information about how to connect to a Db2 file!

here is the section of code I am trying to use

Code:

$params = array(
		'username' => 'username',
		'password' => 'password',
		'dbname' => 'systemname'
		);
		$DB = Zend_Db::factory('Db2' , $params);
		$row = array(
		'FNAME' => $_POST['fName'],
		'LASTNAME' => $_POST['lName'],
		'EMAIL' => $_POST['email'],
		'USRNAMR' => $_POST['user'],
		'PASSWD' => $_POST['pass']
		);
		$table = 'SHIELDCRM.USERS';
		$rowsAffected = $DB->insert($table, $row);

I put in an echo and I can see it starting in the function, but I get no errors and I dont get the file updated! the user, db and password are OK I use them in the studio and it shows up just fine.

Help is appreciated.

Chris...

Cristian · #2 (**permalink**) 02-18-2007, 05:05 AM

Check webserver logs about what error is it.

Alternatively you can just put at beginning of code:

ini_set('display_errors', true);
error_reporting(E_ALL);

Also, this tutorial is also about DB2. Check it too.

Work with XML Data in the Zend FrameworkWork with XML Data in the Zend Framework « View Tutorial*

chris_hird · #3 (**permalink**) 02-18-2007, 04:57 PM

Looks like the forums are being updated as pervious posts seem to have gone? Anyhow I now have a connection but get a problem with the insert
Failed in DB Insert Error occurred in SQL Call Level Interface SQLCODE=-99999
I have looked at the web for an answer but cant find one which seems to relate?

Any suggestions? I have tried to review the documentation but they dont really give any pointers.

Chris..

chris_hird · #4 (**permalink**) 02-19-2007, 05:20 PM

OK I think I have solved the problem and I can now access the DB?

I am not sure why either? I tried setting up the MySQL connection as I was so frustrated with this only to find out i5 Zendcore does not ship with the pdo modules at all?

Having gone through hours of testing and changing configs I now have something which works! So I am not looking back...

Chris...

Thanks for the support!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode