Re: Remote db2_connect in PHP

[Michael Ryan <michaelrtr@xxxxxxxxx>]

Just doesn't seem to find the server. And if I go into Interactive SQL from
the source system, I can connect to the remote system just fine. Also, I
think it's port 446 for DRDA....that's what NETSTAT shows. Hmmm....I'll try
that.

On Mon, Jun 14, 2010 at 11:09 AM, Jim Oberholtzer <midrangel@xxxxxxxxxx>wrote:

> Yes, that appears correct to me.  Mike P (or others) may confirm.
>
> Are you sure port 50000 is not being hijacked by another process?  I
> would pick a very unique port rather than one that may be reasonably
> well known.
>
> Jim Oberholtzer
> CEO/Chief Technical Architect
> Agile Technology Architects, LLC
>
>
> On 6/14/2010 9:54 AM, Michael Ryan wrote:
> > *This message was transferred with a trial version of CommuniGate(r) Pro*
> > Does it need to be set up like this?
> >
> > $database = "RDBNAME";
> > $hostname = "HOSTNAME";
> > $port = 50000;
> > $authID = "USERNAME";
> > $auth_pass = "PASSWORD";
> >
> >
> > $dsn = "DATABASE=$database;HOSTNAME=$hostname;PORT=$port;
> >    PROTOCOL=TCPIP;UID=$authID;PWD=$auth_pass;";
> >
> > $i5 = db2_connect($dsn, "", "", "");
> >
> > I've tried it with and without the port. IIRC, 50000 is the DRDA port.
> >
> > On Mon, Jun 14, 2010 at 10:14 AM, Jim Oberholtzer<midrangel@xxxxxxxxxx
> > wrote:
> >
> >
> > > While I have not tried connecting without the Relational Database Name
> > > being different than what I am connecting to, I think it does need to be
> > > there.  I even saw one install where one of the database names was
> > > "localhost".  That took some time to figure out why we always got DB/2
> > > data instead of MySQL from the desktop.......
> > >
> > > Jim Oberholtzer
> > > CEO/Chief Technical Architect
> > > Agile Technology Architects, LLC
> > >
> > >
> > > On 6/14/2010 8:58 AM, Michael Ryan 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!
> > >
> > > >
> > > --
> > > 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.
> --
> 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.