Help me. Register to MSSQL can't connect

yerror says that MSSQL server is not correctly set in settings file. just rechek

red_ua said:

yerror says that MSSQL server is not correctly set in settings file. just rechek

Click to expand...

<?php
$host = "mmo\sqlexpress/127.0.0.1";
$user = "sa";
$pass = "137946";
$dbname = "RZ_ACCOUNTDB";

$connect = odbc_connect("Driver={SQL Server};Server={$host}; Database={$dbname}", $user, $pass) or die("Can't connect the MSSQL server.");

$userid = $_Post['username'];
$pass = $_Post['password'];
$login = md5($userid . ' ' . $pass);

$result = odbc_exec($connect, "SELECT USER_ID FROM RZ_ACCOUNTDB WHERE USER_ID = '$userid'");
$existing_users = num_rows($result);
if($existing_users >= 1) {
echo "Username in use.";
}

if (!$_POST['username'] )
{
die('You left User ID field blank');
}

if (!$_POST['password'] )
{
die('You left Password field blank');
}

odbc_exec($connect, "INSERT INTO RZ_ACCOUNT (USER_ID, SITE_CODE, SITE_USER_ID, PWD, ACC_PTM) VALUES ('$login', '$userid', '$login', '$pass', '0')");

?>

Change $host = "mmo\sqlexpress/127.0.0.1" to $host = "127.0.0.1"