0

I have downloaded, installed and activated "php_pdo_sqlsrv_56_nts.dll" and "php_sqlsrv_56_nts.dll" by moving to the ext directory of php5.6.31 and adding to php.ini the lines:

extension = php_sqlsrv_56_nts.dll 
extension = php_pdo_sqlsrv_56_nts.dll

even with a non-thread-safe version the extensions still do not appear on phpinfo while they are active .. would I have forgotten something?

PS: I need the driver because I have an error "Undefined class constant PDO :: SQLSRV_ENCODING_UTF8"

Win 7 x64 Wamp 3.1.0 PHP 5.6.31 (version 3.2 sqlsrv)

Thank you all

img Wamp information - img Enable Ext PHP 5.6.31

Sammitch
  • 30,782
  • 7
  • 50
  • 77
Alexis
  • 29
  • 1
  • 6
  • You need the Thread Safe versions and not the NTS i.e. Not Thread Safe versions for WAMPServer – RiggsFolly Sep 18 '17 at 22:24
  • Also the https://www.microsoft.com/en-gb/download/details.aspx?id=20098 – RiggsFolly Sep 18 '17 at 22:29
  • thanks for your reply, I made the changes, the dll are activated but still not displayed in phpinfo I despair.. – Alexis Sep 18 '17 at 23:03
  • I have been looking for 2 days on the web but I still do not understand why the extensions are active but not display in phpinfo .. I nevertheless followed all the prerequisites, would not it not better that I pass on wamp version previous wamp 3.1? – Alexis Sep 18 '17 at 23:14
  • Have you read this https://stackoverflow.com/questions/28960139/how-to-connect-sql-server-with-php-web-application-using-wamp-server Just amend the directories to WAMPServer directories – RiggsFolly Sep 19 '17 at 07:55
  • Same problem ... Still not in phpinfo, thanks for your answer anyway I will try to start from 0 with another version of wamp and php – Alexis Sep 19 '17 at 09:10
  • Did you install the PHP-SQLServer Drivers software? the php extension does not talk directly to the SQLSevrer database. It all goes through the SQLServer Driver layer – RiggsFolly Sep 19 '17 at 09:13
  • I'm not sure I installed Microsoft ODBC driver 11 for SQLServer that's what you're talking about? Thx for help ! – Alexis Sep 19 '17 at 12:57
  • Yes thats what I am talking about – RiggsFolly Sep 19 '17 at 13:25
  • i am on wamp 3.1 with apache 2.4.27 i try to send an email to localhost via a sqlserver 2008 database hosted on an IIS server but i still have this error Undefined class constant 'PDO :: SQLSRV_ENCODING_UTF8' which i supose comes from the sql_srv extension missing .. – Alexis Sep 19 '17 at 16:02
  • i have a error PHP Startup: Unable to load dynamic library 'c:/wamp64/bin/php/php5.6.31/ext/php_pdo_sqlsrv_56_nts.dll' - Le module sp�cifi� est introuvable. same thing for php_sqlsrv_56_nts.dl what are the Visual C ++ packages installed I think it is missing? – Alexis Sep 20 '17 at 07:22
  • You are still using the `NTS` (Not Thread Safe) version of the `php_sqlsrv_56_nts.dll` Like I said in the first comment, you must use the `TS` (Thread Safe) version with WAMPServer. – RiggsFolly Sep 20 '17 at 07:56
  • On the [WAMPServer backup repo](http://wampserver.aviatechno.net/) there is a tool that will check the MSVC Runtimes required. Look at the bottom of the page for a link called `Checks VC++ packages installed` There is also a link to a zip file called `Microsoft VC++ packages VC2008, 2010, 2012, 2013, 2015, 2017 zip files` that you can download and install all the required/missing runtimes – RiggsFolly Sep 20 '17 at 08:02

1 Answers1

0

I Fix my problem pdo_sqlsrv display in phpinfo

Thx RiggsFolly & Sqlsrv for PHP 5.6 on WAMP server

but now it's php_intl.dll' - Le module spécifié est introuvable. and icuuc57.dll missing but i solved my problem for sql_srv in phpinfo not display ext thx !!!!

Alexis
  • 29
  • 1
  • 6
  • for fix problem with php_intl.dll i load file icu*.dll directly in httpconf as LoadFile "C:\wampTEST\bin\php\php5.6.31\icudt57.dll" LoadFile "C:\wampTEST\bin\php\php5.6.31\icuin57.dll" LoadFile "C:\wampTEST\bin\php\php5.6.31\icuio57.dll" ... not move bin/php to apache/bin – Alexis Sep 21 '17 at 07:36