I can not connect to SQL Server 2008 Release 2; from fast CGI PHP on IIS7 and winows server 2008 R2; using Microsoft Drivers for PHP for SQL Server, SQLSRV30.EXE and PHP 5.4.0


  • I am running FastCGI PHP 5.4.0 x64 on IIS 7.5 on windows server 2008 R2 datacenter

    To connect to SQL Server 2008 Release 2, I am trying to use Microsoft Drivers for PHP for SQL Server, SQLSRV30.EXE.

    I edited the PHP.ini file,

    extension_dir = "ext"


    When I issue the phpinfo() command, I get, "without-pdo-mssql"

    Error log :  [07-Dec-2012 14:16:20 UTC] PHP Fatal error:  Uncaught exception 'PDOException' with message 'could not find driver' in C:\inetpub\wwwroot\tests\pdo.php:11
    Stack trace:
    #0 C:\inetpub\wwwroot\tests\pdo.php(11): PDO->__construct('sqlsrv:server=S...', 'sa', 'manager')
    #1 {main}
      thrown in C:\inetpub\wwwroot\tests\pdo.php on line 11


    Friday, December 07, 2012 2:19 PM


  • Unfortunately at the moment I don't have time; I do my builds using the pre-compiled library from the PHP group, which is still 32 bit, even (inexplicably) on PHP 5.5 which no longer supports XP.

    I would have to find or build all of the PHP supporting libraries in 64 bit, then compile all of PHP in 64 bit, then compile the sqlsrv driver in 64 bit, then make sure (or hope) that in the millions of implicit conversions and instructions that come out, there is not one that does something differently to the 32-bit version.

    Please try to install the correct Oracle 32-bit driver to access their 64-bit database.  I have not heard that a 32-bit client cannot access a 64-bit Oracle server.


    Wednesday, December 12, 2012 10:16 AM

All replies

  • Ignore "without-pdo-mssql" it's nothing to do with sqlsrv. The driver 'mssql' was written by the PHP team and is not part of PHP any more, hence the message.  Microsoft provides the driver, and it isn't called mssql in PHP, it's called sqlsrv.

    Have you given us your 'sa' password there? Someone with access to your database might read this, so you should change the password.  I hope you haven't used the same password on all of your servers, or you will be busy.

    To run SQLSRV30.EXE on your computer, you need to install the SQL Server 2012 Native Client driver, have you done that? 

    Native client 2012 connects to both SQL 2012, and 2008 R2.


    Friday, December 07, 2012 4:12 PM
  • No problem with sa pasword, it's not a published server.

    Yes i have install SQL Server 2012 Native Client.

    I steel have this message when i use PDO : 'could not find driver' and when i use sqlsrv_connect i have this error :

    [07-Dec-2012 17:05:16 UTC] PHP Fatal error:  Call to undefined function sqlsrv_connect() in C:\inetpub\wwwroot\tests\sql.php on line 13

    My Phpinfo :

    PHP Version 5.4.0

    System  Windows NT SRVAPP-WEB 6.1 build 7601 (Windows Server 2008 R2 Datacenter Edition Service Pack 1) AMD64 
    Build Date  Apr 7 2012 19:21:54 
    Compiler  MSVC9 (Visual C++ 2008) 
    Architecture  x64 
    Configure Command  cscript /nologo configure.js "--enable-snapshot-build" "--without-dblib" "--without-pdo-dblib" "--without-pdo-mssql" "--with-pdo-oci=C:\php-sdk\php54dev\vc9\x64\deps\instantclient_10_2\sdk,shared" "--with-oci8=C:\php-sdk\php54dev\vc9\x64\deps\instantclient_10_2\sdk,shared" "--with-oci8-11g=C:\php-sdk\php54dev\vc9\x64\deps\instantclient_11_2\sdk,shared" "--disable-debug-pack" "--disable-static-analyze" "--disable-zts" 
    Server API  CGI/FastCGI 
    Virtual Directory Support  disabled 
    Configuration File (php.ini) Path  C:\Windows 
    Loaded Configuration File  C:\PHP_540\php.ini 
    Scan this dir for additional .ini files  (none) 
    Additional .ini files parsed  (none) 
    PHP API  20100412 
    PHP Extension  20100525 
    Zend Extension  220100525 
    Zend Extension Build  API220100525,NTS,VC9 
    PHP Extension Build  API20100525,NTS,VC9 
    Debug Build  no 
    Thread Safety  disabled 
    Zend Signal Handling  disabled 
    Zend Memory Manager  enabled 
    Zend Multibyte Support  disabled 
    IPv6 Support  enabled 
    DTrace Support  disabled 
    Registered PHP Streams php, file, glob, data, http, ftp, zip, compress.zlib, phar
    Registered Stream Socket Transports tcp, udp
    Registered Stream Filters convert.iconv.*, mcrypt.*, mdecrypt.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, zlib.*

     This program makes use of the Zend Scripting Language Engine:
    Zend Engine v2.4.0, Copyright (c) 1998-2012 Zend Technologies


    PHP Credits


    BCMath support  enabled 

    Directive Local Value Master Value
    bcmath.scale 0 0

    Calendar support  enabled 

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

    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

    PHP Version  5.4.0 

    Directive Local Value Master Value
    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
    disable_classes no value no value
    disable_functions no value no value
    display_errors Off Off
    display_startup_errors Off Off
    doc_root no value no value
    docref_ext no value no value
    docref_root no value no value
    enable_dl Off Off
    enable_post_data_reading On On
    error_append_string no value no value
    error_log C:\Windows\Temp\PHP_via_FastCGI_errors.log C:\Windows\Temp\PHP_via_FastCGI_errors.log
    error_prepend_string no value no value
    error_reporting 22527 22527
    exit_on_timeout Off Off
    expose_php On On
    extension_dir C:\PHP_540\ext\ C:\PHP_540\ext\
    file_uploads On On
    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 Off Off
    implicit_flush Off Off
    include_path .;C:\php\pear .;C:\php\pear
    log_errors On On
    log_errors_max_len 1024 1024
    mail.add_x_header On On
    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 60 60
    max_input_vars 1000 1000
    memory_limit 128M 128M
    open_basedir no value no value
    output_buffering 4096 4096
    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 Off Off
    report_memleaks On On
    report_zend_debug On On
    request_order GP GP
    sendmail_from no value no value
    sendmail_path no value no value
    serialize_precision 17 17
    short_open_tag Off Off
    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 C:\Windows\Temp\ C:\Windows\Temp\
    user_dir no value no value
    user_ini.cache_ttl 300 300
    user_ini.filename .user.ini .user.ini
    variables_order GPCS GPCS
    windows.show_crt_warning Off Off
    xmlrpc_error_number 0 0
    xmlrpc_errors Off Off
    zend.detect_unicode On On
    zend.enable_gc On On
    zend.multibyte Off Off
    zend.script_encoding no value no value

    ctype functions  enabled 

    date/time support  enabled 
    "Olson" Timezone Database Version  2011.14 
    Timezone Database  internal 
    Default timezone  Europe/Belgrade 

    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 Europe/Belgrade Europe/Belgrade

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

    Regex Library  Bundled library enabled 

    Input Validation and Filtering  enabled 
    Revision  $Revision: 321634 $ 

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

    FTP support  enabled 

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

    Directive Local Value Master Value
    gd.jpeg_ignore_warning 0 0

    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 fnv132 fnv164 joaat 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 support  enabled 
    iconv implementation  "libiconv" 
    iconv library version  1.11 

    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

    json support  enabled 
    json version  1.2.1 

    libXML support  active 
    libXML Compiled Version  2.7.8 
    libXML Loaded Version  20708 
    libXML streams  enabled 

    mcrypt support enabled
    mcrypt_filter support enabled
    Version  2.5.8 
    Api No  20021217 
    Supported ciphers  cast-128 gost rijndael-128 twofish cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes arcfour 
    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

    MHASH support  Enabled 
    MHASH API Version  Emulated Support 

    mysqlnd enabled
    Version  mysqlnd 5.0.10 - 20111026 - $Revision: 323634 $ 
    Compression  supported 
    SSL  supported 
    Command buffer size  4096 
    Read buffer size  32768 
    Read timeout  31536000 
    Collecting statistics  Yes 
    Collecting memory statistics  No 
    Tracing  n/a 
    Loaded plugins  mysqlnd,example,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password 
    API Extensions  no value 

    mysqlnd 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_amount  0 
    mem_ecalloc_count  0 
    mem_ecalloc_amount  0 
    mem_erealloc_count  0 
    mem_erealloc_amount  0 
    mem_efree_count  0 
    mem_efree_amount  0 
    mem_malloc_count  0 
    mem_malloc_amount  0 
    mem_calloc_count  0 
    mem_calloc_amount  0 
    mem_realloc_count  0 
    mem_realloc_amount  0 
    mem_free_count  0 
    mem_free_amount  0 
    mem_estrndup_count  0 
    mem_strndup_count  0 
    mem_estndup_count  0 
    mem_strdup_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 
    bytes_received_real_data_normal  0 
    bytes_received_real_data_ps  0 

    example statistics 
    stat1  0 
    stat2  0 

    OCI8 Support  enabled 
    Version  1.4.7 
    Revision  $Revision: 321634 $ 
    Active Persistent Connections  0 
    Active Connections  0 
    Oracle Run-time Client Library Version 
    Oracle Instant Client Version  11.2 
    Temporary Lob support  enabled 
    Collections support  enabled 

    Directive Local Value Master Value
    oci8.connection_class no value no value
    oci8.default_prefetch 100 100 Off Off
    oci8.max_persistent -1 -1
    oci8.old_oci_close_semantics Off Off
    oci8.persistent_timeout -1 -1
    oci8.ping_interval 60 60
    oci8.privileged_connect Off Off
    oci8.statement_cache_size 20 20

    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

    PCRE (Perl Compatible Regular Expressions) Support  enabled 
    PCRE Library Version  8.12 2011-01-15 

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

    PDO support enabled
    PDO drivers  no value 

    Phar: PHP Archive support enabled
    Phar EXT version  2.0.1 
    Phar API version  1.1.1 
    SVN revision  $Revision: 321634 $ 
    Phar-based phar archives  enabled 
    Tar-based phar archives  enabled 
    ZIP-based phar archives  enabled 
    gzip compression  enabled 
    bzip2 compression  disabled (install pecl/bz2) 
    Native 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 enabled
    Version  $Revision: 321634 $ 

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

    Directive Local Value Master Value
    session.auto_start Off Off
    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 1000 1000
    session.gc_maxlifetime 1440 1440
    session.gc_probability 1 1
    session.hash_bits_per_character 5 5
    session.hash_function 0 0 PHPSESSID PHPSESSID
    session.referer_check no value no value
    session.save_handler files files
    session.save_path C:\Windows\Temp\ C:\Windows\Temp\
    session.serialize_handler php php
    session.upload_progress.cleanup On On
    session.upload_progress.enabled On On
    session.upload_progress.freq 1% 1%
    session.upload_progress.min_freq 1 1 PHP_SESSION_UPLOAD_PROGRESS PHP_SESSION_UPLOAD_PROGRESS
    session.upload_progress.prefix upload_progress_ upload_progress_
    session.use_cookies On On
    session.use_only_cookies On On
    session.use_trans_sid 0 0

    Simplexml support enabled
    Revision  $Revision: 321634 $ 
    Schema support  enabled 

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

    Dynamic Library Support  enabled 
    Internal Sendmail Support for Windows  enabled 

    Directive Local Value Master Value 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
    from no value no value
    url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry
    user_agent no value no value

    Tokenizer Support  enabled 

    WDDX Support enabled
    WDDX Session Serializer  enabled 

    XML Support  active 
    XML Namespace Support  active 
    libxml2 Version  2.7.8 

    XMLReader  enabled 

    XMLWriter  enabled 

    Zip  enabled 
    Extension Version  $Id: php_zip.c 321634 2012-01-01 13:15:04Z felipe $ 
    Zip version  1.9.1 
    Libzip version  0.9.0 

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

    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

    Variable Value
    PHPRC  C:\PHP_540\ 
    ALLUSERSPROFILE  C:\ProgramData 
    APPDATA  C:\Windows\system32\config\systemprofile\AppData\Roaming 
    APP_POOL_CONFIG  C:\inetpub\temp\apppools\DefaultAppPool\DefaultAppPool.config 
    APP_POOL_ID  DefaultAppPool 
    CommonProgramFiles  C:\Program Files\Common Files 
    CommonProgramFiles(x86)  C:\Program Files (x86)\Common Files 
    CommonProgramW6432  C:\Program Files\Common Files 
    ComSpec  C:\Windows\system32\cmd.exe 
    LOCALAPPDATA  C:\Windows\system32\config\systemprofile\AppData\Local 
    ORACLE_HOME  C:\instantclient_11_2 
    OS  Windows_NT 
    Path  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\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;c:\instantclient_11_2; 
    PROCESSOR_IDENTIFIER  Intel64 Family 6 Model 44 Stepping 2, GenuineIntel 
    ProgramData  C:\ProgramData 
    ProgramFiles  C:\Program Files 
    ProgramFiles(x86)  C:\Program Files (x86) 
    ProgramW6432  C:\Program Files 
    PSModulePath  C:\Windows\system32\WindowsPowerShell\v1.0\Modules\ 
    PUBLIC  C:\Users\Public 
    SystemDrive  C: 
    SystemRoot  C:\Windows 
    TEMP  C:\Windows\TEMP 
    TMP  C:\Windows\TEMP 
    USERPROFILE  C:\Windows\system32\config\systemprofile 
    windir  C:\Windows 
    windows_tracing_flags  3 
    windows_tracing_logfile  C:\BVTBin\Tests\installpackage\csilogfile.log 

    PHP Variables
    Variable Value
    _SERVER["PHPRC"] C:\PHP_540\
    _SERVER["APPDATA"] C:\Windows\system32\config\systemprofile\AppData\Roaming
    _SERVER["APP_POOL_CONFIG"] C:\inetpub\temp\apppools\DefaultAppPool\DefaultAppPool.config
    _SERVER["APP_POOL_ID"] DefaultAppPool
    _SERVER["CommonProgramFiles"] C:\Program Files\Common Files
    _SERVER["CommonProgramFiles(x86)"] C:\Program Files (x86)\Common Files
    _SERVER["CommonProgramW6432"] C:\Program Files\Common Files
    _SERVER["ComSpec"] C:\Windows\system32\cmd.exe
    _SERVER["LOCALAPPDATA"] C:\Windows\system32\config\systemprofile\AppData\Local
    _SERVER["ORACLE_HOME"] C:\instantclient_11_2
    _SERVER["OS"] Windows_NT
    _SERVER["Path"] 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\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;c:\instantclient_11_2;
    _SERVER["PROCESSOR_IDENTIFIER"] Intel64 Family 6 Model 44 Stepping 2, GenuineIntel
    _SERVER["ProgramData"] C:\ProgramData
    _SERVER["ProgramFiles"] C:\Program Files
    _SERVER["ProgramFiles(x86)"] C:\Program Files (x86)
    _SERVER["ProgramW6432"] C:\Program Files
    _SERVER["PSModulePath"] C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
    _SERVER["PUBLIC"] C:\Users\Public
    _SERVER["SystemDrive"] C:
    _SERVER["SystemRoot"] C:\Windows
    _SERVER["TEMP"] C:\Windows\TEMP
    _SERVER["TMP"] C:\Windows\TEMP
    _SERVER["USERPROFILE"] C:\Windows\system32\config\systemprofile
    _SERVER["windir"] C:\Windows
    _SERVER["windows_tracing_flags"] 3
    _SERVER["windows_tracing_logfile"] C:\BVTBin\Tests\installpackage\csilogfile.log
    _SERVER["ORIG_PATH_INFO"] /vo2prdd4.php
    _SERVER["URL"] /vo2prdd4.php
    _SERVER["SERVER_SOFTWARE"] Microsoft-IIS/7.5
    _SERVER["SERVER_NAME"] localhost
    _SERVER["SCRIPT_NAME"] /vo2prdd4.php
    _SERVER["SCRIPT_FILENAME"] C:\inetpub\wwwroot\vo2prdd4.php
    _SERVER["REQUEST_URI"] /vo2prdd4.php
    _SERVER["REMOTE_USER"] no value
    _SERVER["REMOTE_PORT"] 64798
    _SERVER["QUERY_STRING"] no value
    _SERVER["PATH_TRANSLATED"] C:\inetpub\wwwroot\vo2prdd4.php
    _SERVER["LOGON_USER"] no value
    _SERVER["HTTPS_KEYSIZE"] no value
    _SERVER["HTTPS"] off
    _SERVER["DOCUMENT_ROOT"] C:\inetpub\wwwroot
    _SERVER["CONTENT_TYPE"] no value
    _SERVER["CERT_SUBJECT"] no value
    _SERVER["CERT_ISSUER"] no value
    _SERVER["CERT_FLAGS"] no value
    _SERVER["CERT_COOKIE"] no value
    _SERVER["AUTH_USER"] no value
    _SERVER["AUTH_PASSWORD"] no value
    _SERVER["AUTH_TYPE"] no value
    _SERVER["APPL_PHYSICAL_PATH"] C:\inetpub\wwwroot\
    _SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Win64; x64; Trident/5.0; .NET CLR 2.0.50727; SLCC2; .NET4.0C; .NET4.0E; .NET CLR 3.5.30729; .NET CLR 3.0.30729)
    _SERVER["HTTP_HOST"] localhost
    _SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
    _SERVER["PHP_SELF"] /vo2prdd4.php
    _SERVER["REQUEST_TIME_FLOAT"] 1354900135.1386
    _SERVER["REQUEST_TIME"] 1354900135

    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.



    Friday, December 07, 2012 5:11 PM
  • Thanks.  Is that a 64 bit build of PHP?  If so you need to find a 64 bit build of Microsoft's driver.


    Saturday, December 08, 2012 7:24 PM
  • Yes it's a 64 bit PHP.

    where can i find a 64 bit build of this driver please ?

    Monday, December 10, 2012 1:30 PM
  • The PHP group has not released a 64 bit version yet, so you'll have to Google it.

    Did you know that you don't need to install a 64-bit version of PHP?

    When you use the FastCGI interface for IIS or Apache, 32-bit PHP will work under a 64-bit web server.


    Tuesday, December 11, 2012 9:57 AM
  • But i need to access to 64 bit oracle db on another server, so i have to use oracle 64 bit driver .... and it doesn't work without PHP 64 bit....

    it's not simple !

    Wednesday, December 12, 2012 7:06 AM
  • i tried to find a 64 bit version of this driver without success ...

    Could you please help me ?

    Wednesday, December 12, 2012 8:14 AM
  • Unfortunately at the moment I don't have time; I do my builds using the pre-compiled library from the PHP group, which is still 32 bit, even (inexplicably) on PHP 5.5 which no longer supports XP.

    I would have to find or build all of the PHP supporting libraries in 64 bit, then compile all of PHP in 64 bit, then compile the sqlsrv driver in 64 bit, then make sure (or hope) that in the millions of implicit conversions and instructions that come out, there is not one that does something differently to the 32-bit version.

    Please try to install the correct Oracle 32-bit driver to access their 64-bit database.  I have not heard that a 32-bit client cannot access a 64-bit Oracle server.


    Wednesday, December 12, 2012 10:16 AM
  • thank you anyway.

    Thursday, December 13, 2012 7:34 AM