Detail

1. in Connector.php line 55
2. at PDO->__construct('firebird:dbname=localhost:/storage/firebird/name_database.FDB', 'sysdba', 'masterkey', array('0', '2', '0', false, false)) in Connector.php line 55

Somebody could help me?

I coded

composer require jacquestvanzuydam/laravel-firebird:dev-5.1-support

added to config/database.php

    'firebird' => [
        'driver'   => 'firebird',
        'host'     => env('DB_HOST', 'localhost'),
        'database' => '/storage/firebird/G_CHIOSCO.FDB',
        'username' => 'sysdba',
        'password' => 'masterkey',
        'charset'  => env('UTF8'),
    ],

added to config/app.php

Firebird\FirebirdServiceProvider::class,

added

DB_CHARSET=UTF8

I use in the same project also a mysql database, so in the model where i need this connection i coded

added to the stats.php model

protected $connection = 'firebird';

Thanks a lot look like great job and i would like try!

Hello, I have a problem with the library since the version of laravel 5.8.5 onwards, even probe with a clean installation and gives the same error

Argument 1 passed to Illuminate\Database\Connection::setReconnector() must be callable, null given, called in ...\vendor\laravel\framework\src\Illuminate\Database\DatabaseManager.php on line 179

My config/app.php

<?php

return [

    /*
    |--------------------------------------------------------------------------
    | Application Name
    |--------------------------------------------------------------------------
    |
    | This value is the name of your application. This value is used when the
    | framework needs to place the application's name in a notification or
    | any other location as required by the application or its packages.
    |
    */

    'name' => env('APP_NAME', 'Laravel'),

    /*
    |--------------------------------------------------------------------------
    | Application Environment
    |--------------------------------------------------------------------------
    |
    | This value determines the "environment" your application is currently
    | running in. This may determine how you prefer to configure various
    | services your application utilizes. Set this in your ".env" file.
    |
    */

    'env' => env('APP_ENV', 'production'),

    /*
    |--------------------------------------------------------------------------
    | Application Debug Mode
    |--------------------------------------------------------------------------
    |
    | When your application is in debug mode, detailed error messages with
    | stack traces will be shown on every error that occurs within your
    | application. If disabled, a simple generic error page is shown.
    |
    */

    'debug' => env('APP_DEBUG', false),

    /*
    |--------------------------------------------------------------------------
    | Application URL
    |--------------------------------------------------------------------------
    |
    | This URL is used by the console to properly generate URLs when using
    | the Artisan command line tool. You should set this to the root of
    | your application so that it is used when running Artisan tasks.
    |
    */

    'url' => env('APP_URL', 'http://localhost'),

    /*
    |--------------------------------------------------------------------------
    | Application Timezone
    |--------------------------------------------------------------------------
    |
    | Here you may specify the default timezone for your application, which
    | will be used by the PHP date and date-time functions. We have gone
    | ahead and set this to a sensible default for you out of the box.
    |
    */

    'timezone' => 'UTC',

    /*
    |--------------------------------------------------------------------------
    | Application Locale Configuration
    |--------------------------------------------------------------------------
    |
    | The application locale determines the default locale that will be used
    | by the translation service provider. You are free to set this value
    | to any of the locales which will be supported by the application.
    |
    */

    'locale' => 'en',

    /*
    |--------------------------------------------------------------------------
    | Application Fallback Locale
    |--------------------------------------------------------------------------
    |
    | The fallback locale determines the locale to use when the current one
    | is not available. You may change the value to correspond to any of
    | the language folders that are provided through your application.
    |
    */

    'fallback_locale' => 'en',

    /*
    |--------------------------------------------------------------------------
    | Encryption Key
    |--------------------------------------------------------------------------
    |
    | This key is used by the Illuminate encrypter service and should be set
    | to a random, 32 character string, otherwise these encrypted strings
    | will not be safe. Please do this before deploying an application!
    |
    */

    'key' => env('APP_KEY'),

    'cipher' => 'AES-256-CBC',

    /*
    |--------------------------------------------------------------------------
    | Logging Configuration
    |--------------------------------------------------------------------------
    |
    | Here you may configure the log settings for your application. Out of
    | the box, Laravel uses the Monolog PHP logging library. This gives
    | you a variety of powerful log handlers / formatters to utilize.
    |
    | Available Settings: "single", "daily", "syslog", "errorlog"
    |
    */

    'log' => env('APP_LOG', 'single'),

    'log_level' => env('APP_LOG_LEVEL', 'debug'),

    /*
    |--------------------------------------------------------------------------
    | Autoloaded Service Providers
    |--------------------------------------------------------------------------
    |
    | The service providers listed here will be automatically loaded on the
    | request to your application. Feel free to add your own services to
    | this array to grant expanded functionality to your applications.
    |
    */

    'providers' => [

        /*
         * Laravel Framework Service Providers...
         */
        Illuminate\Auth\AuthServiceProvider::class,
        Illuminate\Broadcasting\BroadcastServiceProvider::class,
        Illuminate\Bus\BusServiceProvider::class,
        Illuminate\Cache\CacheServiceProvider::class,
        Illuminate\Foundation\Providers\ConsoleSupportServiceProvider::class,
        Illuminate\Cookie\CookieServiceProvider::class,
        Illuminate\Database\DatabaseServiceProvider::class,
        Illuminate\Encryption\EncryptionServiceProvider::class,
        Illuminate\Filesystem\FilesystemServiceProvider::class,
        Illuminate\Foundation\Providers\FoundationServiceProvider::class,
        Illuminate\Hashing\HashServiceProvider::class,
        Illuminate\Mail\MailServiceProvider::class,
        Illuminate\Notifications\NotificationServiceProvider::class,
        Illuminate\Pagination\PaginationServiceProvider::class,
        Illuminate\Pipeline\PipelineServiceProvider::class,
        Illuminate\Queue\QueueServiceProvider::class,
        Illuminate\Redis\RedisServiceProvider::class,
        Illuminate\Auth\Passwords\PasswordResetServiceProvider::class,
        Illuminate\Session\SessionServiceProvider::class,
        Illuminate\Translation\TranslationServiceProvider::class,
        Illuminate\Validation\ValidationServiceProvider::class,
        Illuminate\View\ViewServiceProvider::class,


        /*
         * Package Service Providers...
         */


        /*
         * Application Service Providers...
         */
        App\Providers\AppServiceProvider::class,
        App\Providers\AuthServiceProvider::class,
        // App\Providers\BroadcastServiceProvider::class,
        App\Providers\EventServiceProvider::class,
        App\Providers\RouteServiceProvider::class,

    ],

    /*
    |--------------------------------------------------------------------------
    | Class Aliases
    |--------------------------------------------------------------------------
    |
    | This array of class aliases will be registered when this application
    | is started. However, feel free to register as many as you wish as
    | the aliases are "lazy" loaded so they don't hinder performance.
    |
    */

    'aliases' => [

        'App' => Illuminate\Support\Facades\App::class,
        'Artisan' => Illuminate\Support\Facades\Artisan::class,
        'Auth' => Illuminate\Support\Facades\Auth::class,
        'Blade' => Illuminate\Support\Facades\Blade::class,
        'Broadcast' => Illuminate\Support\Facades\Broadcast::class,
        'Bus' => Illuminate\Support\Facades\Bus::class,
        'Cache' => Illuminate\Support\Facades\Cache::class,
        'Config' => Illuminate\Support\Facades\Config::class,
        'Cookie' => Illuminate\Support\Facades\Cookie::class,
        'Crypt' => Illuminate\Support\Facades\Crypt::class,
        'DB' => Illuminate\Support\Facades\DB::class,
        'Eloquent' => Illuminate\Database\Eloquent\Model::class,
        'Event' => Illuminate\Support\Facades\Event::class,
        'File' => Illuminate\Support\Facades\File::class,
        'Gate' => Illuminate\Support\Facades\Gate::class,
        'Hash' => Illuminate\Support\Facades\Hash::class,
        'Lang' => Illuminate\Support\Facades\Lang::class,
        'Log' => Illuminate\Support\Facades\Log::class,
        'Mail' => Illuminate\Support\Facades\Mail::class,
        'Notification' => Illuminate\Support\Facades\Notification::class,
        'Password' => Illuminate\Support\Facades\Password::class,
        'Queue' => Illuminate\Support\Facades\Queue::class,
        'Redirect' => Illuminate\Support\Facades\Redirect::class,
        'Redis' => Illuminate\Support\Facades\Redis::class,
        'Request' => Illuminate\Support\Facades\Request::class,
        'Response' => Illuminate\Support\Facades\Response::class,
        'Route' => Illuminate\Support\Facades\Route::class,
        'Schema' => Illuminate\Support\Facades\Schema::class,
        'Session' => Illuminate\Support\Facades\Session::class,
        'Storage' => Illuminate\Support\Facades\Storage::class,
        'URL' => Illuminate\Support\Facades\URL::class,
        'Validator' => Illuminate\Support\Facades\Validator::class,
        'View' => Illuminate\Support\Facades\View::class,

    ],

];

This is the query returns:

0 => array:6 [▼ "CODCC" => "001" "DSCCC" => b"INSCRIÇÃO IPSC - PISTOLA" "VALOR" => "150.00" "DT_ATZ" => null "DT_INI_INS" => "2016-02-20" "DT_FIM_INS" => "2016-02-29" ]

Note that in the "DSCCC" => b "INSCRIÇÃO IPSC - PISTOLA" there is a b before starting the registry value, every time the record has some special character that happens, so the laravel can not transform variable in information.

Can you help me please?

I have this erro The Response content must be a string or object implementing __toString(), "boolean" given. when i trying to get data with utf8 charsets like "Almacén"

I had installed this package using: composer require jacquestvanzuydam/laravel-firebird:dev-5.5-support and i installed also php7.0-interbase tha enables firebird pdo i enabled pdo-firebird php module with: phpenmod pdo_firebird when i run : php -m it shows me that pdo_firebird is compiled and loaded.

when i print : print_r(PDO::getavailabledrivers()); it shows

[0] => 'firebird'

but when i run laravel thinker and try to execute: App\EMPLOYEE::all();

it shows:

InvalidArgumentException with message: UnsupportedDriver[firebird]'

I'm using php 7 and firebird 2.5 superclassic under ubuntu 16.04 xenial

The tables created by artisan migrate in IBOConsole always appears with quotation marks, for use in IBOconsole: select * from "users". To use the pre-existing tables, created in IBOConsole, in laravel whenever I have to do it always with their names and fields in capital letters. I hope I have succeeded in explaining!

Laravel 5.1, Win7, Firebird 2.5

hello jacquestvanzuydam, i have field price with type data numeric(15,2) and my raw query is

$data = DB::select("select * from DATA_MASTER('{$param1}','{$param2}')");

price in the procedure is 10000.00, but the result in php is 1563888.64 ,how to fix it

you can help me?

PDOException in Processor.php line 34: SQLSTATE[IM001]: Driver does not support this function: driver does not support lastInsertId()

I create a new Model Object $sale = new Sale(); Then, i updated its fields $sale->amount=.... # and som other update

When i tried to insert t with $sale->save() I got the following error:

SQLSTATE[IM001]: Driver does not support this function: driver does not support lastInsertId()

so i got this error message

PDOException in Connection.php line 90:
SQLSTATE[HY000] [335544344] I/O error during "CreateFile (open)" operation for file "/storage/firebird/DBCUBIS_OPRS.FDB"

when i try to test it with

Route::get('firebird', function()
{
    $users = DB::connection('firebird')->table('user')->get();
    dd($users);
});

and in my connection

'firebird' => [
            'driver'   => 'firebird',
            'host'     => env('DB_HOST_Firebird', 'localhost'),
            'database' => env('DB_DATABASE_Firebird','/storage/firebird/DBCUBIS_OPRS.FDB'),
            'username' => env('DB_USERNAME_Firebird', 'SYSDBA'),
            'password' => env('DB_PASSWORD_Firebird', 'masterkey'),
            'charset'  => env('DB_CHARSET_Firebird', 'UTF8'),
        ],

and i already make sure i never changed any username or password....

note: laravel version: 5.4 php version: 7.0 using XAMPP in windows 10 Pro 64bit

• When trying to install it with composer, it fails and return

[InvalidArgumentException] Could not find a matching version of package sim1984/laravel-firebird. Check the package spelling, your version con straint and that the package is available in a stability which matches your minimum-stability (stable).

• i cant also locate it in packagist
• I couldn't open an issue, so i think to pass it here

I'm working with the driver in an app that is ok. Now i need to extend this app and my first requirement is to install Laravel Passport package, so i follow every step and when i do "php artisan passport:install" i get the error:

In Processor.php line 34:

  SQLSTATE[IM001]: Driver does not support this function: driver does not support lastInsertId()

Following the stacktrace i see that the Processor.php file that is using is in vendor\laravel\framework\src\Illuminate\Database\Query\Processors\ and calls lastInsertId php function. I'm stuck in here and don't know what to do to fix this problem.

Hello people,

I’m having some troubles when inserting especial characters(á,é,í,ó,ú,ñ) into de database. The FB I’m working with is encoded with ‘WIN1254’ charset and I can read properly any register that has especial characters, but when it comes to insert the data, it gets saved with the wrong encoding.

Note: When saving the data with plain php pdo, it works just fine.

Anyone has had this problem?