Re: PHP - remote connection to SQL Server from Zend CoreoniSeries

Wow. That turned out to be really simple. Made a connection and
retrieved a row of data on the first attempt. That's the kind of
simplicity I like!

Thanks,
Kelly

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Mike Pavlak
Sent: Tuesday, July 07, 2009 8:51 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] PHP - remote connection to SQL Server from Zend
CoreoniSeries

Kelly,

Have you checked out Page 160 of the "Zend Core for i5/OS User Guide"?
This section discusses the configuration steps for MS SQL Server on i5.
The FREETDS files should already be there and you may use an IP address
instead of a DNS entry. DNS would be a convenience so you don't have
hard-coded IP's. Your LAN team admin may have a local DNS server where
they have these entries installed. The user guide is available online
here: http://files.zend.com/help/Zend-Core-i5/zend-core-i5.htm (search
mssql and you should get to link:
http://files.zend.com/help/Zend-Core-i5/appendix_a.htm ) and can be
downloaded in PDF format from here:
http://www.zend.com/topics/Zend-Core-User-Guide-i5OS-V261.pdf


Regards,

Mike

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


-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Kelly Cookson
Sent: Monday, July 06, 2009 3:26 PM
To: web400@xxxxxxxxxxxx
Subject: [WEB400] PHP - remote connection to SQL Server from Zend Core
oniSeries

We run a custom order entry system using a DB2 database on an iSeries
(V5R4). We also run PeopleSoft Receivables on a Microsoft SQL Server
database. I want to write PHP scripts that can display data from both
the DB2 database and the SQL Server database.



I'm running the Zend Core on the iSeries. I can easily access DB2 data
on the iSeries using the PHP Toolkit. No problem there.



But how do I connect to a remote SQL Server database from a PHP script
running in the Zend Core on an iSeries? Most of the online tips I have
seen talk about setting up a DNS to the SQL Server database. Can I set
up DNS for a SQL Server database on an iSeries (V5R4)? If so, where can
I find the instructions for doing so?



Thanks,

Kelly Cookson

Senior Programmer\Analyst

Dot Foods, Inc.