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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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.