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.

[Advantage ODBC Driver]Driver not Capable

2 posts in PHP Last posting was on 2009-02-05 07:22:56.0Z
Amanda Warren Posted on 2009-02-05 05:12:16.0Z
Reply-To: "Amanda Warren" <amanda@austrans.biz>
From: "Amanda Warren" <amanda@austrans.biz>
Newsgroups: advantage.PHP
Subject: [Advantage ODBC Driver]Driver not Capable
Date: Thu, 5 Feb 2009 15:12:16 +1000
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 61.88.47.250
Message-ID: <498a7521@solutions.advantagedatabase.com>
X-Trace: 4 Feb 2009 22:12:01 -0700, 61.88.47.250
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!61.88.47.250
Xref: solutions.advantagedatabase.com Advantage.PHP:957
Article PK: 1135440

The following code:

echo "Basic Connect<br>\n";
$rConn =
ads_connect("DataDirectory=\\\\<UNC>\\<DataDirectory>\\<DataDictionary>;ServerTypes=2",
"User", "Password", "" );
echo "Connect<br>\n";
$query = "SELECT * FROM Stock ORDER BY [Code]";
$resultid = ads_do($rConn, $query);
echo "Query run<br>\n";
$Code = ads_result($resultid, "Code" );
echo "{$Code}<br>\n";


generates the following screen (I discovered these errors after turning on
display_err because my SQL appeared to be returning nothing):

Basic Connect

Warning: SQL error: [iAnywhere Solutions][Advantage ODBC Driver]Driver not
capable, SQL state S1C00 in SQLSetConnectOption in
C:\Inetpub\wwwroot\Php\Untitled-2.php on line 14
Connect

Warning: ads_do(): supplied argument is not a valid Advantage-Link resource
in C:\Inetpub\wwwroot\Php\Untitled-2.php on line 17
Query run

Warning: ads_result(): supplied argument is not a valid Advantage result
resource in C:\Inetpub\wwwroot\Php\Untitled-2.php on line 19


Warning: ads_close(): supplied argument is not a valid Advantage-Link
resource in C:\Inetpub\wwwroot\Php\Untitled-2.php on line 22
Closed


What does this mean and how do I fix it? I realize that it is the first
error that causes the subsequent errors but I've got no idea what it means.
Any help would be appreciated.

Regards,

Amanda Warren


Amanda Warren Posted on 2009-02-05 07:22:56.0Z
Reply-To: "Amanda Warren" <amanda@austrans.biz>
From: "Amanda Warren" <amanda@austrans.biz>
Newsgroups: advantage.PHP
References: <498a7521@solutions.advantagedatabase.com>
Subject: Re: [Advantage ODBC Driver]Driver not Capable
Date: Thu, 5 Feb 2009 17:22:56 +1000
Lines: 55
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 61.88.47.250
Message-ID: <498a93c4@solutions.advantagedatabase.com>
X-Trace: 5 Feb 2009 00:22:44 -0700, 61.88.47.250
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!61.88.47.250
Xref: solutions.advantagedatabase.com Advantage.PHP:958
Article PK: 1135442

Never mind, solved it myself. Turns out that you can't run PHP extension
V9.1 with ADS V8.1. I upgraded to ADS V9.1 and it works perfectly. I should
have thought of that in the first place!

Amanda Warren

"Amanda Warren" <amanda@austrans.biz> wrote in message
news:498a7521@solutions.advantagedatabase.com...
> The following code:
>
> echo "Basic Connect<br>\n";
> $rConn =
> ads_connect("DataDirectory=\\\\<UNC>\\<DataDirectory>\\<DataDictionary>;ServerTypes=2",
> "User", "Password", "" );
> echo "Connect<br>\n";
> $query = "SELECT * FROM Stock ORDER BY [Code]";
> $resultid = ads_do($rConn, $query);
> echo "Query run<br>\n";
> $Code = ads_result($resultid, "Code" );
> echo "{$Code}<br>\n";
>
>
> generates the following screen (I discovered these errors after turning on
> display_err because my SQL appeared to be returning nothing):
>
> Basic Connect
>
> Warning: SQL error: [iAnywhere Solutions][Advantage ODBC Driver]Driver not
> capable, SQL state S1C00 in SQLSetConnectOption in
> C:\Inetpub\wwwroot\Php\Untitled-2.php on line 14
> Connect
>
> Warning: ads_do(): supplied argument is not a valid Advantage-Link
> resource in C:\Inetpub\wwwroot\Php\Untitled-2.php on line 17
> Query run
>
> Warning: ads_result(): supplied argument is not a valid Advantage result
> resource in C:\Inetpub\wwwroot\Php\Untitled-2.php on line 19
>
>
> Warning: ads_close(): supplied argument is not a valid Advantage-Link
> resource in C:\Inetpub\wwwroot\Php\Untitled-2.php on line 22
> Closed
>
>
> What does this mean and how do I fix it? I realize that it is the first
> error that causes the subsequent errors but I've got no idea what it
> means. Any help would be appreciated.
>
> Regards,
>
> Amanda Warren
>