Re: Connecting to DB2/400 from PHP 5.3 under Windows

Correction, the OBDC drivers that are part of Client Access are indeed free.

Every system is shipped with Client Access media, and you may install
certain parts of it such as iSeries Navigator and teh ODBC drivers
even without paying for a license for the entire product. Other parts
such as 5250 emulation and Data Transfer require the license to be
purchased.

HTH,
Charles

On Tue, May 18, 2010 at 12:15 PM, Mike Pavlak <Mike.Pavlak@xxxxxxxx> wrote:

From Windows I believe you have two options.  The low cost ODBC drivers

that are part of Client Access and DB2 Connect.  Neither is free, but
both should give you connectivity.

Regards,

Mike

mike.p@xxxxxxxx   Cell: (408)679-1011    Office: (815)722-3454

Zend Server for IBM i Beta avilable at
http://www.zend.com/en/products/server/zend-server-5-new-ibmi



-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of MattLavinder@xxxxxxxxxxxxxxxxxxx
Sent: Tuesday, May 18, 2010 10:32 AM
To: Web Enabling the AS400 / iSeries
Cc: web400@xxxxxxxxxxxx; web400-bounces@xxxxxxxxxxxx
Subject: Re: [WEB400] Connecting to DB2/400 from PHP 5.3 under Windows


Interesting.  Upon doing some more research, the PHP Documentation
mentions
"DB2 Connect".  It appears that is a separately licensed feature that is
most likely required for the Db2 functions to work cross platform.  Can
someone confirm that this is correct?

I am aware that PHP on Windows has generic ODBC functions that will
almost
certainly meet my needs.

I am trying to connect to Db2/400 from PHP 5.3 under Windows 7.  I am
getting the following message when I try to execute my SQL query:

[17-May-2010 12:44:13] PHP Warning:  db2_conn_errormsg(): [IBM][CLI

Driver]

SQL1032N  No start database manager command was issued.

SQLSTATE=57019

SQLCODE=-1032

Any idea what is causing this?

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

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