{"id":4753,"date":"2010-11-15T16:00:00","date_gmt":"2010-11-16T00:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/"},"modified":"2024-01-22T22:50:08","modified_gmt":"2024-01-23T06:50:08","slug":"php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/","title":{"rendered":"PHP Drivers for SQL Server Whitepaper: SQL PDO and Microsoft SQL Server"},"content":{"rendered":"<p style=\"line-height: normal;list-style-type: disc;background: white;margin-left: 0in;margin-right: 0in\"><span lang=\"EN\"><span style=\"font-family: Calibri\"><span style=\"font-size: 12pt;color: #000000\"><br \/>\nWe are proud to announce the availability of the whitepaper \u201cSQL PDO and Microsoft SQL Server\u201d. While drivers for PHP to access SQL Server have been available for some time now, this new version is a milestone as it gives developers access not only to native PHP drivers, but to PDO drivers as well. This document is intended to show the ease of use and to provide guidance on how to install, access, and use the PHP drivers. <\/span><\/span><\/span><\/p>\n<p style=\"line-height: normal;list-style-type: disc;background: white;margin-left: 0in;margin-right: 0in\"><span lang=\"EN\"><span style=\"font-family: Calibri\"><span style=\"font-size: 12pt;color: #000000\">The document also provides insights on how to use the drivers with SQL Azure, migrating from MySQL guidelines, and troubleshooting for logs and query plans.<\/span><\/span><\/span><\/p>\n<div style=\"line-height: normal;list-style-type: disc;margin: 0in 0in 0pt\"><span style=\"font-family: Calibri\"><span style=\"font-size: 12pt;color: #000000\">\u00a0<\/span><\/span><\/div>\n","protected":false},"excerpt":{"rendered":"<p>We are proud to announce the availability of the whitepaper \u201cSQL PDO and Microsoft SQL Server\u201d. While drivers for PHP to access SQL Server have been available for some time now, this new version is a milestone as it gives developers access not only to native PHP drivers, but to PDO drivers as well.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2421],"topic":[],"coauthors":[2487],"class_list":["post-4753","post","type-post","status-publish","format-standard","hentry","content-type-announcements","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>PHP Drivers for SQL Server Whitepaper: SQL PDO and Microsoft SQL Server - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PHP Drivers for SQL Server Whitepaper: SQL PDO and Microsoft SQL Server - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"We are proud to announce the availability of the whitepaper \u201cSQL PDO and Microsoft SQL Server\u201d. While drivers for PHP to access SQL Server have been available for some time now, this new version is a milestone as it gives developers access not only to native PHP drivers, but to PDO drivers as well.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2010-11-16T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"&lt;1 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"PHP Drivers for SQL Server Whitepaper: SQL PDO and Microsoft SQL Server\",\"datePublished\":\"2010-11-16T00:00:00+00:00\",\"dateModified\":\"2024-01-23T06:50:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/\"},\"wordCount\":115,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/\",\"name\":\"PHP Drivers for SQL Server Whitepaper: SQL PDO and Microsoft SQL Server - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2010-11-16T00:00:00+00:00\",\"dateModified\":\"2024-01-23T06:50:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHP Drivers for SQL Server Whitepaper: SQL PDO and Microsoft SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PHP Drivers for SQL Server Whitepaper: SQL PDO and Microsoft SQL Server - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"PHP Drivers for SQL Server Whitepaper: SQL PDO and Microsoft SQL Server - Microsoft SQL Server Blog","og_description":"We are proud to announce the availability of the whitepaper \u201cSQL PDO and Microsoft SQL Server\u201d. While drivers for PHP to access SQL Server have been available for some time now, this new version is a milestone as it gives developers access not only to native PHP drivers, but to PDO drivers as well.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2010-11-16T00:00:00+00:00","article_modified_time":"2024-01-23T06:50:08+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"<1 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"PHP Drivers for SQL Server Whitepaper: SQL PDO and Microsoft SQL Server","datePublished":"2010-11-16T00:00:00+00:00","dateModified":"2024-01-23T06:50:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/"},"wordCount":115,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/","name":"PHP Drivers for SQL Server Whitepaper: SQL PDO and Microsoft SQL Server - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2010-11-16T00:00:00+00:00","dateModified":"2024-01-23T06:50:08+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/11\/15\/php-drivers-for-sql-server-whitepaper-sql-pdo-and-microsoft-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"PHP Drivers for SQL Server Whitepaper: SQL PDO and Microsoft SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/4753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=4753"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/4753\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=4753"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=4753"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=4753"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=4753"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=4753"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=4753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}