KoolReport's Forum

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

PDO error with SQL Server 2008 R2 #741

Open Saif opened this topic on on Mar 13, 2019 - 3 comments

Saif commented on Mar 13, 2019

Hi Team,

I am new to Koolreport and much interested in this tool. I was trying to connect with SQL Server using PDO connection but getting below error: Fatal error: Uncaught PDOException: could not find driver in C:\xampp\htdocs\koolreport\src\datasources\PdoDataSource.php:112 Stack trace: #0

I already added all the required ddl attached in image and made the setting function accordingly.

KoolReport commented on Mar 13, 2019

You may need to turn on pdo extension for sql server in php.ini file.

Andrew Borell commented on Mar 14, 2019

In your php ini you need to add the extension for the version that matches the architecture for xampp. Also i seem to recall i use the non thread safe version for this. All the files can exist in the extension directory however, but if you run 64-bit version of xampp then it is compiled with 64-bit php, which would require 64-bit pdo. The extension you would add to the php.ini then would be php_pdo_sqlsrv_7_nts_x64.dll

KoolReport commented on Mar 16, 2019

Andrew, Thank you very much for the details!

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