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

JDBCÁ¬½ÓSQLserverÎÊÌâ ÓôÃÆ~

ÓÖ³öÏÖ£ºcom.microsoft.sqlserver.jdbc.SQLServerException: ûÓÐΪ¼¯³ÉÉí·ÝÑéÖ¤ÅäÖÃÇý¶¯³ÌÐò¡£Õâ¸ö´íÁË ÉÏ´ÎÏ¡ÀïºýÍ¿µÄ¸øÅª³öÀ´ÁË £¬Õâ´ÎŪÁ˰ëÌ춼ûÆ×£¬Õâµ½µ×ÊÇɶԭÒò£¡
×Ô¼ºÏȶ¥Ò»¸ö

ÊDz»ÊÇû´òsp3 ²¹¶¡°¡

ÒýÓÃ
ÊDz»ÊÇû´òsp3 ²¹¶¡°¡

.

ÊÇûÓÐSQLserverÇý¶¯³ÌÐòÂð

ÏÂÔØ£ºSQL Server 2000 SP3£¬Í¬Ñùµ½MicrosoftµÄÍøÕ¾È¥ÏÂÔØÉý¼¶°ühttp://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=zh-cn£¬ÏÂÔØÆäÖеÄchs_sql2ksp3.exe£¬×¢ÒâÏÂÔØÏÂÀ´µÄÊÇchs_sql2ksp3.exeÎļþ,Ë«»÷ËüÑ¡Ôñ°²×°µ½Ò»¸öĿ¼ʱÊÇÔÚ½âѹ,È»ºóÄ㻹Ҫµ½ÄǸöĿ¼ÏÂË«»÷setup.batÅú´¦ÀíÎļþ²ÅÊÇ¿ªÊ¼°²×°(Ó¦¸Ã˵ÊÇÉý¼¶)!!!¾ßÌåÏÂÔØµØÖ·ÊÇ£ºhttp://download.microsoft.com/download/d/d/e/dde427eb-0296-4eac-a47c-d11a66b03816/chs_sql2kasp3.exe
~~~~~~~~~~~~~~~~~~~~¹Ø¼ü½áÊø~~~~~~~~~~~~~~~~~~~~~~~~~×¢£ºÎÒÒ»Ö±ÊÇÕâ¸öÔ­Òò£¬×°´í²¹¶©ÁË£¬ÎÒÔø¾­×°¹ýSP3a£¬SP4£¬½á¹û¶¼²»ÐУ¡2£¬°²×°JDBC£¬°ÑÆä°²×°Ä¿Â¼ÏµÄlibϵÄÈý¸öÎļþÌí¼Óµ½classpathÖУ¬Õâ¸öÍøÉ϶¼ÓкܶࡣÎÒµÄÊÇ£ºC:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;Ìí¼ÓÍê³Éºó£¬°²×°SP3²¹¶©£¬Ò²¾ÍÊǸղÅϵÄÄǸöÎļþ£¬

ûµ¼Çý¶¯°ü°É£¿ÔÚWEB-INFµÄlibÅäÖù¹½¨Â·¾¶µ¼Èësqljdbc.jar°üÊÔÊÔ

ûÓÐsqlserverµÄjdbcÇý¶¯°ü

1,Êý¾Ý¿âÇý¶¯Ã»µ¼Èë
2,²¹¶¡Ã»´ò


Òª²»¾ÍÊÇȱÉÙ°ü£¬Òª


Ïà¹ØÎÊ´ð£º

sqlserver¶Ôij¸ö±í²Ù×÷¼Ó¸öÓû§

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

Ö»¸øSELECT ,

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

¸ö²»»á

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

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

SwingÀïÃæµÄʼþÓëSQLserverÊý¾Ý¿âµÄÁ¬½ÓµÄÎÊÌâ

СµÜÏÖÔÚSwingÔÚÁ¬½ÓÊý¾Ý¿âÉÏÓöµ½Ò»µãÎÊÌ⣬ÇëÎÊSwingÀïÃæµÄʼþºÍSQLserverÊý¾Ý¿âµÄÁ¬½ÓÓÐʲôºÃµÄ×ÊÁÏÊéÍÆ¼öÂð£¿
Õâ¸öÓ¦µ±Ã»ÓÐÊ²Ã´ÌØ±ð,ÓëÆäËûµÄ±à³ÌÒ»Ñù.

JDBC

ÇëÎÊÔÚSwingÖмÓÔØ±³¾°Í¼Æ¬ÊÇÔõô¼ÓµÄ£¿
......

ÈçºÎÉèÖÃSqlserverÊý¾Ý¿âÈÕÖ¾Ôö³¤·½Ê½

ÈçÌâ¡£
ÎÒÏ붨ÆÚÖ´ÐгÌÐò£¬É¾³ý²»ÓõÄÊý¾Ý£¬ÊÕËõÒ»ÏÂÊý¾Ý¿â£¬Æ½Ê±Ê¹ÓõÄʱºò£¬ÈÕÖ¾×î´óÎļþ´óСΪÏÞÖÆ200MB£¬
µ«ÊÇÊÕËõµÄʱºò£¬»á²úÉú´óÁ¿ÈÕÖ¾£¬Èç¹û³¬¹ýÏÞÖÆ£¬ÔòÊÕËõÊý¾Ý¿âʱ»áʧ°Ü£¬ÎÒÏë¸ÄΪ×î´óÎļþ´óС²»Ê ......

½ô¼±ÇóÖúsqlserver Êý¾Ý¿â±»ÅúÁ¿²åÈë´úÂë

ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë
Ôõô»ØÊ¡£
´úÂëÒѾ­Ð´Á˹ýÂË×Ö·û´®
Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË

Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË

»¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½
Ôõôà ......

sqlserver 2008²»ÄÜÔ¶³ÌµÇ¼£¬Çë°ïæ

°²×°ÁËsql server 2008ÆóÒµ°æ£¬²Ù×÷ϵͳΪwindows server 2008 X64£¬°²×°Íê³Ésql server 2008ºó£¬»¹×°ÁËvs2008£¬È»ºó´òÁËvs2008ºÍsql server 2008µÄSP1¡£
°²×°ºó£¬Á¬½ÓÊý¾Ý¿âʱ£¬Èç¹ûÖ¸¶¨·þÎñÆ÷Ãû³ÆÎª¡°.\MSSQLSE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ