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.

linux php extension 5.3.x ads_connect() 6060 error

2 posts in PHP Last posting was on 2010-07-06 16:26:54.0Z
Neil Posted on 2010-07-05 12:11:31.0Z
Reply-To: "Neil" <neil@neilanddeb.com>
From: "Neil" <neil@neilanddeb.com>
Newsgroups: advantage.PHP
Subject: linux php extension 5.3.x ads_connect() 6060 error
Date: Mon, 5 Jul 2010 13:11:31 +0100
Lines: 41
Organization: CSL
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.5931
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 80.195.69.18
Message-ID: <4c31cb4a@solutions.advantagedatabase.com>
X-Trace: 5 Jul 2010 06:08:42 -0700, 80.195.69.18
Path: solutions.advantagedatabase.com!80.195.69.18
Xref: solutions.advantagedatabase.com Advantage.PHP:1090
Article PK: 1135574

Hi,
I'm having problems connecting to an Advantage Database Server for a linux
machine using ads_connect() and the ADS PHP Extension...

I've connected to the ADS from a windows server on my pc using this
connection string...

'dsnString' => "DataDirectory=\\\\ads01\\HQM
Service\\HQDATA-TEST\\HQMDATA.add;ServerTypes=2;DataDictionary=true;TrimTrailingSpaces=true",

I've tried the following for the linux box, as well as the above and a few
other strings

'dsnString' => "DataDirectory=\\\\172.19.0.48:3123\\HQM
Service\\HQDATA-TEST\\HQMDATA.add;DefaultType=Advantage;ServerTypes=2;TrimTrailingSpaces=TRUE;DataDictionary=true"
gives error: Warning: SQL error: [iAnywhere Solutions][Advantage SQL][ASA]
Error 6097: Bad IP address or port specified in the connection path or in
the ADS.INI file. axServerConnect, SQL state HY000 in SQLDriverConnect in
/var/www/localhost/htdocs/utilities/testAdvantageConnection.php on line 23

'dsnString' => "DataDirectory=\\\\ads01\\HQM
Service\\HQDATA-TEST\\HQMDATA.add;DefaultType=Advantage;ServerTypes=2;TrimTrailingSpaces=TRUE;DataDictionary=true"
give error: Warning: SQL error: [iAnywhere Solutions][Advantage SQL][ASA]
Error 6060: Advantage Database Server not available on specified server.
axServerConnect, SQL state HY000 in SQLDriverConnect in
/var/www/localhost/htdocs/utilities/testAdvantageConnection.php on line 23

does the space in the path (HQM Service) need escaping, I've tried %20 and
+.

I get the 6060 error when I use just the IP address, and I get the 6097
error whenever I add the port.

I've also tried enabling ip forwarding and checked the host file for
incorrect IP addresses, I'm not sure where the ads_log.txt file is that's
mentioned in the error 6060 help file.

Thanks,
Neil


Neil Posted on 2010-07-06 16:26:54.0Z
Reply-To: "Neil" <neil@neilanddeb.com>
From: "Neil" <neil@neilanddeb.com>
Newsgroups: advantage.PHP
References: <4c31cb4a@solutions.advantagedatabase.com>
Subject: Re: linux php extension 5.3.x ads_connect() 6060 error
Date: Tue, 6 Jul 2010 17:26:54 +0100
Lines: 48
Organization: CSL
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.5931
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 80.195.69.18
Message-ID: <4c3358a8@solutions.advantagedatabase.com>
X-Trace: 6 Jul 2010 10:24:08 -0700, 80.195.69.18
Path: solutions.advantagedatabase.com!80.195.69.18
Xref: solutions.advantagedatabase.com Advantage.PHP:1091
Article PK: 1135575

Sorted this, firewall on the test server and wrong ServerTypes should have
been 4 or 6

"Neil" <neil@neilanddeb.com> wrote in message
news:4c31cb4a@solutions.advantagedatabase.com...
> Hi,
> I'm having problems connecting to an Advantage Database Server for a linux
> machine using ads_connect() and the ADS PHP Extension...
>
> I've connected to the ADS from a windows server on my pc using this
> connection string...
>
> 'dsnString' => "DataDirectory=\\\\ads01\\HQM
> Service\\HQDATA-TEST\\HQMDATA.add;ServerTypes=2;DataDictionary=true;TrimTrailingSpaces=true",
>
> I've tried the following for the linux box, as well as the above and a few
> other strings
>
> 'dsnString' => "DataDirectory=\\\\172.19.0.48:3123\\HQM
> Service\\HQDATA-TEST\\HQMDATA.add;DefaultType=Advantage;ServerTypes=2;TrimTrailingSpaces=TRUE;DataDictionary=true"
> gives error: Warning: SQL error: [iAnywhere Solutions][Advantage SQL][ASA]
> Error 6097: Bad IP address or port specified in the connection path or in
> the ADS.INI file. axServerConnect, SQL state HY000 in SQLDriverConnect in
> /var/www/localhost/htdocs/utilities/testAdvantageConnection.php on line 23
>
> 'dsnString' => "DataDirectory=\\\\ads01\\HQM
> Service\\HQDATA-TEST\\HQMDATA.add;DefaultType=Advantage;ServerTypes=2;TrimTrailingSpaces=TRUE;DataDictionary=true"
> give error: Warning: SQL error: [iAnywhere Solutions][Advantage SQL][ASA]
> Error 6060: Advantage Database Server not available on specified server.
> axServerConnect, SQL state HY000 in SQLDriverConnect in
> /var/www/localhost/htdocs/utilities/testAdvantageConnection.php on line 23
>
> does the space in the path (HQM Service) need escaping, I've tried %20 and
> +.
>
> I get the 6060 error when I use just the IP address, and I get the 6097
> error whenever I add the port.
>
> I've also tried enabling ip forwarding and checked the host file for
> incorrect IP addresses, I'm not sure where the ads_log.txt file is that's
> mentioned in the error 6060 help file.
>
> Thanks,
> Neil
>
>
>