Help with connecting to SQL

[ThreeTrees]

Hi

I recently had to change my database from mysql to sql. with mysql I didnt have any problem but now I cant connect to the sql database.

 

here's the sql connection code

 

<?php
$myServer = "localhost";
$myUser = "sa";
$myPass = "mypassword";
$myDB = "mmt";

$dbhandle = mssql_connect($myServer, $myUser)
  or die("Couldn't connect to SQL Server on $myServer");

$selected = mssql_select_db($myDB, $dbhandle)
  or die("Couldn't open database $myDB");

mssql_close($dbhandle);
?>

 

 

and thats the mysql connection if that helps

 

?php

$con= mysql_connect('localhost','root') or die ('cannot connect bla bla' . mysql_error());
if (!$con) { echo 'WHAT THE FUCK CONNECTION ISNT WORKING'; }

mysql_select_db('mmt') or die ('db fail' . mysql_error());
if (!mysql_select_db('mmt')) { echo ' OH NOES UNDER DAS VEINDER DATABASE'; }

?>

[JonnyThunder]

So what error are you seeing???

 

[ThreeTrees]

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: MORS-010A604462\SQLEXPRESS in C:\wapache\htdocs\db.inc.php on line 7

Couldn't connect to SQL Server on MORS-010A604462\SQLEXPRESS

[Ace Jon]

How long ago did you switch to SQL? If it was a short time, it's possible that thnigs haven't... connected... yet.

[ThreeTrees]

How long ago did you switch to SQL? If it was a short time, it's possible that thnigs haven't... connected... yet.

 

I have it for a few days

and Im able to connect it using the sql manager

 

could it be that  my connection script is wrong?

if any of you guys know any better script it would probably help

[vikramjeet.singla]

please use this

 

<?php
$myServer = "localhost";
$myUser = "sa";
$myPass = "mypassword";
$myDB = "mmt";

$dbhandle = mssql_connect($myServer, $myUser, $myPass )
  or die("Couldn't connect to SQL Server on $myServer");

$selected = mssql_select_db($myDB, $dbhandle)
  or die("Couldn't open database $myDB");

mssql_close($dbhandle);
?>

 

you have not mentioned the password while connecting to sql server

[ThreeTrees]

please use this

 

<?php
$myServer = "localhost";
$myUser = "sa";
$myPass = "mypassword";
$myDB = "mmt";

$dbhandle = mssql_connect($myServer, $myUser, $myPass )
  or die("Couldn't connect to SQL Server on $myServer");

$selected = mssql_select_db($myDB, $dbhandle)
  or die("Couldn't open database $myDB");

mssql_close($dbhandle);
?>

 

you have not mentioned the password while connecting to sql server

 

gives me the same error