[SOLVED] Connecting to MS SQL database

[Yesideez]

Anyone got any links to tutorials?

 

I've tried following the one on the MS website but there's no mention of selecting a user or password.

 

Bit stumped on this one!

 

This is the code so far...

  $serverName='(local)';
  $connectionOptions=array('Database'=>'database');
  $conn=sqlsrv_connect($serverName,$connectionOptions);
  if ($conn===false) {var_dump(sqlsrv_errors()); exit;}
  $query=$_REQUEST['query'];
  $tsql="SELECT * FROM dbo.Client LIMIT 10";
  $getProducts=sqlsrv_query($conn,$tsql,array($query));
  while ($row=sqlsrv_fetch_array($getProducts,SQLSRV_FETCH_ASSOC)) {
    foreach ($row as $key => $val) {
    	echo $key.'='.$val.'<br />';
    }
  }
  sqlsrv_close($conn);

[Yesideez]

OK I've managed to set the username and password using UID and PWD keys in the array but I still can't connect to the database.

 

Anyone played with this before?

[trq]

You'll want to use the odbc extension.

[Yesideez]

No thanks - but we've solved it.

 

Seems the Microsoft documentation is aimed at Microsoft technicians and not Joe Public.

 

Seems we had the database and server name the wrong way round even though the documentation showed it the wrong way :/

 

We can view all the records on the MS SQL server database within PHP using Microsoft's new driver.

[Yesideez]

Also seems MS SQL doesn't have LIMIT, query changed to:

SELECT TOP 10 * FROM dbo.Client