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.
______________________________________________________________________

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.