Re: Remote db2_connect in PHP

[Michael Ryan <michaelrtr@xxxxxxxxx>]

Jim...could you give me an example? I'm using Zend Server CE, and I can't
seem to make it work. This stuff is all procedural, but maybe I can glean
something from the object instantiation. If that's the right term. :)



On Mon, Jun 14, 2010 at 2:04 PM, Jim Oberholtzer <midrangel@xxxxxxxxxx>wrote:

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