1

Closed

Changes from Rev2.0 CTP break php_pdo_sqlsrv_53 driver?

description

The previous (2.0 CTP April, 2010) php_pdo_sqlsrv_53 driver worked fine in my environment. When I use the newer (2.0 August, 2010) version, I see fails with messages like: Error!: SQLSTATE[IMSSP]: The DSN string ended unexpectedly.
Here is the phpinfo() for the failing case: X-Powered-By: PHP/5.3.2 ZendServer Set-Cookie: ZendDebuggerCookie=127.0.0.1%3A10000%3A0||004|77742D65|1016; path=/ Content-type: text/html <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd"> <html><head> <title>phpinfo()</title><meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" /></head> <body>
PHP Logo

PHP Version 5.3.2


System Windows NT HYDROTEL 6.1 build 7600 ((null)) i586
Build Date May 16 2010 09:11:12
Compiler MSVC9 (Visual C++ 2008)
Architecture x86
Configure Command cscript /nologo configure.js "--disable-zip" "--disable-phar" "--disable-ipv6" "--disable-zts" "--enable-cgi" "--disable-bcmath" "--disable-calendar" "--disable-odbc" "--disable-tokenizer" "--disable-xmlreader" "--disable-xmlwriter" "--without-sqlite" "--without-wddx" "--enable-cli-win32" "--enable-pdo" "--with-openssl" "--with-php-build" "--with-libxml" "--with-pdo-sqlite"
Server API CGI/FastCGI
Virtual Directory Support disabled
Configuration File (php.ini) Path C:\Windows
Loaded Configuration File C:\Users\Ross\AppData\Local\Temp\zend_debug\session3899917984549426272.tmp\php.ini
Scan this dir for additional .ini files (none)
Additional .ini files parsed (none)
PHP API 20090626
PHP Extension 20090626
Zend Extension 220090626
Zend Extension Build API220090626,NTS,VC9
PHP Extension Build API20090626,NTS,VC9
Debug Build no
Thread Safety disabled
Zend Memory Manager enabled
Zend Multibyte Support disabled
IPv6 Support disabled
Registered PHP Streams https, ftps, php, file, glob, data, http, ftp, compress.zlib, compress.bzip2, phar, zip, sqlsrv
Registered Stream Socket Transports tcp, udp, ssl, sslv3, sslv2, tls
Registered Stream Filters convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, zlib.*, bzip2.*

Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
    with Zend Debugger v5.3, Copyright (c) 1999-2010, by Zend Technologies


PHP Credits


Configuration

bcmath

BCMath support enabled

Directive Local Value Master Value
bcmath.scale 0 0

bz2

BZip2 Support Enabled
Stream Wrapper support compress.bz2://
Stream Filter support bzip2.decompress, bzip2.compress
BZip2 Version 1.0.4, 20-Dec-2006

calendar

Calendar support enabled

cgi-fcgi

Directive Local Value Master Value
cgi.check_shebang_line 1 1
cgi.discard_path 0 0
cgi.fix_pathinfo 1 1
cgi.force_redirect 1 1
cgi.nph 0 0
cgi.redirect_status_env no value no value
cgi.rfc2616_headers 0 0
fastcgi.impersonate 0 0
fastcgi.logging 1 1

com_dotnet

COM support enabled
DCOM support disabled
.Net support enabled

Directive Local Value Master Value
com.allow_dcom 0 0
com.autoregister_casesensitive 1 1
com.autoregister_typelib 0 0
com.autoregister_verbose 0 0
com.code_page no value no value
com.typelib_file no value no value

Core

PHP Version 5.3.2

Directive Local Value Master Value
allow_call_time_pass_reference On On
allow_url_fopen On On
allow_url_include Off Off
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
disable_functions no value no value
display_errors On On
display_startup_errors On Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting no value no value
exit_on_timeout Off Off
expose_php On On
extension_dir D:\eclipse\plugins\org.zend.php.debug.debugger.win32.x86_5.3.18.v20100603\resources\php53\ext D:\eclipse\plugins\org.zend.php.debug.debugger.win32.x86_5.3.18.v20100603\resources\php53\ext
file_uploads On On
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort On Off
implicit_flush Off Off
include_path .;D:\web\eclipse_projects\test .;D:\web\eclipse_projects\test
log_errors Off Off
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.add_x_header Off Off
mail.force_extra_parameters no value no value
mail.log no value no value
max_execution_time 30 30
max_file_uploads 20 20
max_input_nesting_level 64 64
max_input_time -1 -1
memory_limit 128M 128M
open_basedir no value no value
output_buffering 0 0
output_handler no value no value
post_max_size 8M 8M
precision 14 14
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv On On
register_globals Off Off
register_long_arrays On On
report_memleaks On On
report_zend_debug On On
request_order no value no value
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path no value no value
serialize_precision 100 100
short_open_tag On On
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir no value no value
user_dir no value no value
user_ini.cache_ttl 300 300
user_ini.filename .user.ini .user.ini
variables_order EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.enable_gc On On

ctype

ctype functions enabled

curl

cURL support enabled
cURL Information 7.20.0
Age 3
Features
AsynchDNS Yes
Debug No
GSS-Negotiate No
IDN No
IPv6 No
Largefile Yes
NTLM Yes
SPNEGO No
SSL Yes
SSPI No
krb4 No
libz Yes
CharConv No
Protocols dict, file, ftp, ftps, http, https, imap, imaps, ldap, pop3, pop3s, rtsp, smtp, smtps, telnet, tftp
Host i386-pc-win32
SSL Version OpenSSL/0.9.8n
ZLib Version 1.2.3

date

date/time support enabled
"Olson" Timezone Database Version 2010.3
Timezone Database internal
Default timezone Pacific/Auckland

Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone Pacific/Auckland Pacific/Auckland

dom

DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.7.3
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled

ereg

Regex Library Bundled library enabled

exif

EXIF Support enabled
EXIF Version 1.4 $Id: exif.c 293036 2010-01-03 09:23:27Z sebastian $
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF

Directive Local Value Master Value
exif.decode_jis_intel JIS JIS
exif.decode_jis_motorola JIS JIS
exif.decode_unicode_intel UCS-2LE UCS-2LE
exif.decode_unicode_motorola UCS-2BE UCS-2BE
exif.encode_jis no value no value
exif.encode_unicode ISO-8859-15 ISO-8859-15

fileinfo

fileinfo support enabled
version 1.0.5-dev

filter

Input Validation and Filtering enabled
Revision $Revision: 294106 $

Directive Local Value Master Value
filter.default unsafe_raw unsafe_raw
filter.default_flags no value no value

ftp

FTP support enabled

gd

GD Support enabled
GD Version bundled (2.0.34 compatible)
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.1.9
T1Lib Support enabled
GIF Read Support enabled
GIF Create Support enabled
JPEG Support enabled
libJPEG Version 6b
PNG Support enabled
libPNG Version 1.2.8
WBMP Support enabled
XBM Support enabled

Directive Local Value Master Value
gd.jpeg_ignore_warning 0 0

gettext

GetText Support enabled

gmp

gmp support enabled
GMP version 4.1 (VC7)

hash

hash support enabled
Hashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost adler32 crc32 crc32b salsa10 salsa20 haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5

iconv

iconv support enabled
iconv implementation "libiconv"
iconv library version 1.9

Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1

imagick

imagick module enabled
imagick module version 2.2.2
imagick classes Imagick, ImagickDraw, ImagickPixel, ImagickPixelIterator
ImageMagick version ImageMagick 6.4.6 2008-12-01 Q16 http://www.imagemagick.org
ImageMagick copyright Copyright (C) 1999-2009 ImageMagick Studio LLC
ImageMagick release date 2008-12-01
ImageMagick Number of supported formats: 0

Directive Local Value Master Value
imagick.locale_fix 0 0
imagick.progress_monitor 0 0

imap

IMAP c-Client Version 2007e
SSL Support enabled

intl

Internationalization support enabled
version 1.0.3
ICU version 3.8.1

Directive Local Value Master Value
intl.default_locale no value no value
intl.error_level 0 0

json

json support enabled
json version 1.2.1

ldap

LDAP Support enabled
RCS Version $Id: ldap.c 293036 2010-01-03 09:23:27Z sebastian $
Total Links 0/unlimited
API Version 3001
Vendor Name OpenLDAP
Vendor Version 20220

Directive Local Value Master Value
ldap.max_links Unlimited Unlimited

libxml

libXML support active
libXML Compiled Version 2.7.3
libXML Loaded Version 20703
libXML streams enabled

mbstring

Multibyte Support enabled
Multibyte string engine libmbfl
HTTP input encoding translation disabled

mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.

Multibyte (japanese) regex support enabled
Multibyte regex (oniguruma) version 4.7.1

Directive Local Value Master Value
mbstring.detect_order no value no value
mbstring.encoding_translation Off Off
mbstring.func_overload 0 0
mbstring.http_input pass pass
mbstring.http_output pass pass
mbstring.http_output_conv_mimetypes ^(text/|application/xhtml\+xml) ^(text/|application/xhtml\+xml)
mbstring.internal_encoding no value no value
mbstring.language neutral neutral
mbstring.strict_detection Off Off
mbstring.substitute_character no value no value

mcrypt

mcrypt support enabled
Version 2.5.7
Api No 20021217
Supported ciphers cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes
Supported modes cbc cfb ctr ecb ncfb nofb ofb stream

Directive Local Value Master Value
mcrypt.algorithms_dir no value no value
mcrypt.modes_dir no value no value

memcache

memcache support enabled
Active persistent connections 0
Version 2.2.5
Revision $Revision: 1.111 $

Directive Local Value Master Value
memcache.allow_failover 1 1
memcache.chunk_size 8192 8192
memcache.default_port 11211 11211
memcache.default_timeout_ms 1000 1000
memcache.hash_function crc32 crc32
memcache.hash_strategy standard standard
memcache.max_failover_attempts 20 20

mysql

MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version mysqlnd 5.0.7-dev - 091210 - $Revision: 294543 $

Directive Local Value Master Value
mysql.allow_local_infile On On
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

mysqli

MysqlI Support enabled
Client API library version mysqlnd 5.0.7-dev - 091210 - $Revision: 294543 $
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0

Directive Local Value Master Value
mysqli.allow_local_infile On On
mysqli.allow_persistent On On
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.max_persistent Unlimited Unlimited
mysqli.reconnect Off Off

mysqlnd

mysqlnd enabled
Version mysqlnd 5.0.7-dev - 091210 - $Revision: 294543 $
Compression supported
Command buffer size 4096
Read buffer size 32768
Read timeout 31536000
Collecting statistics Yes
Collecting memory statistics No

Client statistics
bytes_sent 0
bytes_received 0
packets_sent 0
packets_received 0
protocol_overhead_in 0
protocol_overhead_out 0
bytes_received_ok_packet 0
bytes_received_eof_packet 0
bytes_received_rset_header_packet 0
bytes_received_rset_field_meta_packet 0
bytes_received_rset_row_packet 0
bytes_received_prepare_response_packet 0
bytes_received_change_user_packet 0
packets_sent_command 0
packets_received_ok 0
packets_received_eof 0
packets_received_rset_header 0
packets_received_rset_field_meta 0
packets_received_rset_row 0
packets_received_prepare_response 0
packets_received_change_user 0
result_set_queries 0
non_result_set_queries 0
no_index_used 0
bad_index_used 0
slow_queries 0
buffered_sets 0
unbuffered_sets 0
ps_buffered_sets 0
ps_unbuffered_sets 0
flushed_normal_sets 0
flushed_ps_sets 0
ps_prepared_never_executed 0
ps_prepared_once_executed 0
rows_fetched_from_server_normal 0
rows_fetched_from_server_ps 0
rows_buffered_from_client_normal 0
rows_buffered_from_client_ps 0
rows_fetched_from_client_normal_buffered 0
rows_fetched_from_client_normal_unbuffered 0
rows_fetched_from_client_ps_buffered 0
rows_fetched_from_client_ps_unbuffered 0
rows_fetched_from_client_ps_cursor 0
rows_affected_normal 0
rows_affected_ps 0
rows_skipped_normal 0
rows_skipped_ps 0
copy_on_write_saved 0
copy_on_write_performed 0
command_buffer_too_small 0
connect_success 0
connect_failure 0
connection_reused 0
reconnect 0
pconnect_success 0
active_connections 0
active_persistent_connections 0
explicit_close 0
implicit_close 0
disconnect_close 0
in_middle_of_command_close 0
explicit_free_result 0
implicit_free_result 0
explicit_stmt_close 0
implicit_stmt_close 0
mem_emalloc_count 0
mem_emalloc_ammount 0
mem_ecalloc_count 0
mem_ecalloc_ammount 0
mem_erealloc_count 0
mem_erealloc_ammount 0
mem_efree_count 0
mem_malloc_count 0
mem_malloc_ammount 0
mem_calloc_count 0
mem_calloc_ammount 0
mem_realloc_count 0
mem_realloc_ammount 0
mem_free_count 0
proto_text_fetched_null 0
proto_text_fetched_bit 0
proto_text_fetched_tinyint 0
proto_text_fetched_short 0
proto_text_fetched_int24 0
proto_text_fetched_int 0
proto_text_fetched_bigint 0
proto_text_fetched_decimal 0
proto_text_fetched_float 0
proto_text_fetched_double 0
proto_text_fetched_date 0
proto_text_fetched_year 0
proto_text_fetched_time 0
proto_text_fetched_datetime 0
proto_text_fetched_timestamp 0
proto_text_fetched_string 0
proto_text_fetched_blob 0
proto_text_fetched_enum 0
proto_text_fetched_set 0
proto_text_fetched_geometry 0
proto_text_fetched_other 0
proto_binary_fetched_null 0
proto_binary_fetched_bit 0
proto_binary_fetched_tinyint 0
proto_binary_fetched_short 0
proto_binary_fetched_int24 0
proto_binary_fetched_int 0
proto_binary_fetched_bigint 0
proto_binary_fetched_decimal 0
proto_binary_fetched_float 0
proto_binary_fetched_double 0
proto_binary_fetched_date 0
proto_binary_fetched_year 0
proto_binary_fetched_time 0
proto_binary_fetched_datetime 0
proto_binary_fetched_timestamp 0
proto_binary_fetched_string 0
proto_binary_fetched_blob 0
proto_binary_fetched_enum 0
proto_binary_fetched_set 0
proto_binary_fetched_geometry 0
proto_binary_fetched_other 0
init_command_executed_count 0
init_command_failed_count 0
com_quit 0
com_init_db 0
com_query 0
com_field_list 0
com_create_db 0
com_drop_db 0
com_refresh 0
com_shutdown 0
com_statistics 0
com_process_info 0
com_connect 0
com_process_kill 0
com_debug 0
com_ping 0
com_time 0
com_delayed_insert 0
com_change_user 0
com_binlog_dump 0
com_table_dump 0
com_connect_out 0
com_register_slave 0
com_stmt_prepare 0
com_stmt_execute 0
com_stmt_send_long_data 0
com_stmt_close 0
com_stmt_reset 0
com_stmt_set_option 0
com_stmt_fetch 0
com_deamon 0

odbc

ODBC Support enabled
Active Persistent Links 0
Active Links 0
ODBC library Win32

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

openssl

OpenSSL support enabled
OpenSSL Library Version OpenSSL 0.9.8n 24 Mar 2010
OpenSSL Header Version OpenSSL 0.9.8n 24 Mar 2010

pcre

PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 8.00 2009-10-19

Directive Local Value Master Value
pcre.backtrack_limit 100000 100000
pcre.recursion_limit 100000 100000

PDO

PDO support enabled
PDO drivers sqlite, mysql, odbc, pgsql, sqlite2, sqlsrv

pdo_mysql

PDO Driver for MySQL enabled
Client API version mysqlnd 5.0.7-dev - 091210 - $Revision: 294543 $

PDO_ODBC

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

pdo_pgsql

PDO Driver for PostgreSQL enabled
PostgreSQL(libpq) Version 8.2.14
Module version 1.0.2
Revision $Id: pdo_pgsql.c 293036 2010-01-03 09:23:27Z sebastian $

pdo_sqlite

PDO Driver for SQLite 3.x enabled
SQLite Library 3.6.22

pdo_sqlsrv

pdo_sqlsrv support enabled

Directive Local Value Master Value
pdo_sqlsrv.log_severity 0 0

pgsql

PostgreSQL Support enabled
PostgreSQL(libpq) Version 8.2.14
Multibyte character support enabled
SSL support disabled
Active Persistent Links 0
Active Links 0

Directive Local Value Master Value
pgsql.allow_persistent On On
pgsql.auto_reset_persistent Off Off
pgsql.ignore_notice Off Off
pgsql.log_notice Off Off
pgsql.max_links Unlimited Unlimited
pgsql.max_persistent Unlimited Unlimited

Phar

Phar: PHP Archive support enabled
Phar EXT version 2.0.1
Phar API version 1.1.1
SVN revision $Revision: 290435 $
Phar-based phar archives enabled
Tar-based phar archives enabled
ZIP-based phar archives enabled
gzip compression enabled
bzip2 compression enabled
OpenSSL support enabled

Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.

Directive Local Value Master Value
phar.cache_list no value no value
phar.readonly On On
phar.require_hash On On

Reflection

Reflection enabled
Version $Revision: 293036 $

session

Session Support enabled
Registered save handlers files user memcache sqlite
Registered serializer handlers php php_binary wddx

Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 On On
session.bug_compat_warn On On
session.cache_expire 180 180
session.cache_limiter nocache nocache
session.cookie_domain no value no value
session.cookie_httponly Off Off
session.cookie_lifetime 0 0
session.cookie_path / /
session.cookie_secure Off Off
session.entropy_file no value no value
session.entropy_length 0 0
session.gc_divisor 100 100
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.hash_bits_per_character 4 4
session.hash_function 0 0
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path no value no value
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies On On
session.use_trans_sid 0 0

shmop

shmop support enabled

SimpleXML

Simplexml support enabled
Revision $Revision: 293036 $
Schema support enabled

soap

Soap Client enabled
Soap Server enabled

Directive Local Value Master Value
soap.wsdl_cache 1 1
soap.wsdl_cache_dir /tmp /tmp
soap.wsdl_cache_enabled 1 1
soap.wsdl_cache_limit 5 5
soap.wsdl_cache_ttl 86400 86400

sockets

Sockets Support enabled

SPL

SPL support enabled
Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException

SQLite

SQLite support enabled
PECL Module version 2.0-dev $Id: sqlite.c 293036 2010-01-03 09:23:27Z sebastian $
SQLite Library 2.8.17
SQLite Encoding iso8859

Directive Local Value Master Value
sqlite.assoc_case 0 0

sqlsrv

sqlsrv support enabled

Directive Local Value Master Value
sqlsrv.LogSeverity 0 0
sqlsrv.LogSubsystems 0 0
sqlsrv.WarningsReturnAsErrors On On

standard

Dynamic Library Support enabled
Internal Sendmail Support for Windows enabled

Directive Local Value Master Value
assert.active 1 1
assert.bail 0 0
assert.callback no value no value
assert.quiet_eval 0 0
assert.warning 1 1
auto_detect_line_endings 0 0
default_socket_timeout 60 60
safe_mode_allowed_env_vars PHP_ PHP_
safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
url_rewriter.tags a=href,area=href,frame=src,form=,fieldset= a=href,area=href,frame=src,form=,fieldset=
user_agent no value no value

tidy

Tidy support enabled
libTidy Release 1st August 2004
Extension Version 2.0 ($Id: tidy.c 294893 2010-02-11 17:36:40Z johannes $)

Directive Local Value Master Value
tidy.clean_output 0 0
tidy.default_config no value no value

tokenizer

Tokenizer Support enabled

uploadprogress

uploadprogress support enabled
Version 1.0.1

Directive Local Value Master Value
uploadprogress.file.contents_template \/upload_contents_%s \/upload_contents_%s
uploadprogress.file.filename_template \/upt_%s.txt \/upt_%s.txt
uploadprogress.get_contents 0 0

wddx

WDDX Support enabled
WDDX Session Serializer enabled

xml

XML Support active
XML Namespace Support active
libxml2 Version 2.7.3

xmlrpc

core library version xmlrpc-epi v. 0.51
php extension version 0.51
author Dan Libby
homepage http://xmlrpc-epi.sourceforge.net
open sourced by Epinions.com

xmlwriter

XMLWriter enabled

Zend Debugger

Expose Zend Debugger never
Passive Mode Timeout 20 seconds

Directive Local Value Master Value
zend_debugger.allow_hosts 127.0.0.1/32 127.0.0.1/32
zend_debugger.allow_tunnel no value no value
zend_debugger.deny_hosts no value no value
zend_debugger.expose_remotely never never
zend_debugger.httpd_uid -1 -1
zend_debugger.max_msg_size 2097152 2097152
zend_debugger.tunnel_max_port 65535 65535
zend_debugger.tunnel_min_port 1024 1024
zend_debugger.use_fast_timestamp 1 1
zend_debugger.xdebug_compatible_coverage 0 0

zip

Zip enabled
Extension Version $Id: php_zip.c 294817 2010-02-09 17:51:39Z pajoye $
Zip version 1.9.1
Libzip version 0.9.0

zlib

ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3

Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value

Additional Modules

Module Name

Environment

Variable Value
ALLUSERSPROFILE C:\ProgramData
APPDATA C:\Users\Ross\AppData\Roaming
CommonProgramFiles C:\Program Files (x86)\Common Files
CommonProgramFiles(x86) C:\Program Files (x86)\Common Files
CommonProgramW6432 C:\Program Files\Common Files
COMPUTERNAME HYDROTEL
ComSpec C:\Windows\system32\cmd.exe
FP_NO_HOST_CHECK NO
HOMEDRIVE C:
HOMEPATH \Users\Ross
LOCALAPPDATA C:\Users\Ross\AppData\Local
LOGONSERVER \\HYDROTEL
NUMBER_OF_PROCESSORS 1
OS Windows_NT
Path C:/Program Files (x86)/Java/jre1.5.0_22/bin/client;C:/Program Files (x86)/Java/jre1.5.0_22/bin;C:/Program Files (x86)/Java/jre1.5.0_22/lib/i386;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;c:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\
PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PATH_INFO D:\web\eclipse_projects\test\phpinfo.php
PATH_TRANSLATED D:\web\eclipse_projects\test\phpinfo.php
PHPRC C:\Users\Ross\AppData\Local\Temp\zend_debug\session3899917984549426272.tmp
PROCESSOR_ARCHITECTURE x86
PROCESSOR_ARCHITEW6432 AMD64
PROCESSOR_IDENTIFIER Intel64 Family 6 Model 26 Stepping 5, GenuineIntel
PROCESSOR_LEVEL 6
PROCESSOR_REVISION 1a05
ProgramData C:\ProgramData
ProgramFiles C:\Program Files (x86)
ProgramFiles(x86) C:\Program Files (x86)
ProgramW6432 C:\Program Files
PROMPT $P$G
PSModulePath C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
PUBLIC C:\Users\Public
QUERY_STRING start_debug=1&send_sess_end=1&debug_session_id=1016&debug_start_session=1&debug_port=10000&debug_host=127.0.0.1
REDIRECT_STATUS 1
REQUEST_METHOD GET
SCRIPT_FILENAME D:\web\eclipse_projects\test\phpinfo.php
SCRIPT_NAME D:\web\eclipse_projects\test\phpinfo.php
SESSIONNAME Console
SystemDrive C:
SystemRoot C:\Windows
TEMP C:\Users\Ross\AppData\Local\Temp
TMP C:\Users\Ross\AppData\Local\Temp
USERDOMAIN HYDROTEL
USERNAME Ross
USERPROFILE C:\Users\Ross
windir C:\Windows

PHP Variables

Variable Value
_REQUEST["start_debug"] 1
_REQUEST["send_sess_end"] 1
_REQUEST["debug_session_id"] 1016
_REQUEST["debug_start_session"] 1
_REQUEST["debug_port"] 10000
_REQUEST["debug_host"] 127.0.0.1
_GET["start_debug"] 1
_GET["send_sess_end"] 1
_GET["debug_session_id"] 1016
_GET["debug_start_session"] 1
_GET["debug_port"] 10000
_GET["debug_host"] 127.0.0.1
_SERVER["ALLUSERSPROFILE"] C:\ProgramData
_SERVER["APPDATA"] C:\Users\Ross\AppData\Roaming
_SERVER["CommonProgramFiles"] C:\Program Files (x86)\Common Files
_SERVER["CommonProgramFiles(x86)"] C:\Program Files (x86)\Common Files
_SERVER["CommonProgramW6432"] C:\Program Files\Common Files
_SERVER["COMPUTERNAME"] HYDROTEL
_SERVER["ComSpec"] C:\Windows\system32\cmd.exe
_SERVER["FP_NO_HOST_CHECK"] NO
_SERVER["HOMEDRIVE"] C:
_SERVER["HOMEPATH"] \Users\Ross
_SERVER["LOCALAPPDATA"] C:\Users\Ross\AppData\Local
_SERVER["LOGONSERVER"] \\HYDROTEL
_SERVER["NUMBER_OF_PROCESSORS"] 1
_SERVER["OS"] Windows_NT
_SERVER["Path"] C:/Program Files (x86)/Java/jre1.5.0_22/bin/client;C:/Program Files (x86)/Java/jre1.5.0_22/bin;C:/Program Files (x86)/Java/jre1.5.0_22/lib/i386;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;c:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\
_SERVER["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
_SERVER["PATH_INFO"] D:\web\eclipse_projects\test\phpinfo.php
_SERVER["PATH_TRANSLATED"] D:\web\eclipse_projects\test\phpinfo.php
_SERVER["PHPRC"] C:\Users\Ross\AppData\Local\Temp\zend_debug\session3899917984549426272.tmp
_SERVER["PROCESSOR_ARCHITECTURE"] x86
_SERVER["PROCESSOR_ARCHITEW6432"] AMD64
_SERVER["PROCESSOR_IDENTIFIER"] Intel64 Family 6 Model 26 Stepping 5, GenuineIntel
_SERVER["PROCESSOR_LEVEL"] 6
_SERVER["PROCESSOR_REVISION"] 1a05
_SERVER["ProgramData"] C:\ProgramData
_SERVER["ProgramFiles"] C:\Program Files (x86)
_SERVER["ProgramFiles(x86)"] C:\Program Files (x86)
_SERVER["ProgramW6432"] C:\Program Files
_SERVER["PROMPT"] $P$G
_SERVER["PSModulePath"] C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
_SERVER["PUBLIC"] C:\Users\Public
_SERVER["QUERY_STRING"] start_debug=1&send_sess_end=1&debug_session_id=1016&debug_start_session=1&debug_port=10000&debug_host=127.0.0.1
_SERVER["REDIRECT_STATUS"] 1
_SERVER["REQUEST_METHOD"] GET
_SERVER["SCRIPT_FILENAME"] D:\web\eclipse_projects\test\phpinfo.php
_SERVER["SCRIPT_NAME"] D:\web\eclipse_projects\test\phpinfo.php
_SERVER["SESSIONNAME"] Console
_SERVER["SystemDrive"] C:
_SERVER["SystemRoot"] C:\Windows
_SERVER["TEMP"] C:\Users\Ross\AppData\Local\Temp
_SERVER["TMP"] C:\Users\Ross\AppData\Local\Temp
_SERVER["USERDOMAIN"] HYDROTEL
_SERVER["USERNAME"] Ross
_SERVER["USERPROFILE"] C:\Users\Ross
_SERVER["windir"] C:\Windows
_SERVER["PHP_SELF"] D:\web\eclipse_projects\test\phpinfo.phpD:\web\eclipse_projects\test\phpinfo.php
_SERVER["REQUEST_TIME"] 1282095491
_SERVER["argv"]
Array
(
    [0] => start_debug=1&send_sess_end=1&debug_session_id=1016&debug_start_session=1&debug_port=10000&debug_host=127.0.0.1
)
_SERVER["argc"] 1
_ENV["ALLUSERSPROFILE"] C:\ProgramData
_ENV["APPDATA"] C:\Users\Ross\AppData\Roaming
_ENV["CommonProgramFiles"] C:\Program Files (x86)\Common Files
_ENV["CommonProgramFiles(x86)"] C:\Program Files (x86)\Common Files
_ENV["CommonProgramW6432"] C:\Program Files\Common Files
_ENV["COMPUTERNAME"] HYDROTEL
_ENV["ComSpec"] C:\Windows\system32\cmd.exe
_ENV["FP_NO_HOST_CHECK"] NO
_ENV["HOMEDRIVE"] C:
_ENV["HOMEPATH"] \Users\Ross
_ENV["LOCALAPPDATA"] C:\Users\Ross\AppData\Local
_ENV["LOGONSERVER"] \\HYDROTEL
_ENV["NUMBER_OF_PROCESSORS"] 1
_ENV["OS"] Windows_NT
_ENV["Path"] C:/Program Files (x86)/Java/jre1.5.0_22/bin/client;C:/Program Files (x86)/Java/jre1.5.0_22/bin;C:/Program Files (x86)/Java/jre1.5.0_22/lib/i386;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;c:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\
_ENV["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
_ENV["PATH_INFO"] D:\web\eclipse_projects\test\phpinfo.php
_ENV["PATH_TRANSLATED"] D:\web\eclipse_projects\test\phpinfo.php
_ENV["PHPRC"] C:\Users\Ross\AppData\Local\Temp\zend_debug\session3899917984549426272.tmp
_ENV["PROCESSOR_ARCHITECTURE"] x86
_ENV["PROCESSOR_ARCHITEW6432"] AMD64
_ENV["PROCESSOR_IDENTIFIER"] Intel64 Family 6 Model 26 Stepping 5, GenuineIntel
_ENV["PROCESSOR_LEVEL"] 6
_ENV["PROCESSOR_REVISION"] 1a05
_ENV["ProgramData"] C:\ProgramData
_ENV["ProgramFiles"] C:\Program Files (x86)
_ENV["ProgramFiles(x86)"] C:\Program Files (x86)
_ENV["ProgramW6432"] C:\Program Files
_ENV["PROMPT"] $P$G
_ENV["PSModulePath"] C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
_ENV["PUBLIC"] C:\Users\Public
_ENV["QUERY_STRING"] start_debug=1&send_sess_end=1&debug_session_id=1016&debug_start_session=1&debug_port=10000&debug_host=127.0.0.1
_ENV["REDIRECT_STATUS"] 1
_ENV["REQUEST_METHOD"] GET
_ENV["SCRIPT_FILENAME"] D:\web\eclipse_projects\test\phpinfo.php
_ENV["SCRIPT_NAME"] D:\web\eclipse_projects\test\phpinfo.php
_ENV["SESSIONNAME"] Console
_ENV["SystemDrive"] C:
_ENV["SystemRoot"] C:\Windows
_ENV["TEMP"] C:\Users\Ross\AppData\Local\Temp
_ENV["TMP"] C:\Users\Ross\AppData\Local\Temp
_ENV["USERDOMAIN"] HYDROTEL
_ENV["USERNAME"] Ross
_ENV["USERPROFILE"] C:\Users\Ross
_ENV["windir"] C:\Windows

PHP License

This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license@php.net.


</body></html>
Closed Aug 25, 2010 at 4:51 AM by
API design changed after community feedback from CTP1. API usage is documented correctly, user needed to update the code for this change.

comments

AshayC wrote Aug 19, 2010 at 6:46 PM

We are not able to repro this in-house, it appears that the connection string you use is incorrect in some way. Please post the connection code:
$conn = new PDO(""); // feel free to abstract the alphanumeric parts of the string

rphilip wrote Aug 24, 2010 at 12:23 PM

Thanks for looking at this. Here is the connection string I use:
$server = "hydrotel\sqlexpress";
$db_name = "mydb";
try {
$dbh = new PDO( "sqlsrv:$server", NULL, NULL, array('Database' => $db_name) );
$dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
printf("Connected to Server:%s, database:%s\n",$server,$db_name);
} catch (PDOException $e) {
print "Error!: " . $e->getMessage() . "";
die();
} // catch

AshayC wrote Aug 25, 2010 at 4:49 AM

As we suspected, the usage of the API is incorrect. We have blogged numerous times on this change (see http://blogs.msdn.com/sqlphp) for the CTP2 release as well as RTW, somehow you missed them. Our API reference documentation was also updated for this design change.

Please change the code from:
$dbh = new PDO( "sqlsrv:$server", NULL, NULL, array('Database' => $db_name) );

to:
$dbh = new PDO( "sqlsrv:$server;Database=$db_name"); // you have to pass in the "NULL, NULL" only if you set any of the Connection Options

rphilip wrote Nov 1, 2010 at 9:06 AM

Actually, your recommended change was incorrect:
$dbh = new PDO( "sqlsrv:$server", NULL, NULL, array('Database' => $db_name) ); //Wrong - Obsolete CTP1 //
$dbh = new PDO( "sqlsrv:$server;Database=$db_name"); //Still wrong! //
$dbh = new PDO( "sqlsrv:server = $server;Database = $db_name"); //Works! //

BTW, finding the PHP PDO driver documentation on the Microsoft sites is VERY difficult and obscure. Maybe you could add a link to the online manuals at php.net...