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
Ïà¹ØÎÊ´ð£º
ÎÒ¿´Á˺ܶàÎÄÕ£¬Ð´µÄ̫רҵ£¬Äܲ»ÄÜÓôó°×»°½²½²£¬¾ÍÊÇÔõô¹¹½¨Ë÷ÒýµÄ£¬²éµÄʱºòÊÇÔõôÑùµÄ²½Ö裬Ϊʲô±Èlike¿ì£¬ÊDz»ÊÇÖ»ÒªÓÃcontect£¬¾ÍÒ»¶¨»áÈ¥²é£¬±ÈÈç select * from table where contect('sdfsd',sdf) and ......
ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë Ôõô»ØÊ¡£ ´úÂëÒѾдÁ˹ýÂË×Ö·û´® Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË »¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½ Ôõôà ......
ÈçÌâ ±¾È˲ËÄñ ²»ÊÇÓÃsql×öµÄÊý¾Ý¿âÈí¼þ µÄʹÓûúÆ÷ÉÏ ¶¼µÃ°²×° sqlServer°É¡£¡£.. ÎÒ¿´µ½ÓÐЩÈí¼þ µã¿ªÈí¼þ Êý¾Ý¿â¾ÍÒѾµ¼Èë½øÈ¥ÁË ¸ùĿ¼ֻÓиömdb ÇëÎʸßÊÖÃÇÓûùÓÚsqlµÄ c#³ÌÐò Ôõô×ö³ÉÄÇÑù ......
ÈçºÎÏÔʾ³ö <Long Text>ÀïµÄÊý¾Ý? ÎÒÏëÎÊÄãÒ»ÏÂÔÚsqlÆóÒµ¹ÜÀíÆ÷Àï·µ»ØµÄ¼Ç¼ÖÐÈç¹û½« <Long Text>ÀïµÄÊý¾ÝÏÔʾ³öÀ´? ÓÃÕâÖֵķ½Ê½¿ÉÒÔ¿´µ½ SELECT CONVERT(VARCHAR(5000),LONGTEX ......