win7 Ï ÅäÖà SQL Server 2005 ÔÊÐíÔ¶³Ì·ÃÎÊ
win7 Ï ÅäÖà SQL Server 2005 ÔÊÐíÔ¶³Ì·ÃÎÊ
2010Äê2ÔÂ2ÈÕ bibiQ
±¾À´Ò»Ö±²»Ô¸ÒâÅäÖÃÔ¶³Ì·ÃÎÊSQL server£¬µ«½ñÌìÒ»ºÝÐÄ°ÑËüÅäºÃÁË¡£
²Î¿¼ÁËÍøÉϵÄÌû×Óhttp://www.cnblogs.com/sukiwqy/archive/2009/11/11/1601381.html
step1£º ÅäÖÃSQL Server ÍâΧӦÓÃÅäÖÃÆ÷£¨Îª SQL Server 2005 ÆôÓÃÔ¶³ÌÁ¬½Ó¡¢ÆôÓà SQL Server Browser ·þÎñ£©
1. µ¥»÷”¿ªÊ¼”£¬ÒÀ´ÎÑ¡Ôñ”ËùÓгÌÐò”¡¢”Microsoft SQL Server 2005″¡¢”ÅäÖù¤¾ß”£¬È»ºóµ¥»÷”SQL Server ÍâΧӦÓÃÅäÖÃÆ÷”¡£
2. ÔÚ”SQL Server ÍâΧӦÓÃÅäÖÃÆ÷”Ò³ÉÏ£¬µ¥»÷”·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”¡£
3. ÔÚ”·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”Ò³ÉÏ£¬Õ¹¿ª”Database Engine”(Êý¾Ý¿âÒýÇæ)£¬µ¥»÷”Ô¶³ÌÁ¬½Ó£¬Ñ¡Ôñ”±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½Ó”¸´Ñ¡¿ò£¬Ñ¡ÔñÊÊÓÃÓÚÄúµÄ»·¾³µÄÏàÓ¦ÐÒé(ÎÒÕâÀïʹÓÃͬʱʹÓÃTCP/IPºÍnamed pipes)£¬È»ºóµ¥»÷”Ó¦ÓÔ¡£
×¢Òâ:ÇëÔÚ½ÓÊÕµ½ÒÔÏÂÏûϢʱµ¥»÷“È·¶¨”¡£
Ö±µ½ÖØÐÂÆô¶¯Êý¾Ý¿âÒýÇæ·þÎñºó£¬¶ÔÁ¬½ÓÉèÖÃËù×öµÄ¸ü¸Ä²Å»áÉúЧ¡£
4. ÔÚ”·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”Ò³ÉÏ£¬µ¥»÷”SQL Server Browser”£¬ÔÚ”Æô¶¯ÀàÐÍ”Öе¥»÷”×Ô¶¯”Ñ¡ÏȻºóµ¥»÷”Ó¦ÓÔ¡£
5. µ¥»÷”Æô¶¯”£¬È»ºóµ¥»÷”È·¶¨”¡£
step2£º¸ü¸Äwindows·À»ðǽÉèÖã¨ÔÚ Windows ·À»ðǽÖÐΪ SQL Server 2005 ºÍSQL Server Browser´´½¨ÀýÍ⣩
1. ÔÚ Windows ·À»ðǽÖУ¬µ¥»÷”ÔÊÐí³ÌÐò»ò¹¦ÄÜͨ¹ýwindows·À»ðǽ”£¬È»ºóµ¥»÷”ÔÊÐíÔËÐÐÁíÒ»³ÌÐò£¨R£©”¡£
2. ÔÚ”Ìí¼Ó³ÌÐò”´°¿ÚÖУ¬µ¥»÷”ä¯ÀÀ”¡£
3. µ¥»÷ C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe ¿ÉÖ´ÐгÌÐò£¬µ¥»÷”´ò¿ª”£¬È»ºóµ¥»÷”È·¶¨”¡£
×¢Òâ:ÉÏÊö·¾¶¿ÉÄÜ»á¸ù¾Ý SQL Server 2005 µÄ°²×°Î»Ööø²»Í¬¡£
4. µ¥»÷ C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe ¿ÉÖ´ÐгÌÐò£¬µ¥»÷”´ò¿ª”£¬È»ºóµ¥»÷”È·¶¨”¡£
×¢Òâ:ÉÏÊö·¾¶¿ÉÄÜ»á¸ù¾Ý SQL Server 2005 µÄ°²×°Î»Ööø²»Í¬¡£
step3£ºÅäÖÃÔ¶³ÌÁ¬½ÓµÄTCP¶Ë¿Ú1433
1. ÔÚ·þÎñÆ÷ÉÏ´ò¿ªSQL Server Configuration Manager¡£
·½·¨:µ¥»÷”¿ªÊ¼&rd
Ïà¹ØÎĵµ£º
1£ºSQL ServerÊý¾Ý¿âÅäÖÃ
¿ªÆô·þÎñÆ÷
ÍÐÅÌÏÔʾ·þÎñÆ÷Æô¶¯
2:ÔÚStaAfx.h ÖÐÌí¼ÓÈçÏ´úÂë
#import "C:\\Program Files\\Common Files\\System\\ado\\msado15.dll" no_namespace rename("EOF","adoEOF")rena ......
ÎÒ¶¨ÒåÁËÒ»¸ö textarea:
<tr bgcolor="#CCCCCC" align="center" valign="bottom">
<td align="right" valign="top" class="style1" >ÎÄÕÂÄÚÈÝ£º</td>
&nbs ......
1¡¢ÏÂÔرر¸Èí¼þ
(1) JDK (Java Development Kit)
SUN¹Ù·½µÄÏÂÔصØÖ·ÊÇhttp://java.sun.com/javase/downloads/index.jsp
(2) JDBC
(3) Eclipse
(4) Microsoft SQL Server 2005 Express£¨µ±È»£¬ÓзÇExpressÒ²OK°¡£©
(5) SQL Server Management Studio
2¡¢°²×°Óë»·¾³ÅäÖÃ
(1) JDK
Ê×ÏÈÔÚWindows»·¾³Ï£¬ÏÂÔغó° ......
Load the SQL Server 2005 Driver for JDBC before you load the SQL Server 2000 Driver for JDBC. To do this, use the DriverManager class as in the following code example.
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); // 2005 version
Class.forName("com.microsoft.jdbc.sqlserver.SQLSe ......