I have a linux server that I’m trying to use php adodb to connect to a MSSQL server.
include('adodb5/adodb.inc.php'); $conn =& ADONewConnection('odbc_mssql'); $dsn = "Driver={SQL Server};Server=MSSERVER;Database=Northwind;"; $conn->Connect($dsn,'sa','password')or die("Unable to connect to server");
I’ve install mssql through yum etc and I know the server can connect to it as I’ve tried the following:
$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);
Any ideas why my adodb wont connect, or any examples on how I can connect would be much appreciated.
Advertisement
Answer
I’ve solved this by looking at this forum: http://ourdatasolution.com/support/discussions.html?topic=4200.0
The correct code is:
<?php include("adodb5/adodb.inc.php"); //create an instance of the ADO connection object $conn =&ADONewConnection ('mssql'); //define connection string, specify database driver $conn->Connect('xxx.xxx.x.xxx:1400', 'user', 'password', 'DbName'); //declare the SQL statement that will query the database $query = "select * from table"; $rs = $conn->execute($query); //execute the SQL statement and return records $arr = $rs->GetArray(); print_r($arr); ?>
Hope that helps somebody else.