Here's my log file. The two lines i highlighted seem significant to me.
If the first one means that it can't find the IP address, I'm not
surprised that it can't find the server. Any ideas why?



util.c:288:Starting log file for FreeTDS 0.64
on 2009-09-30 18:19:07 with debug flags 0x4fff.
iconv.c:361:iconv to convert client-side data to the "ISO-8859-1"
character set
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
login.c:209:IP address pointer is empty
login.c:211:Server FBC_DEV_106 not found!
mem.c:519:tds_free_all_results()
dblib.c:4978:in dbfreebuf()




Larry Kleinman
Kleinman Associates, Inc.
212-949-6469
203-255-4100



"Porterfield, Sean" <SPorterfield@xxxxxxxxxxxxxxxxxxxxxxx>
Sent by: web400-bounces@xxxxxxxxxxxx
09/30/2009 04:29 PM
Please respond to
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>


To
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
cc

Subject
Re: [WEB400] PHP and microsoft sql server






Aha, I needed to use DOMAIN\user instead of user in the connect. Now I
get a permission error which is MUCH better!
--
Sean Porterfield

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Kelly Cookson
Sent: Wednesday, September 30, 2009 15:17
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] PHP and microsoft sql server

I'm not an expert on freetds by any means. This stuff is all new to me as
well.

When I log into "myserver.mydomain.com" using Remote Desktop, and open the
Microsoft SQL Server Management Studio, I see the following in the left
navigation window:

- MYSERVER (SQL Server 9.0.3042)
- Databases
+ System Databases
+ Database Snapshots
+ MYDATABASE
+ DATABASE2
+ DATABASE3

My entry into the freetds.conf file is:

# PeopleSoft FIN88QA database (Microsoft SQL Server 2000 configuration)

[MYDATABASE]
host = myserver.mydomain.com
port = 1433
tds version = 8.0

I'm actually using a text name for the host, not numbers. It looks like
"myserver.mydomain.com". It does not look like 123.456.789.0. I assume it
would work either way, though.

Here is a PHP script that works for me (all names have been changed to
protect the innocent):

<html>
<head></head>
<body>
<table border="1">
<tr><th>Business Unit</th><th>Customer</th><th>Item</th></tr>
<?php
$conn = mssql_connect('MYDATABASE', 'username', 'password');
if ($conn) {
mssql_select_db("MYDATABASE");
$customer = "12345";
$query = "SELECT BU,CUSTOMER,ITEM FROM MYTABLE WITH(NOLOCK)
WHERE CUSTOMER='$customer'";
$result = mssql_query($query);
while ($record = mssql_fetch_array($result)) {
print ("<tr><td>" . $record["BU"] . "</td><td>" .
$record["CUSTOMER"] . "</td><td>" . $record["ITEM"] . "</td></tr>");
}
}
?>
</table>
</body>
</html>

I assume you know the username and password are for the SQL Server
database--not an AS400 username and password.

If it's still giving you problems, you can submit a support ticket with
Zend and/or ask for help at the Zend forums.

Kelly

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Larry Kleinman
Sent: Wednesday, September 30, 2009 1:36 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] PHP and microsoft sql server

No good....I got the same result. But I'm confused: there are
several
different databases on this particular SQL server. I thought that the
name in the freetds file is just a name that matches the name in the
mssql_connect statement (so that it can find the server), which means it

can be any name we want; and the name in the mssql_select_ statement must
match the name of the particular database to which we want to connect
(which is called FBC_DEV_106)


Larry Kleinman
Kleinman Associates, Inc.
212-949-6469
203-255-4100



"Kelly Cookson" <KCookson@xxxxxxxxxxxx> Sent by:
web400-bounces@xxxxxxxxxxxx
09/30/2009 01:56 PM
Please respond to
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>


To
"Web Enabling the AS400 / iSeries" <web400@xxxxxxxxxxxx>
cc

Subject
Re: [WEB400] PHP and microsoft sql server






It looks like you are trying to use two different names for the
database. If you make this entry into the freetds.conf file:

# PeopleSoft FIN88QA database (Microsoft SQL Server 2000 configuration)
[FBC_DEV_106]
host = 192.168.100.5
port = 1433
tds version = 8.0

then your PHP code should look like this:

$conn = mssql_connect('FBC_DEV_106','username','password');
if ($conn) {
mssql_select_db("FBC_DEV_106");

On the other hand, if you make this entry into the freetds.conf file:

# PeopleSoft FIN88QA database (Microsoft SQL Server 2000 configuration)
[FEDBAR]
host = 192.168.100.5
port = 1433
tds version = 8.0

then your PHP code should look like this:

$conn = mssql_connect('FEDBAR','username','password');
if ($conn) {
mssql_select_db("FEDBAR");

Please try making those changes and see if it works. In terms of log
files, I don't know whether freetds generates log files or where they
would be kept.

Kelly

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Larry Kleinman
Sent: Wednesday, September 30, 2009 11:46 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] PHP and microsoft sql server

Kelly - thanks for the advice. Unfortunately, I don't seem to be
connecting to the SQL server. Is there some log that I can look at that

would tell me what is going wrong. Below is the PHP script.

<html>
<head></head>
<body>
Here is some stuff
<table border = "1">
<tr><th>Column Name 1</th><th>Column Name 2</th><th>Column Name
3</th><th>Sequence</th><th>Desc</th></tr>
<?php
$conn = mssql_connect('FedBar','Sa','Fbc');
if ($conn) {
mssql_select_db("FBC_DEV_106");
$query = "SELECT * FROM MYTABLE"; }
?>
</table>
</body>
</html>



Here is the addition to the freetds file that I made (the rest of the
file
is unchanged from how it was shipped)

# Fed Bar Microsoft SQL Server 2000 configuration
[FedBar]
192.168.100.5
port = 1433
tds version = 8.0


Larry Kleinman
Kleinman Associates, Inc.
212-949-6469
203-255-4100



"Kelly Cookson" <KCookson@xxxxxxxxxxxx>
Sent by: web400-bounces@xxxxxxxxxxxx
09/25/2009 05:06 PM
Please respond to
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>


To
"Web Enabling the AS400 / iSeries" <web400@xxxxxxxxxxxx>
cc

Subject
Re: [WEB400] PHP and microsoft sql server






Yes. Open iSeries Navigator and go to this folder:

/usr/local/Zend/Core/etc

Look for the file named:

freetds.conf

Make a copy of the file for backup. Then open the file for editing (I
move it to my desktop and use NotePad). Scroll down to the bottom of the
file. You need to make an entry like this one:

# SQL Server database named MYDATA (Microsoft SQL Server 2000
configuration)
[MYDATA]
host = myserver.mydomain.com
port = 1433
tds version = 8.0

Look at the examples and be sure to use the format appropriate for your
version of SQL Server. Save the configuration file.

The PHP code looks something like this:

$conn = mssql_connect('MYDATA','username','password');
if ($conn) {
mssql_select_db("MYDATA");
$query = "SELECT * FROM MYTABLE";
$result = mssql_query($query);
$row = mssql_fetch_array($result);
<process $row as desired>
}

Hope this helps.
Kelly

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Larry Kleinman
Sent: Friday, September 25, 2009 3:48 PM
To: Web Enabling the AS400 / iSeries
Subject: [WEB400] PHP and microsoft sql server

Is there something special that needs to be done in order to have a PHP
script - running either on Zend or on a non-system i server - talk to
SQL
Server?


Larry Kleinman
Kleinman Associates, Inc.
212-949-6469
203-255-4100

This email is confidential, intended only for the named recipient(s) above
and may contain information that is privileged. If you have received this
message in error or are not the named recipient(s), please notify the
sender immediately and delete this email message from your computer as any
and all unauthorized distribution or use of this message is strictly
prohibited. Thank you.

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.