Re: Remote db2_connect in PHP

I thought Zend Server Community Edition would do provide the connectivity that you need. I use it in very similar ways to what you are describing, (although I am using the framework in an OO environment extensively)

Jim Oberholtzer
CEO/Chief Technical Architect
Agile Technology Architects, LLC


On 6/14/2010 12:36 PM, MattLavinder@xxxxxxxxxxxxxxxxxxx wrote:

*This message was transferred with a trial version of CommuniGate(r) Pro*

Man...I'm having a problem connecting to a remote i using the

db2_connect.

My PHP code works fine when I connect to *LOCAL. I'd like to run my PHP

code

on the same i as it is now, but have the db2_connect point to a different

i.

What do I need to do to access the other i? I've googled and checked out

the

Zend manual, but the connection fails regardless of my technique. Anyone
have an example? Do I need a server running that would normally run at

port

50000? Do I use the database name in relational database directory?

Thanks!

Bad news. You need to have a licensed feature called "DB2 Connect" to use
the db2 functions remotely. You can use the generic ODBC functions to
connect though.

<rant>
Frankly, I feel as though IBM needs to plug this hole and include a scaled
back version of DB2 Connect for those of us that just want to use db2
functions remotely and don't give a rip about all the other bells and
whistles that DB2 Connect allows.
</rant>,

My recommendation would be to write a database abstraction layer (or use
Zend Framework can do that for you) so you can easily switch back and forth
between DB2 and ODBC functions depending on whether your are running
remotely or locally. That is what I plan to do.

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
______________________________________________________________________