Msphpsql: PHP Warning: PHP Startup: Unable to load dynamic library 'C:\Program Files\PHP\v7.1\ext\php_pdo_sqlsrv_7_nts_x86.dll' - The specified procedure could not be found. in Unknown on line 0

[klapsius]

After upgrade to PHP 7.1 i have a problem with loading these two files:

PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\Program Files\PHP\v7.1\ext\php_sqlsrv_7_nts_x86.dll' - The specified procedure could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\Program Files\PHP\v7.1\ext\php_pdo_sqlsrv_7_nts_x86.dll' - The specified procedure could not be found.
 in Unknown on line 0

PHP 7.0.7 running on a same server and its fine. My PHP 7.1 is x86 drivers is also x86. IIS Server. I believe if something wrong with IIS then should be wrong with PHP 7.0.7 as well? Could be drivers?

[meet-bhagdev]

Can you confirm if you are using x86 IIS or x64 IIS?

[mlhkr]

@klapsius did you try php_sqlsrv_71_nts* ones?
https://github.com/Microsoft/msphpsql/releases/download/4.1.4-Windows/7.1.zip

[klapsius]

@meet-bhagdev Windows Server 2012 x64

[klapsius]

@mlhkr It works!!!! Thank you.
If anyone could explain why it works with new drivers?

[yitam]

As indicated in http://php.net/manual/en/migration71.php PHP 7.1 and PHP 7.0 are not compatible. Thus new 7.1 drivers are required. Please let us know if this answers your question. Thank you.

[klapsius]

Yes. Thank you

[tobya]

@yitam Does this mean that the mssql pdo drivers only work with PHP 7.0 but not with 7.1?

[yitam]

@tobya we provide different sets of drivers for PHP 7.0 and PHP 7.1 as they are incompatible. Please download the right ones for your needs (see the link above). Hope this helps.

[tobya]

If I go here

https://www.microsoft.com/en-ie/download/details.aspx?id=20098

I only get the option to download 4.0 drivers which I think are php 7 ones.

On the releases page https://github.com/Microsoft/msphpsql/releases I can't see any mention of 7.1

I see your link above links to the drivers for 7.1 I'm just wondering how someone searching might find the drivers for 7.1

Thank you.

[yitam]

Hi @tobya , this is the 4.1.4 Windows Preview

Stay tuned on our releases page that you already know for future releases (for Windows / Linux).
Hope I have answered your questions.

[danchohfi]

Thank you mlhkr, for me this solution work on.

https://github.com/Microsoft/msphpsql/releases/download/4.1.4-Windows/7.1.zip

[iMrLopez]

Solution from @danchohfi still works.

[nathanaelkwangue]

ujokfdmsk!flksd;

[mmamoonkhan]

these warnings can not solved i tried to many solutions but still have an error and due to this i can not run my project
Warning: PHP Startup: Unable to load dynamic library 'pdo_sqlite' (tried: \xampp\php\ext\pdo_sqlite (The specified module could not be found.), \xampp\php\ext\php_pdo_sqlite.dll (The specified procedure could not be found.)) in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library 'php_openssl.dll' (tried: \xampp\php\ext\php_openssl.dll (The specified procedure could not be found.), \xampp\php\ext\php_php_openssl.dll.dll (The specified module could not be found.)) in Unknown on line 0

[yitam]

@mmamoonkhan none of those dlls is ours and it looks like you should fix your php ini setting.

[mihai-marius]

No matter what driver I use for php 7.3 is giving me this message. I need to connect my laravel aplication to an sql database and I am using sql server 2019 express

[yitam]

@mihai-marius are you using PHP 7.3 thread safe 64 bit?

[mlhkr]

As I can see you're using xampp which installs apache but it depends on it's used as CGI mode or not so you better try the non-thread-safe version too. _nts_.
@yitam indicated it too.
Hope it solves your problem.