sql server - IIS8 PHP Issue MSSQL -
i having issue getting php work mssql on iis8 server.
i have extensions loaded php 5.4 php_pdo_sqlsrv_54_ts.dll , php_sql_srv_54_ts.dll
in phpinfo()
get:
cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--disable-zts" "--disable-isapi" "--disable-nsapi" "--without-mssql" "--without-pdo-mssql" "--without-pi3web" "--with-pdo-oci=c:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8=c:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8-11g=c:\php-sdk\oracle\instantclient11\sdk,shared" "--with-enchant=shared" "--enable-object-out-dir=../obj/" "--enable-com-dotnet=shared" "--with-mcrypt=static" "--disable-static-analyze" "--with-pgo"
i have done ton of searching, , have configured accordingly.
how can mssql work php?
the reason know it's not codeigniter install blank... , know previous installs it's db connection issue
note: phpinfo, not show sqlsrv sections should extensions enabled...
simple pdo debug testing:
$dsn = "mssql:host=localhost;dbname=the_db"; $user = "my_un"; $password = "my_pw"; try { $dbh = new pdo($dsn, $user, $password); var_dump($dbh); } catch (pdoexception $e) { var_dump($e); }
produces following error:
object(pdoexception)#2 (8) { ["message":protected]=> string(21) "could not find driver" ["string":"exception":private]=> string(0) "" ["code":protected]=> int(0) ["file":protected]=> string(35) "d:\domains\turbokits admin\test.php" ["line":protected]=> int(13) ["trace":"exception":private]=> array(1) { [0]=> array(6) { ["file"]=> string(35) "d:\domains\turbokits admin\test.php" ["line"]=> int(13) ["function"]=> string(11) "__construct" ["class"]=> string(3) "pdo" ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> string(44) "mssql:host=localhost;dbname=my_db" [1]=> string(10) "my_un" [2]=> string(10) "my_pw" } } } ["previous":"exception":private]=> null ["errorinfo"]=> null }
Comments
Post a Comment