JDBCÁ¬½Ómicrosoft sqlserverÒªÔõôÁ¬°¡
ŪÁ˰ëÌì¶¼»¹ÊÇŪ²»ºÃ£¬ÔÚÓÃmyeclipse¿ª·¢ÖÐÒªÔõÃ´ÅªÄØ£¬
Ï£Íû˵˵¾ßÌå²½Öè
Ê×ÏÈÓ¦¸Ã°ÑÒì³£·ÅÉÏÀ´
Ò»°ãÈç¹ûÊÇÔÚXPϵͳÏÂ,×°ÉÏSP3»òSP4,´ò¿ª1433¶Ë¿Ú.....
netstat -an¿ÉÒԲ鿴ÊÇ·ñ´ò¿ªÁË1433¶Ë¿Ú
°²×°sqlserver
´ò²¹¶¡
Æô¶¯·þÎñ
µ¼ÈëÇý¶¯°ü
sqlserver ´ò²¹¶¡µ½sp4 ÊÇ×îºÃµÄ£¡
ÏÂÀ´Êǵ¼ÈëÇý¶¯°ü£¡
дÁ´½ÓÀà ´¦ÀíÒì³£
²âÊÔ£¡
Â¥Ö÷°ÑÄãµÄ´úÂëÌù³öÀ´¿´¿´£¬»òÕß±¨´í£¬lsµÄ·½·¨¿ÉÒÔ´¦Àí
¶àÊÇδ°²×°sqlserverµÄ²¹¶¡°ü£¬½¨Òé¶àGOOGLE
Â¥Ö÷ÉϰٶȻòÕßgoogle¿´¿´°É£¡
Òª¿´ÄãÁ¬½ÓµÄÊÇsqlserver2000£¬»¹ÊÇsqlserver2005.
ÕâÁ½¸öÓõÄJDBC°üÊDz»Í¬µÄ¡£
sqlserver2000ÓÃmsbase.jar,mssqlserver.jar,msutil.jarÈý¸ö°ü
sqlserver2005ÓÃsqljdbc.jarÒ»¸ö°ü
°ÑÏàÓ¦µÄ°ü·ÅÈëclasspath,È»ºóÉ趨TCP¶Ë¿Ú£¬2005µÄ»°»¹ÒªÉ趨SQLServerBrowser£¬
×îºóÔÚ³ÌÐòÖÐÓÃÒÔÏ´úÂëÁ¬
Driver d =
(Driver)Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433", "userName", "password");
×¢Òâ
2000ÓÃcom.microsoft.jdbc.sqlserver.SQLServerDriverºÍ
jdbc:microsoft:sqlserver://localhost:1433", "userName", "password"
2005ÓÃcom.microsoft.sqlserver.jdbc.SQLServerDriverºÍ
jdbc:sqlserver://localhost:1433", "userName"
Ïà¹ØÎÊ´ð£º
PB10¡¢PB11Á¬½ÓSQLServer¹Ø¼ü×Ö: pb10¡¢pb11Á¬½Ósqlserver (×ªÔØ)
PB10¡¢PB11Á¬½ÓSQLServer (×ªÔØ)
2007-11-02 22:27
´ÓPB10¿ªÊ¼£¬Ã»ÓÐÁËmssql serverרÓýӿÚÁË£¬ÁíÒ»·½ÃæÊý¾Ý¿â¹ÜÀíϵͳ(DBMS)
»»³ÉÁË ......
ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000Ã ......
ûÁ¬½ÓÍøÏߣ¬ÎÒÔÚ±¾»úÉϰ²×°µÄsqlserver2008¾Í½ø²»È¥ÁË¡£Ôõô½â¾öÄØ£¿
- -Ôõô½øÈ¥²»ÁË·¨£¿
ÆôÓÃÁËÂð£¿
ʲôµÇ½ģʽ£¬ÃÜÂëÕýÈ·Âð£¿
Ìáʾʲô´íÎó£¿
ºÃÌù ºÇ starseeker7
±¨´íÐÅÏ¢¡£¡£ ......
ÈçÌâËùʾ
СµÜʹÓÃDelphi7»·¾³½øÐÐÊý¾Ý²É¼¯£¬²É¼¯µ½µÄÊý¾Ý·ÅÈëSQL Server2000Êý¾Ý¿âÖУ¬µ«ÊÇÏë²»°²×°SQLServer2000À´ÊµÏÖ´ÓÆäËü¼ÆËã»úÉÏÔËÐд˳ÌÐò£¬²»ÖªÈçºÎʵÏÖ£¿Íû¸÷λ´óϺ¸æÖªÒ»¶þ¡£
ÁíÍ⣬ÏÖÔÚСµÜÓöµ½ÁËÒ»¸ö ......
ÎÒÏë°ÑmysqlÀïµÄusers±íÀïÊý¾Ýµ¼Èëµ½sqlserverÀïµÄfs_me_users±íÀï
ÀïÃæµÄ×ֶξͲ»ÁгöÀ´ÁË ÊǶÔÓ¦µÃ¡£
ÓÃasp asp.net »òÕß Ö±½ÓsqlÓï¾ä¶¼ÐÐ
Çë½Ì¸÷λ¡£¡£¡£¡££¡
Õâ¸ö²»ÄѰÉ
1. asp.net µÄ»°,¶ÁÈ¡mysqlµÄ¼Ç¼¼¯ ......