SQL Server connection error.

"Russell Roberts-Spears" <russellpocketpc@hotmail.com> · Sat, 07 Jun 2003 12:34:31 +0000

Hi,

I am new to PHP DB code and am currently struggling with the connection to 
SQL Server 2000. I am using ODBC and have created a System DSN with 
integrated NT security specifiying which DB etc. I have written the 
following code and posted it in the htdocs folder for Apache. (We are all 
running on Win2000 platforms, Web server is set apart from the DB server, 
but linked via LAN.

PHP code:

<HEAD>
 <TITLE>ADODB Test in PHP</TITLE>
</HEAD>
<BODY>
 <?php

// simple conection

$cnx = odbc_connect('web', '', '');
//query
$SQL_Exec_String =  "select * from TblClients";
//ejecucion query
$cur= odbc_exec( $cnx, $SQL_Exec_String );
echo  "<table border=1><tr><th>Dni</th><th>Nombre</th>".
       "<th>codigo</th><th>ciudad</th></tr>\n";
  while( odbc_fetch_row( $cur ) ) {
     $Title= odbc_result( $cur, 1 );
     $Fname= odbc_result( $cur, 2 );
     $Surname= odbc_result( $cur, 3 );
     $Address1= odbc_result( $cur, 4 );
      echo "<tr><td>$Title</td><td>$Fname</td>".
           "<td>$Surname</td><td>$Address1</td></tr>\n";
  }
  echo  "</table>";

?>
</BODY>
</HTML>

////////////////////////////////

I then get back the following error:

Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login 
failed for user 'PROTE\LATTITUDWEBSERV$'., SQL state 28000 in SQLConnect in 
C:\Apache\Apache2\htdocs\DBtest.php on line 9

Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in 
C:\Apache\Apache2\htdocs\DBtest.php on line 10

DATA FROM SQL SERVER WITH PHP4 Cand_ID Password

Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result 
resource in C:\Apache\Apache2\htdocs\DBtest.php on line 14

Am at a loss as to why the error. Have created another DSN in same system 
which links in using VB to the same SQL Server using the same NT integrated 
security and it is fine, so I am a little perplexed.

Any help or pointers would be gratefully received

Best regards

Russell

_________________________________________________________________

Stay in touch with absent friends - get MSN Messenger 
http://www.msn.co.uk/messenger

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php