GOD someone help me!!!

travelerBT

I am trying to access an MS sql server through PHP, I have verified that I am able to connect to the MS SQL server by connecting through an alternate source. Here is my code.

$sqlServer = 'SQL10.sqlsvr.net';
$sqlUser = 'CMSADMIN';
$sqlPass = 'password';
$db = 'attaincms';

$s = mssql_connect($sqlServer, $sqlUser, $sqlPass) or die("Couldn't connect to SQL Server on $sqlServer");

$d = mssql_select_db($db, $s) or die("Couldn't open database $db");

$query = "SELECT LastName FROM Account WHERE AccountId = 110";

$result = mssql_query($query);
$numRows = mssql_num_rows($result);

echo "<h1>" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned </h1>";

while($row = mssql_fetch_array($result))
{
echo "<li>" . $row["LastName"] . "</li>";
}

The page loads and doesn't throw any die errors, and I don't get any other errors either. I have verified with the Server provider that the proper settings are in place for the php.ini file.

PEASE HELP ME!!!! :mad: :mad: :mad:

laserlight

Sorry, I am not God, so I cannot read your mind to find out how does your script not work.

ashley98860615

["LastName"] try single quotes for stuff like this

Volitics

I'm not familiar with mssql but you might try the PHP Manual for examples of how to get mssql to work:
http://us3.php.net/manual/en/ref.mssql.php

ahundiak

In general, addressing your post to a specific individual is not a good idea. And it's very doubtful that many supernatural beings monitor this board. Though I think Kali does every so often.

ClarkF1

You might need single quotes around the 110 as well

travelerBT

I have tried all of the suggestions above to no avail... please keep them coming. I have read the php.net suggestions and followed up with my SQL server provider and found that the sql server is a single instance, as well as listening on the right socket and using SQL server authentication... PLEASE HELP... I will call you GOD if you can get this one 🙂

leatherback

No Need To Call Anyone God, Try Church / Temple / Mosque If You Want His Help.

If you do not get errors, the page loads, and you are properly connected (Which makes sense, otherwise you WOULD get and error.. Let's assume the $query is wrong shall we?

Add a die() statement after the mssql_query() statement:
$result = mssql_query($query) or die('This is whats wrong:'.$mssql_error()."in your query:".$query);
(I am assuming there is a thing called mssql_error.

I think your query is case-sensitive, and you have non-caps in your colum/table names but not in the query, or something silly like that.

travelerBT

I found out that it was an idiot that I talked to at our server provider (Spry) and here is the problem.

There are 2 issues with the server that need to be addressed to make the MS SQL connection:

There is a .dll file that needs to be copied from the MS SQL server to the PHP server. It is called ntwdblib.dll . They told me it was there and low and behold NOPE! :xbones:
You need to install the freeTDS libraries on the PHP server. www.freeTDS.org this isn't too hard, but it would have been nice if they had known what they were talking about when I spoke with them first time arround. :glare:

I guess this makes me GOD doens't it :evilgrin:

Thanks for all your help everyone... 😃