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
Ïà¹ØÎÊ´ð£º
1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......
mssql_select_db("f1",mssql_connect("localhost","sa","sa"));
mssql_select_db("f2",mssql_connect("192.168.0.1","sa","sa") ......
ÔÚfirefoxä¯ÀÀÆ÷ÏÂÕý³£µÇ½£¬µ«ÔÚIE ä¯ÀÀÆ÷ÏÂÎÞ·¨µÇ½£¬Ã¿´Î¶¼»áÖØÐÂÉú³ÉÒ»¸ösession,ÔÀ´µÄÄÚÈݻᶪʧ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£Ôõô»ØÊÂ......
¾ßÌåÇé¿ö£¿²Â²â¿ÉÄÜÊÇÄã±¾»úIEµÄcookie±»½ûÓÃÁ˰ɣ¬¿ÉÒÔ¿´¿´
cookie Æ ......
ÈçÉÏËùʾ£¬Èç¹ûÎÒ¶¨ÒåÁËÒ»¸ölayout()º¯Êý£¬ÎÒµ÷ÓÃʱÓвÎÊýÔÙcontent£¬ÎÒÏëÔÚlayoutº¯ÊýÀïÃæ²¶×½contentÕâ¸ö²ÎÊý£¬ÄÜ·ñ×öµ½£¿¼´ÎÒÔÚlayoutº¯ÊýÄÜÊä³öcontentÕ⼸¸ö×Öĸ£¬±ÈÈçphpµÄ__get($name)º¯Êý£¬µ±ÎÒÔÚÀàÖв¢Î´¶¨ ......