Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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Îļþ½âÃÜ

ÎÒÓÐÒ»¸öaspÔ´Â룬µ«ÊdzöÏÖÒ»¸öÎļþ£¬ÎÒÓÃasp½âÃܶ¼ÊÇÂÒÂë
Çë½Ì

VBScript code:
??

 %# , #&')*)-0-(0%()(?

(((((((((((((((((((((((((( ......

ÎÒÏë×öÒ»¸öaspÍøÕ¾£¬µ«ÊDz»ÖªµÀ×öʲô£¡

×î½üÎÒͨ¹ýѧϰ£¬¸Ð¾õ×Ô¼ºÑ§µÄ»¹¿ÉÒÔÁË£¬Ïë×öÒ»ÍøÕ¾£¬µ«ÊÇÒ»Ö±¶¼ÕÒ²»µ½Ìâ²Ä£¬²»ÖªµÀ×öʲô£¬Ï£Íû¸÷λ¸øÎÒµãÒâ¼û£¬Èç¹ûÓÐÐèÇóÎĵµ¾Í¸üºÃÁË£¡Ï£Íû´ó¼Ò¸øÎÒµãÒâ¼û£¬Ð»Ð»£¡
ÏÈ×ö¸öÆóÒµÍøÕ¾°É£¬ÎҸоõÒ»¸öÈË×öÍøÕ¾²»ÊÊÒË ......

ASP½µÐòÎÊÌâ

    <%
  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 ......

Ò»¸öASPÅжÏ×Ö·û´®µÄÎÊÌâ

×Ö¶ÎPowerListÀïÃæµÄÖµ£ºKSO10000,KSO10021,KSO10004,KSO10022,KSO10020,KSO10008
ÏÖÔÚÒªÅжϣ¬µ±PowerListÀïÃæ´æÔÚKSO10004Õâ¸öÖµµÄʱºò£¬Êä³ö£ººÃ


VBScript code:

<%
set rs=server.Creat ......

aspÔõÑùʵÏÖ¸ÊÌØͼµÄЧ¹û£¿ - Web ¿ª·¢ / ASP

ÓÐË­Äܸø½²½²£¬Ôõô×öÂð£¿
ллÀ²£¡
¸ÊÌØͼ ÊÇɶ£¿

½âÌâ˼·.¿´Ò»Ï½ø¶ÈÌõµÄÏÔʾ..
ÆäʵÄã¾ÍŪһ¶Ñtable ÿ¸ötableµÄ¿í¶È²»Í¬.µ×É«²»Í¬¼´¿É
µ±È»ÓÃdiv¿ØÖÆλÖøüºÃ

ÄãŪ100¸ötable¸ù¾Ý½ø¶ÈÆäÖÐÇ°20¸ö·Ö¸øµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ