Jump to content

can connect to SQL SERVER 97 but cannot to SQL SERVER 2000


hendryx

Recommended Posts

 

 

??? ???Can somebody please help me. I'm a beginner and I can't connect to a SQL server 2000 edition

i've already followed all confirguration i have read in many forum but i cant make it work. please

 

 

<?php

 

//nemo has sql server 97 desktop edition which i can connect (windows 2000)

//neo has sql server 2000 personal edition (windows xp pro)

 

$db_server = "NEMO";

$db_name = "INFOtxt";

$db_username = "sa";

$db_userpassword = "";

 

$sqlStmt="";

 

$dbhandle = mssql_connect($db_server, $db_username, $db_userpassword) or die("Server Error!");

$selected = mssql_select_db($db_name, $dbhandle) or die("Server Error!");

 

$sqlStmt = "SELECT * FROM inbox";

 

//echo $sqlStmt;

 

$sql_result = mssql_query($sqlStmt);

$numRows = mssql_num_rows($sql_result);

 

if ($numRows>0)

{

?>

 

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.