KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Firebird Datasource #547

Open Emmanuel Sanchez opened this topic on on Dec 6, 2018 - 3 comments

Emmanuel Sanchez commented on Dec 6, 2018

Hi

I work with firebird database, but i can't find the pdo source files for this database. Where can I find them?

I need to develop server side datatables, and i can't find the aproppiate library.

Thanks, regards

Emmanuel Sanchez

KoolReport commented on Dec 7, 2018

You use the PDODataSource to connect to Firebird. PDO support Firebird connection. You just need to make sure that you have php firebird extension for PDO enabled inside php.ini. For more information of the connectionString for Firebird, please have a look at php manual of pdo connect to firebird.

Emmanuel Sanchez commented on Dec 7, 2018

Hi

Yes, i'm connecting via PDFO Driver and it works.

But in the code, I see there is not planned the connection with Firebird, as seen here:

$driver = strtolower($this->connection->getAttribute(PDO::ATTR_DRIVER_NAME));
	switch ($driver) {
		case 'mysql':
			list($this->query, $this->totalQuery, $this->filterQuery) =
				MySQLDataSource::processQuery($this->query, $queryParams);
			break;
		case 'oci':
			list($this->query, $this->totalQuery, $this->filterQuery) =
				OracleDataSource::processQuery($this->query, $queryParams);
			break;
		case 'pgsql':
			list($this->query, $this->totalQuery, $this->filterQuery) =
				PostgreSQLDataSource::processQuery($this->query, $queryParams);			
			break;
		case 'sqlsrv':
			list($this->query, $this->totalQuery, $this->filterQuery) =
				SQLSRVDataSource::processQuery($this->query, $queryParams);
			break;
		default:
			break;
	}
	$this->countTotal = Util::get($queryParams, 'countTotal', false);
    $this->countFilter = Util::get($queryParams, 'countFilter', false);
    return $this;

There is no firebird in the case, the object is not defined. Also, I can't see a firebird database wrapper in the src/datasources folder.

So I think the firebird database code for server side datatables, can you send me the code please?

Regard, Emmanuel

KoolReport commented on Dec 8, 2018

This query processing is used for feature called server processing used in datagrid that you may see in our example. However it does not affect normal connection to firebird using pdo. 95% of time is working. In the next version we will add on this feature for firebird.

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
None yet

None