aximand
Goto Top

PHP 7.3 in Verbindung mit MS SQL und IIS

Mahlzeit zusammen,

ich weiss ned so richtig ob ich dieses oder jenes richtig konfiguriert habe und/oder was die phpinfo() mir anzeigen muss.

Kurz umrissen: ich möchte unter Windows 10 über den IIS mit PHP 7.3 (x64) auf einen Microsoft SQL-Server zugreifen um Media-Wiki zum laufen zu bekommen.

Die PHP.ini hat folgende Inhalte:
extension_dir = "C:/Program Files/PHP/ext"  

extension=odbc
extension=pdo_odbc
extension=php_sqlsrv_73_nts_x64.dll
extension=php_pdo_sqlsrv_73_nts_x64.dll

Ich dachte dass irgendwas in der phpinfo() mit pdo_mssql oder wenigstens mit ms sql auftauchen sollte??


phpinfo() liefert mir:

PHP Version 7.3.9
System	Windows NT SDVM 10.0 build 18362 (Windows 10) AMD64
Build Date	Aug 28 2019 09:21:06
Compiler	MSVC15 (Visual C++ 2017)
Architecture	x64
Configure Command	cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--with-pdo-oci=c:\php-snap-build\deps_aux\oracle\x64\instantclient_12_1\sdk,shared" "--with-oci8-12c=c:\php-snap-build\deps_aux\oracle\x64\instantclient_12_1\sdk,shared" "--enable-object-out-dir=../obj/" "--enable-com-dotnet=shared" "--without-analyzer" "--with-pgo"  
Server API	CGI/FastCGI
Virtual Directory Support	enabled
Configuration File (php.ini) Path	C:\Windows
Loaded Configuration File	C:\Program Files\PHP\php.ini
Scan this dir for additional .ini files	(none)
Additional .ini files parsed	(none)
PHP API	20180731
PHP Extension	20180731
Zend Extension	320180731
Zend Extension Build	API320180731,TS,VC15
PHP Extension Build	API20180731,TS,VC15
Debug Build	no
Thread Safety	enabled
Thread API	Windows Threads
Zend Signal Handling	disabled
Zend Memory Manager	enabled
Zend Multibyte Support	provided by mbstring
IPv6 Support	enabled
DTrace Support	disabled
Registered PHP Streams	php, file, glob, data, http, ftp, zip, compress.zlib, compress.bzip2, https, ftps, phar
Registered Stream Socket Transports	tcp, udp, ssl, tls, tlsv1.0, tlsv1.1, tlsv1.2
Registered Stream Filters	convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, zlib.*, bzip2.*

ODBC:
odbc
ODBC Support	enabled
Active Persistent Links	0
Active Links	0
ODBC library	Win32
ODBCVER	0x0350
Directive	Local Value	Master Value
odbc.allow_persistent	On	On
odbc.check_persistent	On	On
odbc.default_cursortype	Static cursor	Static cursor
odbc.default_db	no value	no value
odbc.default_pw	no value	no value
odbc.default_user	no value	no value
odbc.defaultbinmode	return as is	return as is
odbc.defaultlrl	return up to 4096 bytes	return up to 4096 bytes
odbc.max_links	Unlimited	Unlimited
odbc.max_persistent	Unlimited	Unlimited

PDO

**PDO**
PDO support	enabled
PDO drivers	odbc

**
PDO_ODBC**
PDO Driver for ODBC (Win32)	enabled
ODBC Connection Pooling	Enabled, strict matching

Content-Key: 500102

Url: https://administrator.de/contentid/500102

Printed on: May 18, 2024 at 06:05 o'clock

Mitglied: 141320
141320 Oct 01, 2019 updated at 10:43:04 (UTC)
Goto Top
Nutze einfach den Web Platform Installer
https://www.microsoft.com/web/downloads/platform.aspx
Damit geht das out of the box, hier getestet, durchklicken, feddich, fun z t! Kriegt sogar meine Oma hin.

screenshot

screenshot

screenshot

screenshot