title: php adodb MSSQL connection
body: <p>I have a linux server that I'm trying to use php adodb to connect to a MSSQL server. </p>
  
  <pre><code>include('adodb5/adodb.inc.php'); 
  
  $conn =&amp; ADONewConnection('odbc_mssql');
  $dsn = "Driver={SQL Server};Server=MSSERVER;Database=Northwind;";
  $conn-&gt;Connect($dsn,'sa','password')or die("Unable to connect to server");
  </code></pre>
  
  <p>I've install mssql through yum etc and I know the server can connect to it as I've tried the following:</p>
  
  <pre><code>$db = @mssql_connect("MSSERVER","sa","password") or die("Unable to connect to server");
  mssql_select_db("Northwind");
  
  // Do a simple query, select the version of 
  // MSSQL and print it.
  $version = mssql_query('SELECT @@VERSION');
  $row = mssql_fetch_array($version);
  
  echo $row[0];
  
  // Clean up
  mssql_free_result($version);
  </code></pre>
  
  <p>Any ideas why my adodb wont connect, or any examples on how I can connect would be much appreciated.</p>