× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.