Subject | Re: [firebird-php] Firebird 3 with PHP 7 ubuntu |
---|---|
Author | marius adrian popa |
Post date | 2017-05-16T13:32:30Z |
On Tue, May 16, 2017 at 4:29 PM, Leonardo Procopio leonardolp@... [firebird-php] <firebird-php@yahoogroups.com> wrote:Marius, what version of your PHP?Em ter, 16 de mai de 2017 às 10:08, marius adrian popa mapopa@... [firebird-php] <firebird-php@yahoogroups.com> escreveu:Ubuntu 17.04<?phpprint_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.phpArray([0] => firebird)1On Tue, May 16, 2017 at 3:30 PM, marius adrian popa <mapopa@...> wrote:I use default pdo driver from ubuntuOn 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 clientOn 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. 111/3050:test;charset=WIN1252' , $user, $pass);
print_r($ PDO->getAttribute(PDO::ATTR_ CONNECTION_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:
Connecting ... Passed!
Server version: LI-V6.3.0.32483 Firebird 3.0
Attempting to connect to services manager ... Passed!
Disconnecting from database ... Passed!