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
лл£¬ÎÒÊÔÊÔ¡£
»¹ÏëÎÊÏ£¬¶ÔÓÚдÈëdBaseÊý¾Ý¿â£¬ÓÃMicrosoft dBase DriverÇý¶¯£¬»¹±ØÐëװʲôô£¿
Á¬½Ó×Ö·û£ºconnDbf = "Driver={Microsoft dBase Driver (*.dbf)};dbq="+postion+"£»ÊDz»ÊÇÓÐ´í£¿
»¹ÊDZØÐëÓÃMicrosoft Visual FoxPro Driver??
ʲô¿ª·¢¹¤¾ßдÈëdBaseÊý¾Ý¿â£¿
VF6.0,¿¼Âǵ½ÔÚÀϵçÄÔÉÏʹÓÃ..¡£
VF6.0,¿¼Âǵ½ÔÚÀϵçÄÔÉÏʹÓÃ..¡£
ÓÃMicrosoft dBase Driver (*.dbf)£¬×ÜÊDZ¨¡°ÕÒ²»µ½¿É°²×°µÄISAM¡±¡£
ÓÃMicrosoft Visual FoxPro Driver£¬±¨sqlsetconnectattr ʧ°Ü¡£
³õ´ÎÊ
Ïà¹ØÎÊ´ð£º
ÈçÌâ
Ö»ÓÐ100·Ö¸øÁË¡£¡£¡£
ÄĸöÐÐÒµ£¿
ÎÒÏëÍøÉϵÄÔ´Âë¿Ï¶¨²»ÄÜÍêÈ«Âú×ã¸öÈËÏë·¨
×îºó»¹µÃ×Ô¼ºÕû
ÍÆ¼öÒ»¿î×ÔÖú½¨Õ¾Èí¼þ£º·çѶ
C#+SQL
¿ÉÒÔÉè¼Æ³ö±È½ÏÁé»îµÄÍøÕ¾
ʲôÐÐÒµ°¡....
µ½51aspx.co ......
´ó¼ÒÓÐûÓÐ ´æ´¢¹ý³Ì·ÖÒ³µÄÀý×Ó£¬¹²Ïíһϣ¬Ð»Ð»£¡£¡£¡
http://wyf.javaeye.com/blog/462396
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
/*--ʵÏÖ·ÖÒ³µÄͨÓô洢¹ý³Ì
......
ÐèҪʹÓÃSQL Server2000»ò2005
ÐèÒªÉè¼ÆÊý¾ÝÓÐЧÑéÖ¤,·Àֹ¼Èë²»ºÏ·¨Êý¾Ý
ÐèÒªÉè¼Æ´æ´¢¹ý³Ì»ò×Ô¶¨Ò庯ÊýÍê³ÉÊý¾ÝµÄ¼Èë\ÐÞ¸Ä\ɾ³ý\ͳ¼Æ\²éѯ
Êý¾Ý¿â´ó²¿·Ö±íÎÒÒѾ½¨Á¢,Ö»ÊǸ¨ÖúÐÔµÄС±í½¨Á¢µÄ»¹²»È«
......
Êý¾Ý¿âÊǰ²×°VS2005×Ô´øµÄÄǸöSQLServer2005¡£Í¼ÐιÜÀí¹¤¾ßÊÇ—>SQL Server Management Studio Express¡£
ÎÒÏÈÊÇÓÃWindowsÉí·ÝÑé֤ģʽ½øÈ¥¡£ µã—>"°²È«ÐÔ" È»ºóÓÒ¼ü"µÇ¼Ãû ......