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.

6610

2 posts in PHP Last posting was on 2009-05-07 06:27:18.0Z
Ivan Vuj?i? Posted on 2009-04-28 12:15:03.0Z
From: "Ivan Vuj?i?" <ivan.vujcic@fortuno.hr>
Newsgroups: Advantage.PHP
Subject: 6610
Date: Tue, 28 Apr 2009 14:15:03 +0200
Lines: 57
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 195.29.44.250
Message-ID: <49f6f31f@solutions.advantagedatabase.com>
X-Trace: 28 Apr 2009 06:14:23 -0700, 195.29.44.250
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.29.44.250
Xref: solutions.advantagedatabase.com Advantage.PHP:1005
Article PK: 1135489

http://img527.imageshack.us/img527/667/adsg.jpg

On upper image you can see how my architecture is.
Sometimes my php webpage hangs and get error 6610 from Advantage.
"
[Extended Systems][Advantage SQL][ASA] Error 6610: The Advantage Database
Server did not respond to a database request in a timely manner. A
communications problem has occurred. Search for 6610 in the Advantage
Knowledge Base for possible solutions. axServerConnect.
"

After restarting apache everything is working as before.
This error message is poping randomly. Sometimes it works ok for 4-5 days
and sometimes I have to restart apache 5 times in 2 min.
One more hint: ads 8.1. on novell netware is serving about 100 *.dbf tables
for clipper program all the time and they don't get 6610 error only apache,
ads8.1 is always on line as win2003 with apache and they are in LAN network.

I have change more than 20 different httpd.config and always get same 6610
error.
When I have less than 30 requerst (server-info) speed is ok but it
exponentially slows above 40 request and on more than 50 request it stops.
Sometimes it hangs on 5 requests.
Some connections are for
$rConn
=ads_connect("DataDirectory=\\\\Serv-boso-p\\PODACI\\velep\\PROIZVOD\\voce\\voce.add",
"sql_user", "sql_lozinka");
or
$rConn =
ads_connect("DataDirectory=\\\\SERV-BOSO-P\\PODACI\\VELEP\\CENTRALA\\;ServerType=2;DefaultType=FOXPRO;Rows=false;"
, "" , "");
or
$rConn2 =
ads_connect("DataDirectory=\\\\SERV-BOSO-P\\PODACI\\DISKONT\\;ServerType=2;DefaultType=Clipper;Rows=false;"
, "" , "");

I have in php
if ( $rConn == False )
{
$strErrCode = ads_error( );
$strErrString = ads_errormsg( );
echo $strErrCode . " " . $strErrString;
}
and get this:
[Extended Systems][Advantage SQL][ASA] Error 6610: The Advantage Database
Server did not respond to a database request in a timely manner. A
communications problem has occurred. Search for 6610 in the Advantage
Knowledge Base for possible solutions. axServerConnect.



How to solve this problem?

Thanks in advance,
Ivan Vujcic


Ivan Vuj?i? Posted on 2009-05-07 06:27:18.0Z
From: "Ivan Vuj?i?" <ivan.vujcic@fortuno.hr>
Newsgroups: Advantage.PHP
References: <49f6f31f@solutions.advantagedatabase.com>
Subject: Re: 6610
Date: Thu, 7 May 2009 08:27:18 +0200
Lines: 66
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 195.29.44.250
Message-ID: <4a027f1f@solutions.advantagedatabase.com>
X-Trace: 7 May 2009 00:26:39 -0700, 195.29.44.250
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.29.44.250
Xref: solutions.advantagedatabase.com Advantage.PHP:1007
Article PK: 1135492


"Ivan Vuj?i?" <ivan.vujcic@fortuno.hr> wrote in message
news:49f6f31f@solutions.advantagedatabase.com...
> http://img527.imageshack.us/img527/667/adsg.jpg
>
> On upper image you can see how my architecture is.
> Sometimes my php webpage hangs and get error 6610 from Advantage.
> "
> [Extended Systems][Advantage SQL][ASA] Error 6610: The Advantage Database
> Server did not respond to a database request in a timely manner. A
> communications problem has occurred. Search for 6610 in the Advantage
> Knowledge Base for possible solutions. axServerConnect.
> "
>
<CUT>
> How to solve this problem?

Me: Horatio! Link to server is dead, 6610 error. My users are very angry and
my boss is threatening with dismissal.

H: (Putting down sunglasses) Did you check on win2003 server?

Me: Yes I did Horatio;

H: Hm... How about http.conf file, did you try to change it and see how it
is working?

Me: Well, I have change about 20-30 different configuration, also I have
change apache server from 2.2.4 to 2.2.11 and still get 6610 error.

H: Now it is very interesting...something tells me that your php is not
working as we expect..!?

Me: Horatio, I have change php.ini and upgrade from php 5.2.3 to 5.2.9-2 and
same 6610 error is showing.

H: Yes....but did you check advantage php version?

Me: Advantage PHP version is 8.10.0.6.

H: And what is version Advantage database server on Novell?

Me: Version is 8.10.0.17!?

H: Well, this can be a problem!

H: Download newer version, 8.10.0.38 Advantage PHP from
http://devzone.advantagedatabase.com/dz/content.aspx?key=20&Release=10&Product=16&Platform=6.

H: De-install old version,

H: install new version,

H: copy from C:\Program Files\Extended Systems\Advantage
8.1\PHP\Redistribute

H: files ace32.dll,adsloc32.dll,adsodbc.dll,axcws32.dll to windows\system32
and overwrite old ones.

Me: Horatio!! Link is alive and server is ready again, no 6610 error!

H: (Putting sunglasses back on) We found our killer!!!

Yeaaaaahhhhhhhhh !!!!!