Problem using ingres PHP driver v2

padst01 · 2008-10-02

Hi,

I'm trying to use ingres PHP driver v2 and get errors on queries.
I am using the attached test script. The query runs fine using isql tool from the same machine, but fails with following error in the script :

Ingres EXT Version is 2.0.0, Ingres API Version is 6
>> Connection succeeded.

Error during query : 2500
Error during query : Syntax error on line 1. Last symbol read was: 'scroll'.
Error during query : 42000
i died

What do I do wrong ?

Thanks for your help,

Ti'Stef

notnull · 2008-10-07

Try changing the order of the arguments passed to the ingres_query function so that $conn is second in the argument list.

Code:

$rc=ingres_query("select ap_id, ap_iatacode, ap_place, ap_name, ap_ccode from airport", $conn);

padst01 · 2008-10-07

Hi Notnull,

With some assistance, I found where the problem was: PHP Driver and application run against a 2006r3 beta client, connecting to a 2006r2 server. PHP driver currently does not detect features supported by the server (it detects the features of the client it runs on), so the query failed because of new scrolling cursors feature not being supported in R2 while these are supported by R3.

So if I want to make this work, I need tu use the same version between Server and Client.

Stephane

2008-10-07	#2 (permalink)
notnull Member Join Date: Mar 2007 Posts: 73	Try changing the order of the arguments passed to the ingres_query function so that $conn is second in the argument list. Code: $rc=ingres_query("select ap_id, ap_iatacode, ap_place, ap_name, ap_ccode from airport", $conn);

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

2008-10-07	#3 (permalink)
padst01 Junior Member Join Date: Mar 2007 Posts: 4	Hi Notnull, With some assistance, I found where the problem was: PHP Driver and application run against a 2006r3 beta client, connecting to a 2006r2 server. PHP driver currently does not detect features supported by the server (it detects the features of the client it runs on), so the query failed because of new scrolling cursors feature not being supported in R2 while these are supported by R3. So if I want to make this work, I need tu use the same version between Server and Client. Stephane