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

SQLserver Á¬½ÓÎÊÌâ £¡£¡£¡ÔÚÏߵȣ¡£¡

´ò¿ªÊý¾Ý¿âµÄʱºò ³öÏÖÕâ¸ö´íÎó£ºprovider: TCP Ìṩ³ÌÐò,error:0- Ô¶³ÌÖ÷»úÇ¿ÆÈ¹Ø±ÕÁËÒ»¸öÏÖÓеÄÁ¬½Ó¡£´íÎó: 10054
ÇëÎÊÔõô½â¾ö£¿
·ÖÎöÔ­Òò£º
1.Öв¡¶¾ÁË¡£Çë²é¿´ÏµÍ³Ä¿Â¼ÊÇ·ñ´æÔÚÒ»¸öC:\WINDOWS\Media£¬Àï±ßÊÇ·ñÓÐClick.exe Svchost.exeºÍCsrss.exe¡£¶ÔÁË£¬¾ÍÊÇÕâ¸öÎļþÔÚ¸ã¹í£¬Í¬Ê±ÄãÒ²»áÔÚ×¢²á±íÀïÕÒµ½Õâ¸öÎļþÏàÓ¦µÄµ÷ÓÃÏî¡£
2.×¢²á±íÖеÄ:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Winsock

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Winsock2

ÖÐÓдíÎó,

±¸·ÝºóÕÒһ̨ÏàͬµÄ»úÆ÷µÄ×¢²á±í·ÖÖ§

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Winsock

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Winsock2

µ¼Èë¼´¿É¡£

3. ¾­³£³öÏÖµÄConnection reset by peer: Ô­Òò¿ÉÄÜÊÇ¶à·½ÃæµÄ£¬²»¹ý¸ü³£¼ûµÄÔ­ÒòÊÇ£º¢Ù£º·þÎñÆ÷µÄ²¢·¢Á¬½ÓÊý³¬¹ýÁËÆä³ÐÔØÁ¿£¬·þÎñÆ÷»á½«ÆäÖÐһЩÁ¬½ÓDownµô£»¢Ú£º¿Í»§¹ØµôÁËä¯ÀÀÆ÷£¬¶ø·þÎñÆ÷»¹ÔÚ¸ø¿Í»§¶Ë·¢ËÍÊý¾Ý£»¢Û£ºä¯ÀÀÆ÷¶Ë°´ÁËStop Á¬½Ó±»·À»ðéÉ»òproxyÖжÏ"»òÒòΪÄúÓа²×°ip·ÖÏíÆ÷Ç뽫ip·ÖÏíÆ÷ÏÈÄõô£¬Ö±½Ó½«¼ÆËã»ú½ÓadslµÄÏßÂ·ÖØÆôºóÖØÐÂÉÏ´«¡£

¶àÁ¬¼¸´ÎÒ²ÊÇÕâÑù£¿

ÒýÓÃ
·ÖÎöÔ­Òò£º
1.Öв¡¶¾ÁË¡£Çë²é¿´ÏµÍ³Ä¿Â¼ÊÇ·ñ´æÔÚÒ»¸öC:\WINDOWS\Media£¬Àï±ßÊÇ·ñÓÐClick.exe Svchost.exeºÍCsrss.exe¡£¶ÔÁË£¬¾ÍÊÇÕâ¸öÎļþÔÚ¸ã¹í£¬Í¬Ê±ÄãÒ²»áÔÚ×¢²á±íÀïÕÒµ½Õâ¸öÎļþÏàÓ¦µÄµ÷ÓÃÏî¡£
2.×¢²á±íÖеÄ:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Winsock

HKEY_LO


Ïà¹ØÎÊ´ð£º

sqlserverÈ«ÎÄË÷ÒýµÄÔ­Àí

ÎÒ¿´Á˺ܶàÎÄÕ£¬Ð´µÄ̫רҵ£¬Äܲ»ÄÜÓôó°×»°½²½²£¬¾ÍÊÇÔõô¹¹½¨Ë÷ÒýµÄ£¬²éµÄʱºòÊÇÔõôÑùµÄ²½Ö裬Ϊʲô±Èlike¿ì£¬ÊDz»ÊÇÖ»ÒªÓÃcontect£¬¾ÍÒ»¶¨»áÈ¥²é£¬±ÈÈç
select * from table where contect('sdfsd',sdf) and ......

½ô¼±ÇóÖúsqlserver Êý¾Ý¿â±»ÅúÁ¿²åÈë´úÂë

ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë
Ôõô»ØÊ¡£
´úÂëÒѾ­Ð´Á˹ýÂË×Ö·û´®
Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË

Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË

»¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½
Ôõôà ......

Ôõô²ÅÄÜÈÃc#³ÌÐòÍÑÀësqlServerÒ²ÄÜ·ÃÎÊÊý¾Ý¿â£¿


ÈçÌâ
±¾È˲ËÄñ
²»ÊÇÓÃsql×öµÄÊý¾Ý¿âÈí¼þ µÄʹÓûúÆ÷ÉÏ ¶¼µÃ°²×° sqlServer°É¡£¡£..
ÎÒ¿´µ½ÓÐЩÈí¼þ µã¿ªÈí¼þ Êý¾Ý¿â¾ÍÒѾ­µ¼Èë½øÈ¥ÁË ¸ùĿ¼ֻÓиömdb
ÇëÎʸßÊÖÃÇÓûùÓÚsqlµÄ c#³ÌÐò Ôõô×ö³ÉÄÇÑù ......

sqlserver ÈçºÎÏÔʾ³ö<Long Text>ÀïµÄÊý¾Ý?

ÈçºÎÏÔʾ³ö <Long Text>ÀïµÄÊý¾Ý?


ÎÒÏëÎÊÄãÒ»ÏÂÔÚsqlÆóÒµ¹ÜÀíÆ÷Àï·µ»ØµÄ¼Ç¼ÖÐÈç¹û½« <Long Text>ÀïµÄÊý¾ÝÏÔʾ³öÀ´?


ÓÃÕâÖֵķ½Ê½¿ÉÒÔ¿´µ½ SELECT CONVERT(VARCHAR(5000),LONGTEX ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ