VF6ÏÂÁ¬½Ósqlserverµ÷Óô洢¹ý³Ì
ÏÖÔÚÓöµ½µÄÎÊÌ⣺ ¶ÁÈ¡±¾µØÒÑÓеÄdbfÊý¾Ý¿â,дÈëµ½SQLSERVER2000ÖУ¬µ«ÊÇ¿´ÊéºÍÍøÉÏÈ«ÊÇÏîÄ¿×Ô´øÊý¾Ý¿âµÄ¶Áд£¨¼´°ó¶¨Êý¾ÝÔ´£©¡£ ÒÑÖªµÀdbfµÄ·¾¶£¬µ«ÊÇÁ¬½ÓµÄ×Ö·û´®ºÍÊý¾Ý¶ÁÈ¡µÄ²Ù×÷Ôõôд£¿ ÈçºÎÁ¬½ÓSQLServer2000,²¢µ÷ÓÃÆä´æ´¢¹ý³Ì£¿ ÎÒÏëÖªµÀͨ¹ýsqlÓï¾äÈçºÎ¶Á£¬ÈçºÎд. ÏÈлл¸÷λµÄ½â´ð¡£
connDbf = "Driver={Microsoft dBase Driver (*.dbf)};dbq="+postion+"" postionΪdbfÊý¾Ý¿âµÄ¾ø¶ÔµØÖ·£¬Ôõô×ÜÊDZ¨¡°ÕÒ²»µ½¿É°²×°µÄISAM¡±¡£¡£ ÍøÉ϶¼Ëµ£¬ÊÇÁ¬½Ó×Ö·û´®³ö´í¡£¡£µ½µ×ÊÇÄÄÀïÓÐÎÊÌ⣿ ×¢£ºdbfûÓмÓÃÜ£¬Ã»ÓÐÓû§ÃÜÂë¡£ *--Çë²Î¿¼£ºFAQ - <vfpÈçºÎʹÓÃspt> http://faq.csdn.net/read/175938.htmlÒýÓà *--Çë²Î¿¼£ºFAQ - <vfpÈçºÎʹÓÃspt> http://faq.csdn.net/read/175938.html лл£¬ÎÒÊÔÊÔ¡£ »¹ÏëÎÊÏ£¬¶ÔÓÚдÈëdBaseÊý¾Ý¿â£¬ÓÃMicrosoft dBase DriverÇý¶¯£¬»¹±ØÐëװʲôô£¿ Á¬½Ó×Ö·û£ºconnDbf = "Driver={Microsoft dBase Driver (*.dbf)};dbq="+postion+"£»ÊDz»ÊÇÓÐ´í£¿ »¹ÊDZØÐëÓÃMicrosoft Visual FoxPro Driver?? ʲô¿ª·¢¹¤¾ßдÈëdBaseÊý¾Ý¿â£¿ VF6.0,¿¼Âǵ½ÔÚÀϵçÄÔÉÏʹÓÃ..¡£ÒýÓà ʲô¿ª·¢¹¤¾ßдÈëdBaseÊý¾Ý¿â£¿ VF6.0,¿¼Âǵ½ÔÚÀϵçÄÔÉÏʹÓÃ..¡£ ÓÃMicrosoft dBase Driver (*.dbf)£¬×ÜÊDZ¨¡°ÕÒ²»µ½¿É°²×°µÄISAM¡±¡£ ÓÃMicrosoft Visual FoxPro Driver£¬±¨sqlsetconnectattr ʧ°Ü¡£ ³õ´ÎÊ
Ïà¹ØÎÊ´ð£º
дÁËÒ»¸öÓÃCÓïÑÔ²Ù×÷sqlserverÊý¾Ý¿âµÄ³ÌÐò£¬ÔÚÎÒ×Ô¼ºµÄ¼ÆËã»úÉÏÔËÐÐûÎÊÌâ¡£µ«µ½Áíһ̨»úÆ÷ÉÏÔËÐÐʱ£¬SQLConnectº¯ÊýÁ¬½ÓÊý¾Ý¿âʧ°Ü£¬×Ðϸ¼ì²éÉèÖö¼Ã»Óз¢ÏÖÎÊÌ⣬µ«¸Ã»úÆ÷µÄ²Ù×÷ϵͳÊÇWindows Server 2003 Enterp ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð» ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡ ¹Ø×¢¡«¡« Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿ ......
´ó¼ÒÓÐûÓÐ ´æ´¢¹ý³Ì·ÖÒ³µÄÀý×Ó£¬¹²Ïíһϣ¬Ð»Ð»£¡£¡£¡ http://wyf.javaeye.com/blog/462396 SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO /*--ʵÏÖ·ÖÒ³µÄͨÓô洢¹ý³Ì ......
ÈçÌâ¡£ ÎÒÏ붨ÆÚÖ´ÐгÌÐò£¬É¾³ý²»ÓõÄÊý¾Ý£¬ÊÕËõÒ»ÏÂÊý¾Ý¿â£¬Æ½Ê±Ê¹ÓõÄʱºò£¬ÈÕÖ¾×î´óÎļþ´óСΪÏÞÖÆ200MB£¬ µ«ÊÇÊÕËõµÄʱºò£¬»á²úÉú´óÁ¿ÈÕÖ¾£¬Èç¹û³¬¹ýÏÞÖÆ£¬ÔòÊÕËõÊý¾Ý¿âʱ»áʧ°Ü£¬ÎÒÏë¸ÄΪ×î´óÎļþ´óС²»Ê ......
sqlserver ÓÃbcp³éÈ¡Êý¾Ý¡£db2ºÍoracle·Ö±ðÓÃʲôÃüÁîʵÏÖÓësqlserverͬÑùµÄ¹¦ÄÜ¡£ my @proglist =("bcp","$database.bill.$group[$i]","out","$dir\\$currentTime\\$group[$ ......