mssql connection?

[D4rkWorkx]

Hello again,

I tried to configure my homepage to connect to my dedicated server (sql server DB 2000) with this:

PHP Code:

$GLOBALS["Connect"] = mssql_connect("178.33.***.XX","USER","PW");

/**
 * Check connection
 */
if (!$GLOBALS["Connect"]) {
    printf("No Connection");
    exit();
} 


But don't matter what I do (disabed firewall, tried some sql server settings, activated tcp/ip in settings). I can't reach the database.

Any Ideas?

[TheBrain_]

Try this.

 Spoiler

<?php
$Server = "178.33.***.XX"; //example' $Server = “DVLP066\SQLEXPRESS”; // host/instance_name (instance name if local)
$User = "USER";
$Pass = "PW";

//connection to the database
$dbhandle = mssql_connect($Server, $User, $Pass)
  or die("Couldn't connect to SQL Server on $myServer"); 
  
//close the connection
mssql_close($dbhandle);
?>

you may also need to enable MSSQL.DLL in your php.ini

[D4rkWorkx]

Originally Posted by TheBrain_

Try this.

 Spoiler

<?php
$Server = "178.33.***.XX"; //example' $Server = “DVLP066\SQLEXPRESS”; // host/instance_name (instance name if local)
$User = "USER";
$Pass = "PW";

//connection to the database
$dbhandle = mssql_connect($Server, $User, $Pass)
  or die("Couldn't connect to SQL Server on $myServer"); 
  
//close the connection
mssql_close($dbhandle);
?>

you may also need to enable MSSQL.DLL in your php.ini

it is enabled...

it told me: Couldn't connect to SQL Server on 178.33.***.XX

edit: I checked over telnet if packets come to destination Port 1433...and yea..my pings come.

But webserver nooot <.< any idea?

edit: got it...thanks

[janvier123]

mssql_connect is old history, you should use

[Decima]

in newer versions of apache and php the old mssql dlls arent supported

[janvier123]

True, but if you REALLY want to use mssql connect, use Xampp 1.7.3 it still have the mssql inside