Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ads_fetch_row with ADS10

3 posts in PHP Last posting was on 2011-02-22 09:02:03.0Z
DevZone.AdvantageDatabase.com Posted on 2011-01-22 21:37:21.0Z
From: "DevZone.AdvantageDatabase.com" <carsten.kruse@sport-tiedje.de>
Newsgroups: Advantage.PHP
Subject: ads_fetch_row with ADS10
Date: Sat, 22 Jan 2011 22:37:21 +0100
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8089.726
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726
NNTP-Posting-Host: 188.96.175.20
Message-ID: <4d3bfa8a$1@solutions.advantagedatabase.com>
X-Trace: 23 Jan 2011 01:53:14 -0800, 188.96.175.20
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.PHP:1111
Article PK: 1135595

Hi all,

we want to upgrade from Ads 8.1 (32 bit) to 10.0 (64 bit, windows 2008
server).
For testing the new system I have an eval license for ADS 10.x.
The ADS 10.0 server was easily installed and I copied the tables from the
ADS 8.1 machine to the new one.
I can see the data by using the Advantage Data Architect.

Now I want to connect to the DataDirectory by using the ads-php driver from
a linux 64 bit debian system.
I have compiled php-5.2.12 with-advantage and everything looks fine.
But if I try to query some data (via apache2) ads_fetch_row($rStmt) hangs.
There is no error message - the script will not finish.
But if I execute the script at the command line I get the results.

$adslink = ads_connect(
"DataDirectory=\\\\winserver\\data\\;ServerTypes=2", "", "" );
if (!$adslink) {
echo "NO ADS Connection\n";
} else {
echo "ADS Connection!<br>\n";
$rStmt = ads_prepare( $adslink, "SELECT artnr FROM art WHERE artnr LIKE
?" );
$aParams = array( 1 => '060586' );
$rResult = ads_execute( $rStmt, $aParams );
if ( ads_fetch_row( $rStmt ) ) {
$artnr = ads_result( $rStmt, "artnr" );
echo "Article: ".$artnr."<br>\n";
}
ads_close($adslink);
}

A basic connection with ads_connect and ads_close is no problem.

Did I miss anything?
Do you have any ideas?

Thanks,
Carsten


Carsten Kruse Posted on 2011-01-25 16:09:02.0Z
From: "Carsten Kruse" <carsten.kruse@sport-tiedje.de>
Newsgroups: Advantage.PHP
References: <4d3bfa8a$1@solutions.advantagedatabase.com>
Subject: Re: ads_fetch_row with ADS10
Date: Tue, 25 Jan 2011 17:09:02 +0100
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5994
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 188.96.163.241
Message-ID: <4d3ef5b1@solutions.advantagedatabase.com>
X-Trace: 25 Jan 2011 08:09:21 -0800, 188.96.163.241
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.PHP:1112
Article PK: 1135596

Hi,

there is still no success when I try to query data (via apache2) with the
linux 64bit php-extension 10.0 on the ADS database server 10.00.0.3 hosted
on windows server 2008 r2.

The follwing work fine:
- I am able to query data with the same script with the linux 32bit
php-extension 8.10 on the ADS database server 10.00.0.3 hosted on windows
server 2008 r2.
- I am able to do updates with the linux 64bit php-extension on the ADS
database server 10.00.0.3 hosted on windows server 2008 r2.
- I am able to query data with the linux 64bit php-extension on the ADS
database server 10.00.0.3 hosted on windows server 2008 r2 if I excute the
script at the command line.

I get no errors in the ads_err when ads_fetch_row hangs.

Is there something wrong with the linux 64bit php-extension for apache?

Carsten


Carsten Kruse Posted on 2011-02-22 09:02:03.0Z
From: "Carsten Kruse" <carsten.kruse@sport-tiedje.de>
Newsgroups: Advantage.PHP
References: <4d3bfa8a$1@solutions.advantagedatabase.com> <4d3ef5b1@solutions.advantagedatabase.com>
Subject: Re: ads_fetch_row with ADS10
Date: Tue, 22 Feb 2011 10:02:03 +0100
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5994
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 188.96.172.115
Message-ID: <4d637b5d@solutions.advantagedatabase.com>
X-Trace: 22 Feb 2011 01:01:17 -0800, 188.96.172.115
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.PHP:1120
Article PK: 1135604

Hi,

finally rebuilding the apache2 webserver solved the problem.
The ads php extension did not work with the precompiled apache2 packages
(tested in debian squeeze and suse 11.2).

Carsten