Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¶Ôij¸ö±í²Ù×÷¼Ó¸öÓû§

sqlserver,Èç¹û¼Ó¸öÓû§,ȨÏÞÊǶÁËùÓÐ±í£¬µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ
ûÕâ¸ö˵·¨.

Ö»¸øSELECT ,

UPDATEµÄÖ»¸øÄ³Ð©±í

¸ö²»»á

µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ Õâ¸öÄѸã

Òª¼ÓȨÏÞµÃÕë¶Ôij¸öÊý¾Ý¿â
......

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

ÈçºÎ·ÀֹͬʱÏòSQLSERVERдÈëÊý¾Ý

Çë½Ì¸÷λ£º
ÔÚ³¬ÊеÄÊÕÒøÏµÍ³ÖУ¬Èç¹ûÓÐ20¶à¸ö¿Í»§¶Ë£¬ÓпÉÄÜͬʱ¶Ôij×Ö¶ÎÊý¾Ý½øÐÐÐ޸쬻ò½øÐÐɾ³ý£¬¾ÍÓпÉÄܾͻáÔì³ÉijЩ¿Í»§¶Ë³öÏÖ´íÎó£¬Ó¦¸ÃÈçºÎÈ¥±ÜÃâÄØ£¿ÄÜ·ñÌṩ¾ßÌåÊÂÀý£¬Ð»Ð»

Ôõô»áͬʱÐÞ¸ÄÄØ£¿ ......

vc sqlserverÓ¦ÓóÌÐòµÄ´ò°üÎÊÌâ

¶Ô»°¿òÓõ½ÁËdatagrid¿Ø¼þºÍado data control¿Ø¼þ£¬ÓÃinstallshield¶Ô³ÌÐò´ò°üºó£¬¿½±´µ½±ðµÄ»úÆ÷ÉÏÔËÐУ¬datagrid¿ÉÒÔÏÔʾ£¬Ìí¼ÓÊý¾Ýºó£¬datagrid²»Ë¢Ð£¬µ«ÊÇÊý¾Ý¿âÖÐÒѾ­ÓÐÁËÌí¼ÓµÄÊý¾ÝÁË¡£ÇëÎÊÊÇʲôÎÊÌ⣿ÊDz»Ê ......

JDBCÎÞ·¨Á¬½ÓSQLServerÊý¾Ý¿âΪʲô£¨¼±£©£¿

ÎÒÒѾ­µ¼ÈëÁËÇý¶¯°ü£¬Á¬½Ó×Ö·û´®Ã»ÓÐ´í£¬ÃÜÂëºÍÓû§Ãû¶¼ÕýÈ·£¬
¿ÉÊÇÓÃJDBCÁ¬½ÓSQLServerµÄʱºò£¬×ÜÊÇÌáʾ£ºError establishing socket£¡
Çë¸ßÊÖÖ¸½ÌÕâÊÇʲôÎÊÌâ°¡£¡
Â¥Ö÷¿´Õ⣺http://www.blogjava.net/lpet ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ