sqlµ¼accessµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET
´úÂëÕâôдµÄ string sqlCmd = "SELECT * INTO [;Data Source=D:\\2010-05-20.mdb,pwd=].main from RptMain WHERE RptCode in " + queryrms; int i = rmdc.ExecuteCommand(sqlCmd); È»ºóÌáʾ´íÎó Ö¸¶¨µÄ¼Ü¹¹Ãû³Æ "Data Source=D:\2010-05-20.mdb,pwd=" ²»´æÔÚ£¬»òÕßÄúûÓÐʹÓøÃÃû³ÆµÄȨÏÞ¡£ °ÑËùÓÐȨÏÞ¶¼½µµ½×îµÍÁË£¬ÓÃaccessÒ²ÄÜÕý³£´ò¿ª£¬Ò²Ã»ÓÐÃÜÂ룬ÒÔǰ×öÀàËÆµÄ¹¦ÄÜÕâôдҲû´í°¡ ²»ÖªµÀÊÇÕ¦»ØÊ°¡ »·¾³vs2008 office2007
Ö¸¶¨µÄ¼Ü¹¹Ãû³Æ ";Data Source=D:\Microsoft\Projects\RptOnline\common\2010-05-20.mdb;pwd=" ²»´æÔÚ£¬»òÕßÄúûÓÐʹÓøÃÃû³ÆµÄȨÏÞ¡£ ÊÔÁËһϣ¬Ò»ÑùŶÒýÓà ָ¶¨µÄ¼Ü¹¹Ãû³Æ ";Data Source=D:\Microsoft\Projects\RptOnline\common\2010-05-20.mdb;pwd=" ²»´æÔÚ£¬»òÕßÄúûÓÐʹÓøÃÃû³ÆµÄȨÏÞ¡£ ÊÔÁËһϣ¬Ò»ÑùŶ ¸ñʽ,ÊÔÏ SELECT * INTO [;Provider=Microsoft.Jet.OLEDB.4.0;Database=c:\Êý¾ÝÎļþ.mdb;].main ... Ö¸¶¨µÄ¼Ü¹¹Ãû³Æ ";Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Microsoft\Projects\RptOnline\common\2010-05-20.mdb;" ²»´æÔÚ£¬»òÕßÄúûÓÐʹÓøÃÃû³ÆµÄȨÏÞ¡£ ¿ìÎÞÓïÁË£¬ºÍ»·¾³ÓйØÏµÃ´ ´úÂëдµÄÕæÄÑ¿´¡£¡£¡£ "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\sourcemachine\test\test.mdb"; ʹÓÃOldbConnectionµ¥¶ÀÁ¬½Ó ±ðÄÇÑùд¡£ ÄÇÀïÄÑ¿´ÁË£¬¾ÍÒ»¸öÖ±½ÓдÈ룬ºÎ±ØÓÃoledbµ¥¶ÀÁ¬½Ó µ¥¶ÀÁ¬½ÓµÃ°ÑÊý¾ÝÈ¡³öÀ´ÔÙдÈë°É£¬ÄÜÖ±½Ó¿
Ïà¹ØÎÊ´ð£º
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡ Ëæ±ã¸ãÒ»D°æ°É£¬ ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓà 2000,2005¶¼ÕâÑù http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
ÎÒÁ¬½ÓaccessÊý¾Ý¿â£¬ÒÔǰһֱºÜºÃ£¬×î½üÈ´×ÜÊdzö´í£¨Êý¾Ý¿âÁ¬½Ó³ö´í!£¡£©£¬´úÂëÈçÏ£º connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&" ......
sqlserverµÄÊý¾Ý¿â£¬×Ö¶ÎÊÇimageÀàÐ͵ġ£Ôõôд´úÂ룬ÔÚÒ³ÃæÖеã»÷¡°ÏÂÔØ¡±¾ÍÄÜ´ò¿ªÄǸöÏÂÔØ¶Ô»°¿ò£¿ PS£ºOracleLob ÔÚsqlserverÀïÊÇʲô£¿ Response.Redirect("test.jpg") ÒýÓà Response.Redirect( ......
½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º DECLARE @STR NVARCHAR(MAX) SET @STR='SELECT * from SALE_PROD' ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿ Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡ ¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡ Ö±½ÓÖ´ÐоÍÐÐÁË exec ......