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

ACCESSÀïÃæ´´½¨´ø²ÎÊýµÄ´æ´¢¹ý³Ì

ÐèҪעÒâµÄÊÇpage_loadÀïÃæµÄ´´½¨´æ´¢¹ý³ÌÖ»ÄÜÖ´ÐÐÒ»´Î£¬Èç¹ûµÚ¶þ´Î»¹Òª´´½¨Í¬ÃûµÄ»°»áÌáʾ´íÎóÐÅÏ¢“´æ´¢¹ý³ÌÒѾ­´æÔÚ¡£”£¬Æäʵ¼Ó¸öÅжϾÍÐÐÁË¡£ÀÁµÃ¼ÓÁË£¬Ö»ÊÇÓÃÀ´ÊÔÑéһϡ£
µ÷ÊÔ»·¾³ ASP.NET 2.0£¨±àÒ빤¾ßVS2008£©£¬´úÂëC#£¬access°æ±¾2003
protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection oledb = new OleDbConnection();
oledb.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\asp99cms.mdb;Jet OLEDB:Database Password=";
oledb.Open();
if (oledb.State == ConnectionState.Open)
{
string str = "Create proc pr_test(@uid int) As select * from Download where [ID]=@uid";
OleDbCommand olecom = new OleDbCommand();
olecom.CommandText = str;
olecom.Connection = oledb;
olecom.ExecuteNonQuery();
oledb.Dispose();
}
oledb.Close();
oledb.Dispose();
}
protected void Button2_Click(object sender, EventArgs e)
{
OleDbConnection oledb = new OleDbConnection();
oledb.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\asp99cms.mdb;Jet OLEDB:Database Password=";
oledb.Open();
if (oledb.State == ConnectionState.Open)
{
OleDbCommand olecom = new OleDbCommand("pr_test",oledb);
olecom.CommandType = CommandType.StoredProcedure;
olecom.Parameters.Add(new OleDbParameter("@uid",OleDbType.Integer)).Value=TextBox1.Text;
olecom.Connection = oledb;
OleDbDataReader oledr;
oledr=olecom.ExecuteReader();
oledr.Read();
if (oledr.HasRows)
{
Response.Write("´æ´¢¹ý³ÌÖ´Ðгɹ¦");
}
oledr.Close();
oledr.Dispose();
oledb.Dispose();
}
oledb.Close();
oledb.Dispose();
}


Ïà¹ØÎĵµ£º

ACCESS´íÎ󼯣¨²»¶Ï¸üУ©

1.´íÎóÀàÐÍ£º
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] ²Ù×÷±ØÐëʹÓÃÒ»¸ö¿É¸üеIJéѯ¡£
Õâ¸ö´íÎóÒ»°ãÖ»ÓÐÔÚʹÓÃACCESSÊý¾Ý¿âʱ²Å»á³öÏÖ¡£ÒòΪACCESSÔÚ´ò¿ªÊ±»áÉú³ÉÒ»¸öÁÙʱÎļþ.ldb£¬ÕâʱÎļþ¼ÐÈç¹ûûÓÐдÈëȨÏÞʱ£¬Ôò»á·¢Éú´íÎó¡£
½â¾ö·½·¨ÈçÏ£º
1 ......

AccessÊý¾Ý¿âͨ¹ýODBCµ¼³öµ½OracleµÄÁ½¸öСÎÊÌâ

Ò».  Ora-24801:ÔÚOCI_lobº¯ÊýÖзǷ¨µÄ²ÎÊýÖµ
 
°ÑÒ»Õź¬ÓГ±¸×¢”×ֶεıíͨ¹ýODBCµ¼³öµ½OracleµÄʱºòÒ»Ö±³öÏÖÈçÉÏͼËùʾµÄÌáʾÐÅÏ¢¡£³¢ÊÔÈ¥µôÏà¹Ø×Ö¶ÎÖпոñ×Ö·û£¬È¥µô×Ö¶ÎΪ¿ÕµÄ¼Ç¼£¬»¹Êǵ¼³öʧ°Ü¡£×îºóżȻ·¢ÏÖ£¬ÖØÐ½¨Ò»ÕÅÏàͬ½á¹¹µÄ¿Õ±í£¬È»ºó¸´ÖÆÔ­±íµÄ¼Ç¼£¬ÔÙÕ³Ìùµ½Ð±íÖУ¬µ¼³öµ½Oracle¾ ......

OPENDATASOURCE ´ò¿ªexcel¡¢access¡¢qsl

OPENDATASOURCE ´ò¿ªexcel¡¢access¡¢qsl
use test
insert into OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.2.200;User ID=sa;Password=110').test.dbo.adf--´ò¿ªÔ¶³ÌÊý¾Ý¿â
select * from OpenRowSet('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;HDR=Yes;IMEX=1;Database=c:\2003.xls', [kg$])
 --²éѯԶ³ÌÊý¾Ý ......

asp.netµÄ´íÎó Failed to access IIS metabase

asp.netµÄ´íÎó--Failed to access IIS metabase ÊÕ²Ø
 
Server Error in '/sdxx' Application.
--------------------------------------------------------------------------------
Failed to access IIS metabase.
Description: An unhandled exception occurred during the execution of the current web ......

ÓÃVC´¦ÀíACCESSÖеÄλͼÊý¾Ý

----±È½Ï¸´ÔÓµÄÊý¾Ý¿âÖÐÒ»°ã»áÓÐλͼÊý¾Ý£¨±ÈÈçÏàÆ¬£©¡£ËäÈ»ÕâÀà“OLE¶ÔÏó”µÄ²åÈ롢ɾ³ýÒÔ¼°Ìæ»»²Ù×÷ÔÚACCESSÀïÈÝÒ×ʵÏÖ£¬ÔÚVCÖÐÈ´ÏԵø´ÔÓ¶øÇÒÆÄ·ÑÖÜÕÛ¡£ÒÔϰÑ×÷ÕßÓÃVC´¦ÀíACCESSÊý¾Ý¿âÖеÄλͼÊý¾ÝµÄÌå»á¼òµ¥ÐðÊöһϣ¬ÒÔÇë½ÌÓÚ´ó¼Ò¡£
----ÔÚCdaoRecordsetÅÉÉúÀàµÄ¶ÔÏóÖУ¬VC×Ô¶¯ÎªACCESSµÄ“OLE¶ÔÏó&r ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ