Re: VMS x86-64 database server

On 7/7/2025 5:36 PM, Arne Vajhøj wrote:

On 7/7/2025 5:06 PM, Mark Berryman wrote:

On 7/7/25 12:01 PM, Arne Vajhøj wrote:

I do use your PHP.
>
But I do not have pgsql and pdo_pgsql loaded.
>
$ pipe php -i | search sys$input php,version/match=and
PHP Version => 8.1.23
$ pipe php -i | search sys$input pdo
...
PDO
PDO support => enabled
PDO drivers => mysql
pdo_mysql
PDO Driver for MySQL => enabled
...
>
The funny thing is that unlike most other extensions
then PHP_PGSQL.EXE and PHP_PDO_PGSQL.EXE exist
as seperate files. But even if I try to load them in
php.ini, then nothing.
>
I must be missing something. Probably something basic,
but ...

>
Some of the extensions were built as separate loadable modules either due to their size or because they require separate optional libraries that not everyone has.  All that is necessary to load them is to have the following in php_root:[000000]php.ini:
>
extension=php_pdo_pgsql.exe
extension=php_pgsql.exe
>
and to make sure that php.ini is readable by the account running php (and, of course, for libpq from VSI to be installed).

 First I did not have anything for pgsql in php.ini
and second I tried without php_ prefix.
 Loading with php_ prefix and everything works!

$ type TestPDO.php
<?php
$con = new PDO('pgsql:host=localhost;port=5435;dbname=test', 'sa', 'hemmeligt');
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$con->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$stmt = $con->prepare('SELECT f1,f2 FROM t1');
$stmt->execute(array());
while($row = $stmt->fetch()) {
     $f1 = $row['f1'];
     $f2 = $row['f2'];
     echo "$f1 $f2\r\n";
}
?>
$ php TestPDO.php
1 A
2 BB
3 CCC
Arne