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

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


Ïà¹ØÎĵµ£º

VC++µÄADOÁ¬½ÓSQL Server²½Öè

 1£ºSQL  ServerÊý¾Ý¿âÅäÖÃ
 
 
 
¿ªÆô·þÎñÆ÷
 
 
ÍÐÅÌÏÔʾ·þÎñÆ÷Æô¶¯
 
 
 
2:ÔÚStaAfx.h ÖÐÌí¼ÓÈçÏ´úÂë
#import "C:\\Program Files\\Common Files\\System\\ado\\msado15.dll" no_namespace      rename("EOF","adoEOF")rena ......

textareaÖеÄÄÚÈÝͨ¹ýÌí¼Ó°´Å¥Ìí¼Óµ½SQLÊý¾Ý¿âÖÐ

ÎÒ¶¨ÒåÁËÒ»¸ö textarea:
  <tr bgcolor="#CCCCCC" align="center" valign="bottom">
            <td align="right" valign="top" class="style1"  >ÎÄÕÂÄÚÈÝ£º</td>
         &nbs ......

¿ìËٸ㶨ÔÚEclipseÖÐÓÃJDBCÁ¬½ÓSQL Server 2005

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»·¾³Ï£¬ÏÂÔغó° ......

SQL Server 2005 Driver for JDBC


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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ