Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 2005)

´æ´¢¹ý³ÌµÄ´´½¨¼°Ê¹ÓÃ(sqlserver 2005)
´´½¨´æ´¢¹ý³Ì¡£´æ´¢¹ý³ÌÊÇÒѱ£´æµÄ Transact-SQL Óï¾ä¼¯ºÏ£¬»ò¶Ô Microsoft .NET Framework ¹«¹²ÓïÑÔÔËÐÐʱ (CLR) ·½·¨µÄÒýÓ㬿ɽÓÊÕ²¢·µ»ØÓû§ÌṩµÄ²ÎÊý¡£¿ÉÒÔ´´½¨¹ý³Ì¹©ÓÀ¾ÃʹÓ㬻òÔÚÒ»¸ö»á»°£¨¾Ö²¿ÁÙʱ¹ý³Ì£©ÖÐÁÙʱʹÓ㬻òÔÚËùÓлỰ£¨È«¾ÖÁÙʱ¹ý³Ì£©ÖÐÁÙʱʹÓá£
Æô¶¯ SQL ......

ÓÃSQLÓï¾äµÃµ½SQLServer µÄ±íÖеÄÁеÄÃèÊöÖµ

 select   case   when   c.colid=1   then   object_name(c.id)   else   ''   end   as   ±íÃû    
  ,c.name   as   ×Ö¶ÎÃû  
  ,t.name   Êý¾ÝÀàÐÍ  
  ,c.prec   as   ³¤¶È   ......

ʹÓÃSqlserverÊÂÎñ·¢²¼ÊµÏÖÊý¾Ýͬ²½

      ÊÂÎñµÄ¹¦ÄÜÔÚsqlserverÖÐÓÉÀ´ÒѾã¬ÒòΪ×î½üÔÚ×öÒ»¸öÊý¾Ýͬ²½·½°¸£¬ËùÒÔÓлú»áÔÙ´ÎÑо¿Ò»ÏÂËüÒÔ¼°¿ìÕյȣ¬·¢ÏÖ»¹ÊÇÓкܶ಻´íµÄ¹¦Äܺ͸ĽøµÄ¡£ÕâÀïÒÔsqlserver2008µÄÊÂÎñ·¢²¼¹¦ÄÜΪÀý£¬¶Ô·¢²¼¶©Ôĵķ½Ê½¼òÒª½éÉÜһϲÙ×÷Á÷³Ì£¬Ò»·½Ãæ×ö¸ö×ܽᱸ·Ý£¬Ò»·½ÃæÓë´ó¼Ò½øÐÐһϷÖÏíºÍ½»Á÷¡£·Ñ»°¾Í² ......

sqlserver°²×°ÎÊÌâ×ܽᣨSqlServer2000/2005)

 SQL Server 2000
Installing SQL Server 2000 (EÎÄ)
http://msdn.microsoft.com/en-us/library/aa299042(SQL.80).aspx
SQL Server 2000²¹¶¡
Microsoft SQL Server 2000 Service Pack 3a
http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=90DCD52C-0488-4E46-AFBF-ACACE536 ......

SQLServer Óαê¼ò½éÓëʹÓÃ˵Ã÷

 Óα꣨Cursor£©ÊÇ´¦ÀíÊý¾ÝµÄÒ»ÖÖ·½·¨£¬ÎªÁ˲鿴»òÕß´¦Àí½á¹û¼¯ÖеÄÊý¾Ý£¬ÓαêÌṩÁËÔÚ½á¹û¼¯ÖÐÒ»´ÎÒÔÐлòÕß¶àÐÐǰ½ø»òÏòºóä¯ÀÀÊý¾ÝµÄÄÜÁ¦¡£ÎÒÃÇ¿ÉÒÔ°ÑÓα굱×÷Ò»¸öÖ¸Õ룬Ëü¿ÉÒÔÖ¸¶¨½á¹ûÖеÄÈκÎλÖã¬È»ºóÔÊÐíÓû§¶ÔÖ¸¶¨Î»ÖõÄÊý¾Ý½øÐд¦Àí¡£
      1.ÓαêµÄ×é³É
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ