Jump to content

ommedia

New Members
  • Posts

    3
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

ommedia's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I have PHP installed on IIS on an XP local server. The MS SQL server is on another box, and is connectable from other applications including .NET. I can't seem to get my connection to work: CODE: $cur_server = 'DNS_SERV_NAME'; $cur_user = 'sa'; $cur_pw = ''; $connection = mssql_connect($cur_server, $cur_user, $cur_pw) or die("Could not connect: "); $dbname = 'db_name'; $db = mssql_select_db($dbname , $connection) or die("Invalid Select: "); $result = mssql_query("SELECT Description FROM Powers WHERE Valid_Flag = 'Y' ORDER BY Description",$connection) or die("Invalid query: "); ERROR: Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: DNS_SERV_NAME in...... Q1: Any suggestions / references ? Q2: Additionally, with MySQL I've used . mysql_error() in my die(). Is there an equivelant or alternative error specifics function that can be used with mssql functions? Thanks, Tim
×
×
  • 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.