Install ingres extension for php on my WAMP server

Question

I've a development computer, which runs under windows.

For a project, I've to make a php website which has to connect to an Ingres database server.

So I installed wamp, I installed ingres(server and client, on my local machine).

I added the library that I found on their site(php_ingres.dll) in the C:\wamp\bin\php\php5.3.5\ext folder, and I added a line "extension=php_ingres.dll" in the configuration file.

I shutdown wamp and restarted it, and I restarted the server, I see now a check mark in the wamp menu, indicating that php_ingres is now activated. But when I go to the welcome page of the server, I don't see this extension as loaded. If I go on the php info page, I don't see any Ingres entry in the Configure Command.

I just can't found any post/tutorial/... which indicating how to do this operation, so any help would be appreciated!

Thank you!

Edit: I made a small test to see if I can connect to an Ingres database:

    <?php
$link = ingres_connect("localhost", "demodbtest", "demodbtest")  or die("Connexion impossible");
echo "Connexion réussie";

$result = ingres_query($link,"select * from airline");

while ($row = ingres_fetch_array($result)) {
    echo $row["al_iatacode"];  // utilisation du tableau associatif
    echo $row["al_name"];
    echo $row["al_ccode"];          // utilisation du tableau à indices numériques
    echo "</br>";
}
ingres_close($link);
?>

And I get this error:

( ! ) Fatal error: Call to undefined function ingres_connect() in C:\wamp\www\tests\index.php on line 2

Some information on my installation: I've a windows 7 pro 32bits Wampserver 2.1 ( http://sourceforge.net/projects/wampserver/files/WampServer%202/WampServer%202.1/WampServer2.1e-x32.exe/download ) Apache 2.2.17
PHP 5.3.5
Ingres 10.1.0 Community edition( downloaded here: http://esd.ingres.com/product/Community_Projects/Ingres_Database/Windows_32-Bit/Ingres_10.1_Build_121/ingres-10.1.0-121-gpl-win-x86-NoDoc.zip/http ) PHP drivers downloaded here: http://esd.ingres.com/product/drivers/PHP/Windows_32-Bit/PHP_Driver

Answer 1

The problem is that I wasn't having the ingres client installed locally, so it appears that this lib cannot works without it

Answer 2

Double check your extension_dir setting as well as the actual php.ini file being used. Calling php.exe -i from the command line might not give the same output if executing phpinfo() in a script via Apache (or IIS). In fact http://www.wampserver.com/en/faq.php says there are 3 potential php.ini scripts.

Answer 3

To practically test if the extension was loaded you can as well call one of it's functions. If the extension was loaded, you should not get a fatal error for a missing function. That's perhaps one of the quickest checks.

Another check is to make use of extension_loaded ^{*PHP Manual**} which will give you a list of all loaded extensions. See the PHP Manual link above for more info.

The configure line

The configure line will not show the ingres extension because it has not been compiled in. That's perfectly alright because you load it as an extension (.dll) so it's not part of php.exe. This is why you don't see it in the configure line.

Locating ingres on the phpinfo() page.

On the phpinfo()-page use the search function inside your browser (often CTRL+F) and try to locate the word ingres. You should locate a section that displays the extensions default settings if it has been loaded.

The following is an example screenshot for the xdebug extension. This might look similar for ingres:

Image from: Launching xdebug in Eclipse stuck at 57% - How to trouble-shoot?