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

̸JDBC SQLSERVER"Error establishing socket"

 
jdbcÅäÖÃÓï¾äΪ: jdbc:microsoft:sqlserver://server_name:1433
ÈçÔËÐгÌÐòʱ³öÏÖ "Error establishing socket" ´íÎó,ÔòÓ¦½øÐÐÈçϵ÷ÊÔ:
1 ¼ì²éSQL SERVER ÊÇ·ñÔÊÐíÔ¶³Ì·ÃÎÊ.¾ßÌå²½Öè:
1)´ò¿ª"ÆóÒµ¹ÜÀíÆ÷",´ò¿ª¿ØÖÆÌ¨¸ùĿ¼>SQL Server ×é>Êý¾Ý¿â
2)ÔÚÏàÓ¦"Êý¾Ý¿â"Éϵ¥»÷ÓÒ¼ü,Ñ¡Ôñ"ÊôÐÔ"
3)Ñ¡Ôñ"Á¬½Ó"Ñ¡Ï,¼ì²é"Ô¶³Ì·þÎñÆ÷Á¬½Ó"ÏÂ,RPC·þÎñÊÇ·ñÑ¡Ôñ.
2 ʹÓÃtelnet IPµØÖ· 1433,ϵͳÊÇ·ñÌáʾÁ¬½Ó³ö´í,ÈçϵͳÌáʾ³ö´í
¼ì²éÊÇ·ñ·À»ðǽÆÁ±ÎÁËSQL SERVER »ò java IDE µÄÍøÂç·ÃÎʶ˿Ú
Èç¹ûÊÇ,¹Ø±Õ·À»ðǽ,ÖØÐÂÆô¶¯SQL SERVERºÍjava IDE,½øÐвâÊÔ,
Èç¹ûϵͳÈÔÌáʾÉÏÊö´íÎó,³¢ÊÔÏÂÁв½Öè
3 ¼ì²éSQL SERVER ¶Ë¿ÚºÅ¼°ÊÇ·ñÆôÓÃÁËTCP/IPЭÒé,¾ßÌå²½Öè:
1)´ò¿ª"ÆóÒµ¹ÜÀíÆ÷",´ò¿ª¿ØÖÆÌ¨¸ùĿ¼>SQL Server ×é>Êý¾Ý¿â
2)ÔÚÏàÓ¦"Êý¾Ý¿â"Éϵ¥»÷ÓÒ¼ü,Ñ¡Ôñ"ÊôÐÔ"
3)Ñ¡Ôñ"³£¹æ"Ñ¡Ï,µã»÷"ÍøÂçÅäÖÃ",ÈçÆôÓõÄЭÒéÖÐÎÞ"TCP/IPЭÒé"½«Æä¼ÓÈë
4)Ñ¡Ôñ"TCP/IPЭÒé",µã»÷"ÊôÐÔ",¼ì²éÆä¶Ë¿ÚºÅÊÇ·ñΪ1433
5)Èç¶Ë¿ÚºÅΪ1433½«ÆäÐÞ¸ÄΪÆäËü¶Ë¿ÚºÅ,ÐÞ¸ÄjdbcÁ¬½ÓÓï¾ä,½«¶Ë¿ÚºÅͬÑù¸ÄΪÐÂÆôÓõĶ˿ںÅ,Èçjdbc:microsoft:sqlserver://server_name:1400(¼ÙÉèж˿ںÅΪ 1400)
 
ÒÔÏµķ½·¨ÄãÿÖÖµÄÈ¥ÊÔÊÔ:
¼ì²éÒ»ÏÂsql serverµÄconnectionÓÐûÓÐfull.
Èç¹ûÊÇÈÏÖ¤µÄÎÊÌâ.
¿Éµ½sql enterprice manager->Ö¸¶¨server->ÄÚÈÝ->°²È«ÐÔ.
°ÑÑéÖ¤¸ÄΪ SQL server ¼° windows.
µãÑ¡ÊôÐÔ¼ì²éÒ»ÏÂportÊÇ·ñÕýÈ·.
Ö´ÐÐ%MSSQL_HOME%\80\Tools\Binn\SVRNETCN.exe
°ÑTCP/IPÆôÓÃ.
¹Øµô·À»ðǽ.
°ÑSQL server updateµ½sp3:
http://www.microsoft.com/sql/downloads/2000/sp3.asp
¾­ÑéÖ¤£¬Ò»°ãÉý¼¶µ½sp3¾ÍºÃÓÃÁË£¡


Ïà¹ØÎĵµ£º

SqlServer´óÅúÁ¿µ¼Èëµ¼³öÊý¾Ý

BULK INSERT
¡¡¡¡ÔÚSQL ServerÖУ¬BULK INSERTÊÇÓÃÀ´½«ÍⲿÎļþÒÔÒ»ÖÖÌØ¶¨µÄ¸ñʽ¼ÓÔØµ½Êý¾Ý¿â±íµÄT-SQLÃüÁî¡£¸ÃÃüÁîʹ¿ª·¢ÈËÔ±Äܹ»Ö±½Ó½«Êý¾Ý¼ÓÔØµ½Êý¾Ý¿â±íÖУ¬¶ø²»ÐèҪʹÓÃÀàËÆÓÚIntegration ServicesÕâÑùµÄÍⲿ³ÌÐò¡£ËäÈ»BULK INSERT²»ÔÊÐí°üº¬Èκθ´ÔÓµÄÂß¼­»òת»»£¬µ«Äܹ»ÌṩÓë¸ñʽ»¯Ïà¹Øµ ......

JAVA SQLSERVERÊý¾Ý¿âÁ¬½Ó

 package cn.ctgu.edu.ac;
import java.sql.*;
public class test {
 /**
  * @param args
  */
 public static void main(String[] args) {
  // TODO Auto-generated method stub
  String url="jdbc:sqlserver://localhost:1433;Database=ÍøÉÏÊéµê¹ÜÀíϵͳ;integr ......

SQLserverÖÐÓÃconvertº¯Êýת»»ÈÕÆÚ¸ñʽ

¡¾ÎÊÌâÃèÊö£º¡¿
      Ò»¸öÓû§±íÖеÄ×¢²áÈÕÆÚÏÔʾ¸ñʽÊÇ£ºyyyy-mm-dd Thh:mm:ss.mmm ¡£¶øÎÒÏëͳ¼Æ³öÿÌìµÄÓû§×¢²áÊý£¬Ö±½Ógroup×¢²áÈÕÆÚ×Ö¶ÎÏÔÈ»ÊDz»Ðеġ£
¡¾ÎÊÌâ´¦Àí£º¡¿
      ÀûÓÃSQLserverÖеÄconvertº¯Êý¶ÔÈÕÆÚ½øÐÐת»»×ª»»¡£groupת»»ºóµÄÈÕÆÚ¡£
¡¾½Å  ......

SQLServer 2008¿çÊý¾Ý¿âʵÀýÊÂÎñ´¦Àí

 ÍÐÁ˼¸ÌìµÄÄÑÌ⣬ÖÕÓÚ½â¾öÁË¡£ÌØ·ÖÏíÒ»ÏÂ
ÒÔÏÂÊÇÒ»¸ö´æ´¢¹ý³Ì
CREATE PROCEDURE deleteAccountAll
 @id int
AS
SET XACT_abort ON
BEGIN DISTRIBUTED TRAN
delete from AccountCapital where accountid = @id
delete from logininfo where username = @id
delete from CapitalRecord where accountid ......

sqlserver ´æ´¢¹ý³ÌÀý×Ó

 Ê²Ã´ÊÇ´æ´¢¹ý³ÌÄØ£¿
¡¡¡¡¶¨Ò壺
¡¡¡¡½«³£ÓõĻòºÜ¸´ÔӵŤ×÷£¬Ô¤ÏÈÓÃSQLÓï¾äдºÃ²¢ÓÃÒ»¸öÖ¸¶¨µÄÃû³Æ´æ´¢ÆðÀ´, ÄÇôÒÔºóÒª½ÐÊý¾Ý¿âÌṩÓëÒѶ¨ÒåºÃµÄ´æ´¢¹ý³ÌµÄ¹¦ÄÜÏàͬµÄ·þÎñʱ,Ö»Ðèµ÷ÓÃexecute,¼´¿É×Ô¶¯Íê³ÉÃüÁî¡£
¡¡¡¡½²µ½ÕâÀï,¿ÉÄÜÓÐÈËÒªÎÊ£ºÕâô˵´æ´¢¹ý³Ì¾ÍÊÇÒ»¶ÑSQLÓï¾ä¶øÒѰ¡£¿
¡¡¡¡Microsoft¹«Ë¾ÎªÊ²Ã´»¹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ