JTDSÁ¬½ÓSQL Server Óöµ½µÄÎÊÌâ
½ñÌìÔÚÓÃJTDSÁ¬½ÓSQL Server ʱºò£¬Óöµ½¼¸¸öÎÊÌ⣬¼Ç¼ÈçÏ£º
error while performing database login with the jtds driver:
network error ioexception:connection refused: connect
È»ºó²é¿´¶Ë¿Ú£¬ÔÀ´ÊÇ1433¶Ë¿Úδ´ò¿ª£¬È»ºóÔÚSQL Server configuration ManagerϵÄTCP\IPÖÐÆôÓÃ1433¶Ë¿Ú£¬ÖØÆôSQL Server·þÎñ£¬netstat -a -n ²é¿´¶Ë¿Ú£¬1433´ËʱÒѾ´ò¿ª¡£
ÔٴΓtest driver”½á¹ûÓÖ³öÏÖÎÊÌ⣺
±¾ÈËÏë³¢ÊÔ¿ªÆôSQL Server µÄVIA£¬½á¹ûÖØÆôSQL Serverʱ£¬²»ÄÜÕý³£Æô¶¯~£¡
֮ǰͨ¹ýjdbcÁ¬½Ó³É¹¦¹ý£¬ÏÖÔÚÊÔһϣ¬½á¹û£º
½â¾ö°ì·¨£º
1. ÏȽ«VIA½ûÓã¬È»ºó´ò¿ªSQL Server Configuration Manager->MSSQL ServerµÄÐÒé
->TCP/IP->IPµØÖ·
2. ²é¿´Á¬¸öIPµØÖ·ºÍ¶Ë¿Ú£¬¾¹ýÉÏÊöµÄ´íÎó£¬Ó¦¸Ã¶Ë¿ÚÉèÖÃûÓÐÎÊÌâµÄ£¬Îª1433£¬µ«ÊÇÎÊ
Ìâ¾Í³öÔÚÁ½¸öIPµØÖ·ÉÏ£¬¼ì²éʱºòÆôÓÃÁËIPµØÖ·£¬²¢ÇÒÖ»¿ÉÒÔÆôÓÃÒ»¸öŶ£¬²»È»¾Í»á³öÏÖ
windows socket errorµÄ´íÎ󣬯ôÓÃÒ»¸öÖ®ºóÖØÆôÒ»ÏÂSQL Server·þÎñ£¬JTDSºÍJDBCÁ¬
½Ó¶¼Õý³£~£¡À§ÈÅÒ»ÍíµÄÎÊÌâ½â¾ö~£¡
Ïà¹ØÎĵµ£º
º¯Êý¼ò½é:¡¡¡¡
·µ»Ø Variant (Long) µÄÖµ£¬±íʾÁ½¸öÖ¸¶¨ÈÕÆÚ¼äµÄʱ¼ä¼ä¸ôÊýÄ¿¡£
º¯ÊýÓï·¨:
¡¡¡¡DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])
DateDiff º¯ÊýÓï·¨ÖÐÓÐÏÂÁÐÃüÃû²ÎÊý£º
¡¡¡¡interval ±ØÒª¡£×Ö·û´®±í´ïʽ£¬±íʾÓÃÀ´¼ÆËãdate1 ºÍ date2 µÄʱ¼ä²îµÄʱ¼ä¼ ......
ÓÉÓÚÍøÕ¾ÊDZðÈ˵Ä
sql server 2000 ²»Äܵ¼Èë2005 µÄÊý¾Ý¿âÎļþ ÎÒÖ»ºÃ°´ÕÕÊéÉÏÖØÐ½¨Á¢µÄÊý¾Ý¿âÎļþ
È»ºóÔÚvisual studio 2005ÖÐÒ»¸öÒ»¸öµÄ¸´ÖÆ´æ´¢¹ý³Ìµ½sql server 2000
ÕâÑù¾Í²»ÓÃÏÂÔØ sql server 2005 ÁË
Èç¹ûÓÐsql server 2005 µÄ»°Ö®¼ÊÉú³É ½Å±¾¾ÍÒ»ÖÂÐÔµ¼Èë¾ÍokÁË ......
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Configuration;
using System.Data.SqlClient;
namespace WebApplication1
{
public class Message
{
public static IL ......
SQL Server 2008 ¸´ÖÆ ·ÖÇøSWITCHÇåÀíÊý¾Ý
³¡¾°£º
ijÖÖÌØ¶¨ÒµÎñÏ£¬ÎÒÃǵIJ¿·ÖÒµÎñÊý¾Ý¿ÉÄÜÖ»»á±£Áô±È½Ï¶ÌµÄʱ¼ä£¬ÓÃÀ´×öÁÙʱ´¦Àí¡£ÒòΪ¿¼ÂǸ߿ÉÓõÄÌØÐÔ£¬¿ÉÄÜ»áÀûÓÃ
SQL ServerµÄ¸´ÖÆ×é¼þ¸´ÖÆÕâÖÖÊý¾Ýµ½ÁíÍâµÄ ÀàËÆÇ°¶Ë£¬²éѯÖÐÐĵÈÊý¾Ý¿â·þÎñÆ÷£¬´´½¨Ò»¸öÈßÓั±¾¡£¸´ÖÆ×é¼þ±ê¼ÇÊÂÎñÈÕÖ¾£¬×·×ÙËùÓеÄUpdate£¬In ......
1½«sqlÖÐʹÓõÄÒ»Ð©ÌØÊâ·ûºÅ£¬Èç' -- /* ; %µÈÓÃReplace()¹ýÂË£»
2ÏÞÖÆÎı¾¿òÊäÈë×Ö·ûµÄ³¤¶È£»
3¼ì²éÓû§ÊäÈëµÄºÏ·¨ÐÔ£»¿Í»§¶ËÓë·þÎñÆ÷¶Ë¶¼ÒªÖ´ÐУ¬¿ÉÒÔʹÓÃÕýÔò¡£
4ʹÓôø²ÎÊýµÄSQLÓï¾äÐÎʽ¡£
ASP.NETÖÐÈçºÎ·À·¶SQL×¢Èëʽ¹¥»÷
Ò»¡¢Ê²Ã´ÊÇSQL×¢Èëʽ¹¥»÷£¿
¡¡¡¡ËùνSQL×¢Èëʽ¹¥»÷£¬¾ÍÊǹ¥»÷Õß°Ñ ......