½ô¼±ÇóÖúsqlserver Êý¾Ý¿â±»ÅúÁ¿²åÈë´úÂë
ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë
Ôõô»ØÊ¡£
´úÂëÒѾдÁ˹ýÂË×Ö·û´®
Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË
Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË
»¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½
ÔõôûÈËÖªµÀ
Ïà¹ØÎÊ´ð£º
´úÂ룺
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......
ÎÒ¿´µÄÊÇ°²×°Officeʱ×Ô´øµÄMicrosoft ActiveXÊý¾Ý¶ÔÏó2.5£¨ADO£©ÆäÖеÄÄÚÈݗĿ¼ÈçÏ£º
ADO³ÌÐòÔ±²Î¿¼
->ADOX API²Î¿¼
->ADOX´úÂë·¶Àý
-> ......
ÈçÌâ¡£
ÎÒÏ붨ÆÚÖ´ÐгÌÐò£¬É¾³ý²»ÓõÄÊý¾Ý£¬ÊÕËõÒ»ÏÂÊý¾Ý¿â£¬Æ½Ê±Ê¹ÓõÄʱºò£¬ÈÕÖ¾×î´óÎļþ´óСΪÏÞÖÆ200MB£¬
µ«ÊÇÊÕËõµÄʱºò£¬»á²úÉú´óÁ¿ÈÕÖ¾£¬Èç¹û³¬¹ýÏÞÖÆ£¬ÔòÊÕËõÊý¾Ý¿âʱ»áʧ°Ü£¬ÎÒÏë¸ÄΪ×î´óÎļþ´óС²»Ê ......
ÏÖÔÚÓöµ½µÄÎÊÌ⣺
¶ÁÈ¡±¾µØÒÑÓеÄdbfÊý¾Ý¿â,дÈëµ½SQLSERVER2000ÖУ¬µ«ÊÇ¿´ÊéºÍÍøÉÏÈ«ÊÇÏîÄ¿×Ô´øÊý¾Ý¿âµÄ¶Áд£¨¼´°ó¶¨Êý¾ÝÔ´£©¡£
ÒÑÖªµÀdbfµÄ·¾¶£¬µ«ÊÇÁ¬½ÓµÄ×Ö·û´®ºÍÊý¾Ý¶ÁÈ¡µÄ²Ù×÷Ôõôд£¿
ÈçºÎÁ¬½ÓSQLS ......
ÈçºÎ½«accessÊý¾Ý¿âÎļþµ¼Èësqlserver2005
µ¼Èëµ¼³ö¼´¿É
ѧϰ ÎÒÒ²ÊÇÐÂÊÖ
Óõ¼Èëµ¼³ö ×ֶμǼ »á¶ªÊ§Âð
²»»á
ÎÒ½«accessµ¼ÈësqlserverÁË µ«²»ÖªµÀÊý¾Ý¿â·ÅÔÚÄÄ
ÓÃSQL SERVER ÖÐ×Ô´øµ ......