Databases
StackOverflow2013
Postsdbo
POWAMP and SQLSRV: sqlsrv not included in `PDO::getAvailableDrivers()` after install
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWAMP and SQLSRV: sqlsrv not included in `PDO::getAvailableDrivers()` after install
    primarykey
    data
    text
    <p>I've never been able to get SQL Server to play nicely in my WAMP environment, and I trying to finally solve it once and for all.</p> <p>Tried:</p> <ul> <li>Downloaded the latest SQL Server drivers from microsoft, then extracted and dropped them in my <em><strong>\wamp\bin\php\php5.4.3\ext</strong></em> dir.</li> <li>I edited both the <em><strong>\wamp\bin\php\php5.4.3\php.ini</strong></em> and <em><strong>\wamp\bin\apache\apache2.4.2\bin\php.ini</strong></em> files to include <code>extension=php_sqlsrv_54_ts.dll</code>.</li> <li>restarted all WAMP services</li> <li>checked phpinfo ... no SQLSRV</li> <li>checked <code>PDO::getAvailableDrivers()</code> ... got only <code>Array( [0]=&gt;mysql, [1]=&gt;sqlite )</code></li> </ul> <p>Now, I understand that PDO is included natively in PHP 5.3+, but since the MS instructions explicitly requires that <code>extension=php_pdo.dll</code> be enabled, so I figured I'd give that a shot too. </p> <p>I downloaded the DLL from dlldll.com (1st encounter with that site, so I <em>hoping</em> it's a reputable source), extracted and moved the _php_pdo.dll_ file to my <em><strong>\wamp\bin\php\php5.4.3\ext</strong></em> dir, then added it into both the php.ini files ... no improvement.</p> <p>As a side note, when I check the list of activated PHP ext's from the WAMPSERVER menu, the sqlserver extensions don't even show up on the list.</p> <p>Just to test it out, I also tried uncommenting <code>extension=php_pdo_pgsql.dll</code> in the <em>php.ini</em>'s, and that worked just fine ... "pgsql" <em>was</em> included in the avail drivers array.</p> <p>My setup:</p> <ul> <li>Wampserver 2.2 (64bit), running <ul> <li>Apache 2.4.2</li> <li>PHP 5.4.3</li> </ul></li> <li>Win 7 pro 64</li> </ul> <p>What next?</p> <p>I'm just about out of ideas. </p> <p>The only thing I can think of is that maybe the SQLSRV drivers are 32bit, and not playing nicely with my 64bit setup ... ooohhh goodness .. I sure hope not.</p> <p><em><strong>Any</strong></em> tips/pointers are welcome ... <em>especially</em> if they don't include completely reinstalling ;)</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmOrloff
    1. USmOrloff
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWAMP and SQLSRV: sqlsrv not included in `PDO::getAvailableDrivers()` after install
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat errors are you getting when you start apache in your php error log? Is it saying the dll is not found? Your computer's bit-ness shouldn't be a problem as long as your WAMP and extensions are 32-bit you will be fine.
      singulars
      1. POWAMP and SQLSRV: sqlsrv not included in `PDO::getAvailableDrivers()` after install
      1. USSarah Kemp
    2. COWishful thinking helped me ignore that 64-bit WAMP note... I've had nothing but trouble from 64-bit WAMP - seems like the only extension I ever need (no matter what it is) is only available in 32-bit. As for the php error log - are you sure you are looking at the right one? The path will be in your php.ini file. If PHP is failing to load an extension you configure it to run, it should have an entry there on start up.
      singulars
      1. POWAMP and SQLSRV: sqlsrv not included in `PDO::getAvailableDrivers()` after install
      1. USSarah Kemp
    3. COThx. The error_log declaration was commented out in the ini (by default, presumably). Uncommented it then restarted all WAMP services, and now the log says that php_sqlsrv_54_ts.dll is "not a valid Win32 application". What does that tell us?
      singulars
      1. POWAMP and SQLSRV: sqlsrv not included in `PDO::getAvailableDrivers()` after install
      1. USmOrloff
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload