Skip to content

Could Not Find Driver (SQL Server Driver) #1283

@dmm001a

Description

@dmm001a

Hi,

So this is not specific to DataTables but I am hoping someone out there can I help. I would really like to use DataTables but had given up the SQL Server Driver loading in my custom development and just started to use ODBC. I have tried the following things to get the SQL Server Driver to load successfully.

I downloaded the correct driver from Microsoft based on my version of PHP.
I placed the driver in the c:\php\ext folder (I also tried another folder just in case there was some permissions issues and configured php.ini to point there).
I have tried putting an extension entry in php.ini file for the php_sqlsrv file, php_pdo_sqlsrv_83_nts_x64, and the php_pdo_sqlsrv_83_ts_x64. None of them load and I am running a 64 bit operating system.
I have confirmed that my php.ini file is running in the c:\php\php.ini folder and that is where PHP is pointing to.
I do have ODBC SQL Server Driver 17 and 18 on my machine.
DataTables warning: table id=example - An error occurred while connecting to the database ''. The error reported by the server was: could not find driver

I am out of ideas. Any suggestions would be greatly appreciated.

Thanks

Metadata

Metadata

Assignees

No one assigned

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions