phpÁ¬½ÓMSSQL Á¬²»ÉÏ - PHP / »ù´¡±à³Ì

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò, SQL state IM002 in SQLConnect in D:\0\msc\msc\tel.php on line 44
ÍêÁË

php.iniphp_mysql.dllÇ°ÃæµÄ·ÖºÅÈ¥µôÁË,ÎļþÒ²¿¼µ½WINDOWSÏÂÃæÈ¥ÁË
httpd.confÎļþÀïÒ²¼ÓÁËLoadFile c:\php\ntwdblib.dll


ÔõôÎÒÓÃPHPÁ¬½ÓmssqlÁ¬²»ÉÏ¡£¡£
ÀÏÊDZ¨Õâ¸ö´íÎ󡣡£

<?php  
  $ser ="220.*.*.*";  
  $db ='db';  
  $user="***";  
  $pass="*****";  
   
  $conn=odbc_connect("Driver={SQL Server};Server=$ser;Database=$db",$user,$pass) OR die("ÍêÁË");  
   
  if($conn) printf ("Connected successfully");  
   
  $sql="select * from city ";  
   
  $result=odbc_do($conn,$sql)or die("query failed");  
   
  $row=odbc_num_rows($result);  
   
  $fetch = odbc_fetch_array($result);  
   
  print_r($fetch);  
  ?>

---

°ïÄ㶥һÏÂ

---

ÎÒÓõÄÊÇMYSQL£¬²»»áMSSQL£¬°ï¶¥£¡

---

ûÓùýMSsql£¬apacheÖØÆôÁËÂð£¿

---

PHP code

---

Code highlighting produced by Actipro Co