Re: Remote db2_connect in PHP

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.