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

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 ʧ°Ü¡£
³õ´ÎÊ


Ïà¹ØÎÊ´ð£º

ÔÚ64λϵͳÉÏÓÃCÓïÑÔ²Ù×÷sqlserverÊý¾Ý¿âµÄÎÊÌâ

дÁËÒ»¸öÓÃCÓïÑÔ²Ù×÷sqlserverÊý¾Ý¿âµÄ³ÌÐò£¬ÔÚÎÒ×Ô¼ºµÄ¼ÆËã»úÉÏÔËÐÐûÎÊÌâ¡£µ«µ½Áíһ̨»úÆ÷ÉÏÔËÐÐʱ£¬SQLConnectº¯ÊýÁ¬½ÓÊý¾Ý¿âʧ°Ü£¬×Ðϸ¼ì²éÉèÖö¼Ã»Óз¢ÏÖÎÊÌ⣬µ«¸Ã»úÆ÷µÄ²Ù×÷ϵͳÊÇWindows Server 2003 Enterp ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

sqlserverÖУ¬Óô洢¹ý³Ì·ÖÒ³

´ó¼ÒÓÐûÓÐ ´æ´¢¹ý³Ì·ÖÒ³µÄÀý×Ó£¬¹²Ïíһϣ¬Ð»Ð»£¡£¡£¡
http://wyf.javaeye.com/blog/462396

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


/*--ʵÏÖ·ÖÒ³µÄͨÓô洢¹ý³Ì

  ......

ÈçºÎÉèÖÃSqlserverÊý¾Ý¿âÈÕÖ¾Ôö³¤·½Ê½

ÈçÌâ¡£
ÎÒÏ붨ÆÚÖ´ÐгÌÐò£¬É¾³ý²»ÓõÄÊý¾Ý£¬ÊÕËõÒ»ÏÂÊý¾Ý¿â£¬Æ½Ê±Ê¹ÓõÄʱºò£¬ÈÕÖ¾×î´óÎļþ´óСΪÏÞÖÆ200MB£¬
µ«ÊÇÊÕËõµÄʱºò£¬»á²úÉú´óÁ¿ÈÕÖ¾£¬Èç¹û³¬¹ýÏÞÖÆ£¬ÔòÊÕËõÊý¾Ý¿âʱ»áʧ°Ü£¬ÎÒÏë¸ÄΪ×î´óÎļþ´óС²»Ê ......

·db2,oracleÓësqlserver bcp³éÈ¡Êý¾Ý

sqlserver ÓÃbcp³éÈ¡Êý¾Ý¡£db2ºÍoracle·Ö±ðÓÃʲôÃüÁîʵÏÖÓësqlserverͬÑùµÄ¹¦ÄÜ¡£
my @proglist =("bcp","$database.bill.$group[$i]","out","$dir\\$currentTime\\$group[$ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ