Subject Re: [firebird-php] Firebird 3 with PHP 7 ubuntu
Author marius adrian popa
Post date 2017-05-16T13:08:16Z
Ubuntu 17.04

<?php
print_r (PDO::getAvailableDrivers ());
$PDO = new PDO ('firebird:dbname=localhost/3050:/tmp/test.fdb;charset=UTF8', 'sysdba', 'masterkey');
print_r($PDO->getAttribute(PDO::ATTR_CONNECTION_STATUS));
?>


php test.php
Array
(
    [0] => firebird
)
1



On Tue, May 16, 2017 at 3:30 PM, marius adrian popa <mapopa@...> wrote:
I use default pdo driver from ubuntu 


On Mon, May 15, 2017 at 11:57 PM, Leonardo Procopio leonardolp@... [firebird-php] <firebird-php@yahoogroups.com> wrote:
 

Thanks for the feedback.
I installed Firebird 3.0.2.32703 without problem, but I can not install the PDO driver for PHP.
What are you using to access Firebird 3 with PHP?

Em dom, 14 de mai de 2017 às 05:49, marius adrian popa mapopa@... [firebird-php] <firebird-php@yahoogroups.com> escreveu:
 

you need to install firebird 3.0.2 server and client , pdo is using the old client 


On Fri, May 12, 2017 at 4:08 PM, leonardolp@... [firebird-php] <firebird-php@yahoogroups.com> wrote:
 

But when I try to access with the code:

<? Php

print_r (PDO::getAvailableDrivers ());

echo '<hr>';

$PDO = new PDO ('firebird:dbname=111.111.11.1 11/3050:test;charset=WIN1252', $user, $pass);

print_r($ PDO->getAttribute(PDO::ATTR_CO NNECTION_STATUS));

?>


Returns:

Array ([0] => firebird [1] => mysql)

SQLSTATE [HY000] [335544472] Your user name and password are not defined. Ask your database administrator to set up a Firebird login.


I noticed that when I ran the command: apt-get install php7.0-pdo-firebird

He installed /usr/lib/firebird/2.5


What am I doing wrong?

Doing this remotely with ibexpert I can connect without error.


Attempting to connect to:

111.111.11.111/3050:teste

 

Connecting ... Passed!

Server version: LI-V6.3.0.32483 Firebird 3.0

 

Attempting to connect to services manager ... Passed!

 

Disconnecting from database ... Passed!