ado·ÃÎÊÔ¶³ÌÊý¾Ý¿â(Ô¶³Ì·ÃÎÊsqlserver)
ÊÇÕâÑùµÄ£¬ÎÒÓÃÊÇODBCÊý¾ÝÔ´Á¬½Ó·þÎñÆ÷µÄÊý¾Ý¿â£¬ÏÖÔÚÎÒ¾õµÃºÜÂé·³£¬ÒòΪҪΪÿÈç»úÌí¼Ó¶ÔÓ¦µÄÊý¾ÝÔ´£¬Ïë°ÑËû¸Ä³ÉADO·½·¨À´·ÃÎÊ·þÎñÆ÷µÄÊý¾Ý¿âÄÜʵÏÖÂð£¿ÒªÔõôд¡£
±ÈÈç·þÎñÆ÷ÀïÓжþ¸öÊý¾Ý¿âdata1 ºÍdata2£¬¿Í»§¶ËÕâ±ßÎÒÉÏÓÃACESSS\vbaÀ´×ö³ÌÐò£¬ÒªÔõô²ÅÄÜÁ¬½Ó·ÃÎʵ½ÎÒ·þÎñÆ÷ÀïÃæµÄÁ½¸öÊý¾Ý¿âµÄÊý¾ÝÄØ£¿Ð»Ð»
http://hi.baidu.com/jjg0513/blog/item/23174d551c795ecdb745aef5.html
²Î¿¼ÏÂ
Ò»´ÎÖ»ÄÜÒ»¸ö.
±ÈÈç·þÎñÆ÷ÀïÓжþ¸öÊý¾Ý¿âdata1 ºÍdata2
ÄãÓÃADOÁ¬½ÓÖ±½Ó·ÃÎÊÄãµÄ·þÎñÆ÷
ΪʲôҪÊÇACCESSµÄ
Â¥ÉÏÄãÌ«¸ãЦÁ˰ɡ£ÄãµÄÒâ˼ÊÇSQLÖ»Äܽ¨Ò»¸öÊý¾Ý¿âà¶
ÎÚ¹êµÄÒâ˼ÊÇÒ»´ÎÖ»ÄÜÁ¬½ÓÒ»¸öÊý¾Ý¿â
ÓÃÁ½¸öÁ¬½ÓÀ´Á¬
Ôõô¸öÁ¬½Ó·¨£¬Ëµ¾ßÌåÒ»µãß¹¡£¡£¸ßÊÖÃÇ
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
xp(sp3)ϵͳ°²×°ÁËsqlserver2000£¬sp3£¬sp4²¹¶¡¶¼´òÁË¡£¶øÇÒ±¾»úÒ²ÄÜÁ¬½Ó·ÃÎÊ¡£
ÎÊÌâÊÇ£º
±¾»útelnet ip 1433 ×ÜÊÇÌáʾÁ¬½Óʧ°Ü£¬
¶øÇÒnetstat -naʱ£¬¿´²»µ½1433¶Ë¿Ú±»Õ¼ÓÃ
(¿Ï¶¨µÄÊÇ£º¶Ë¿ÚÊÇ1433£¬¿ªÆ ......
±ísinger£º
singerID£¬singerName
1£¬ÁõµÂ»ª
2£¬ÕÅѧÓÑ
3£¬¹ù¸»³Ç
4£¬ÀèÃ÷
±ísong£º
songID£¬songName£¬singerID
1£¬ÍüÇéË®£¬1
2£¬ÖйúÈË£¬1
3£¬ÎDZð£¬2
4£¬¶ÔÄã°®²»Í꣬3
......
ÔõôÔÚvfpµÄ±íµ¥ÖÐÏÔÏÖ´ÓsqlserverÖÐ×¥¹ýÀ´µÄͼƬ£¿
ÎÒÓõÄÊÇvfp6.0
Ìý˵¿ÉÒÔµ÷ÓÃÆäËûÓïÑÔдµÄdllÀ´ÊµÏÖ£¬
ÎÒ¿ÉÒÔÓÃdelphiдdll³öÀ´£¬
µ«ÊÇÎÒ²»»áÓÃʹÓÃvfpÀ´µ÷ÓÃdll°¡
Õâ¶Î´úÂëÊÇ´ÓSQLSEREVR¡¡I ......
°²×°SQLServer2000¸öÈ˰棬µ½¡°°²×°ÀàÐÍ¡±½çÃæ£¬²»¹ÜÑ¡ÔñʲôѡÏ²»¹ÜÓÃĬÈÏ·¾¶»¹ÊÇ×Ô¶¨Òå·¾¶£¬µã»÷ÏÂÒ»²½£¬¶¼µ¯³ö¡°ÔÚÖ¸¶¨µÄλÖò»´æÔÚÓÐЧµÄSQLServer°²×°—C:\Program Files\Microsoft SQL Server¡±µÄ¶Ô ......