asp»¹ÊÇÁ¬½Ó²»Éϲ»mssql 2008
connstr = "driver={SQL Server};server=127.0.0.1;UID=sa;PWD=123;database=test1;"
ÒÔÕâÖз½Ê½Ìáʾ
Óû§ 'sa' µÇ¼ʧ°Ü¡£
ÎÒÓÃodbc×öÁËÁ½¸öÊý¾ÝÔ´
connstr = "driver={SQL Server};dsn=test;server=127.0.0.1;UID=sa;PWD=123;database=test1;"
ÒÔÕâÖз½Ê½Ìáʾ
Óû§ 'sa' µÇ¼ʧ°Ü¡£
Êý¾Ý¿âÔÚ±¾»ú
Êý¾Ý¿âµÄÃû³ÆYSERVER\SQLEXPRESS
ÏëÎÊÏÂÊDz»ÊǵÃÏÈÅäÖÃÒ»¸öODBCÊý¾ÝÔ´£¬»¹ÊÇserverÊÇip+Êý¾Ý¿âÃû³Æ
connstr = "driver={SQL Server};server=127.0.0.1\YSERVER\SQLEXPRESS
;UID=sa;PWD=123;database=test1;"
ÒÔÕâÖз½Ê½Á¬½ÓÒ²ÊÇÌáʾ´íÎó
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server ²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø
mssql 2008ÅäÖÃÁËÔÊÐíÔ¶³ÌÁ¬½ÓÁËÂð£¿ÅäÖù¤¾ßÖÐtcpipÐÒéÊÇ·ñÆôÓã¬tcpipÐÒéÊôÐÔÖÐÊÇ·ñÆôÓÃÁ˹̶¨¶Ë¿Ú1433?
2008µÄ¿í¿ÚÊÇ1433£¿Â¥ÉϵĴíÁË°É£¿
2000µÄ¶Ë¿Ú²ÅÊÇ1433
2008µÄµÄtcp/ipµÄ¶Ë¿ÚÒªÉèÖÃÁ½¸öip ÎÒ¶¼ÉèÖÃΪ1433
Äã²»ÓÃIPÁ¬½Ó ÓÃLOCALLÁ¬½Ó
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸öaspÔ´Â룬µ«ÊdzöÏÖÒ»¸öÎļþ£¬ÎÒÓÃasp½âÃܶ¼ÊÇÂÒÂë
Çë½Ì
VBScript code:
??
%# , #&')*)-0-(0%()(?
(((((((((((((((((((((((((( ......
×î½üÎÒͨ¹ýѧϰ£¬¸Ð¾õ×Ô¼ºÑ§µÄ»¹¿ÉÒÔÁË£¬Ïë×öÒ»ÍøÕ¾£¬µ«ÊÇÒ»Ö±¶¼ÕÒ²»µ½Ìâ²Ä£¬²»ÖªµÀ×öʲô£¬Ï£Íû¸÷λ¸øÎÒµãÒâ¼û£¬Èç¹ûÓÐÐèÇóÎĵµ¾Í¸üºÃÁË£¡Ï£Íû´ó¼Ò¸øÎÒµãÒâ¼û£¬Ð»Ð»£¡
ÏÈ×ö¸öÆóÒµÍøÕ¾°É£¬ÎҸоõÒ»¸öÈË×öÍøÕ¾²»ÊÊÒË ......
<%
Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16)"
Rs.Open Sql, conn, 1,1
Do Until Rs.Eof
......
×Ö¶ÎPowerListÀïÃæµÄÖµ£ºKSO10000,KSO10021,KSO10004,KSO10022,KSO10020,KSO10008
ÏÖÔÚÒªÅжϣ¬µ±PowerListÀïÃæ´æÔÚKSO10004Õâ¸öÖµµÄʱºò£¬Êä³ö£ººÃ
VBScript code:
<%
set rs=server.Creat ......
ÓÐËÄܸø½²½²£¬Ôõô×öÂð£¿
ллÀ²£¡
¸ÊÌØͼ ÊÇɶ£¿
½âÌâ˼·.¿´Ò»Ï½ø¶ÈÌõµÄÏÔʾ..
ÆäʵÄã¾ÍŪһ¶Ñtable ÿ¸ötableµÄ¿í¶È²»Í¬.µ×É«²»Í¬¼´¿É
µ±È»ÓÃdiv¿ØÖÆλÖøüºÃ
ÄãŪ100¸ötable¸ù¾Ý½ø¶ÈÆäÖÐÇ°20¸ö·Ö¸øµ ......