Telenet Cloud Online Help

How does the connection between PHP and MSSQL work?

A native php mssql driver nl. sqlsrv_connect ipv mssql_connect is used

You will find more information on the following link: http://msdn.microsoft.com/en-us/library/cc296189(SQL.90).aspx

Example of a connection:

<?php
/* Specify the server and connection string attributes. */
$serverName = "(sql27.hostbasket.com)";

/* Get UID and PWD from application-specific files. */
$connectionInfo = array( "UID"=>”test”,
"PWD"=>”testje1”,
"Database"=>"AdventureWorks");

/* Connect using SQL Server Authentication. */
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false )
{
echo "Unable to connect.</br>";
die( print_r( sqlsrv_errors(), true));
}

sqlsrv_close( $conn);
?>

 
Additional information:
 
Working with Microsoft SQL Server driver (php_sqlsrv.dll) for PHP on Windows

http://blogs.iis.net/donraman/archive/2010/01/25/working-with-microsoft-sql-server-driver-php-sqlsrv-dll-for-php-on-windows.aspx

mssql vs. sqlsrv: What’s the Difference? (Part 1)

http://blogs.msdn.com/b/brian_swan/archive/2010/03/08/mssql-vs-sqlsrv-what-s-the-difference-part-1.aspx

SQLSRV Driver API Reference

http://msdn.microsoft.com/en-us/library/cc296152(SQL.90).aspx
 
0 (0)
Article Rating (No Votes)
Rate this article
Attachments
There are no attachments for this article.
Related Articles
Install Joomla 2.5
Viewed 10958 times since Mon, Apr 30, 2012
Is Zend Engine supported?
Viewed 2772 times since Mon, Jul 23, 2012
How do I hide any PHP errors on my website?
Viewed 929 times since Tue, Jul 24, 2012
How do I track problems in my PHP website?
Viewed 2131 times since Fri, Jan 21, 2011
Is Zend Guard/Optimizer supported?
Viewed 1118 times since Mon, Jul 23, 2012
What is PHP?
Viewed 1887 times since Thu, Nov 27, 2008
Can I use PHP on IIS 7 (Windows hosting)?
Viewed 1658 times since Tue, Nov 18, 2008
Where can I find the PHP manual?
Viewed 1468 times since Tue, Nov 18, 2008
How do I recognize PHP pages/scripts?
Viewed 2513 times since Tue, Nov 18, 2008
Which PHP version is installed on the server? Which modules are available?
Viewed 2693 times since Tue, Nov 18, 2008