"Failed to access IIS metabase"½â¾ö·½·¨
ÔÒò£ºIISûÓÐ×¢²á,ÎÒÊÇÔÓÐϵͳµÄIISɾÁË,Ôì³ÉÔËÐÐIISÖеÄÓ¦ÓóÌÐò³öÏÖÕâÖÖ´íÎó!
½â¾ö°ì·¨:
ÔÚCMDÖнøÈëĿ¼C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727£¬ÔËÐÐaspnet_regiis
1¡¢aspnet_regiis -ga administrator£¨administratorΪµ±Ç°Óû§£©
2¡¢aspnet_regiis -i £¨×¢²áIIS£©
3¡¢iisreset /noforce £¨ÖØÆôIIS£©
Çë×¢Òâ:µ±Ç°µÇ¼ϵͳµÄÕʺÅÒ»¶¨ÒªÊdz¬¼¶ÏµÍ³¹ÜÀíÔ±(administrator),ÎÒÔÚÕâÉÏÃ滨Á˺ܳ¤Ê±¼ä²ÅŪÃ÷°×,ÎÒ¹«Ë¾ÊÇÒÔÍøÓò(AD)ÕʺŵǼ,ÎÒADÕʺÅÒÔÊDZ¾»úµçÄÔ¹ÜÀíÔ±,¿ÉÊǾÍÊÇÎÞ·¨Æô¶¯IIS,ÔÒò¾ÍÔÚÕâÀï.×îºóÎÒ²»ÒÔADµÇ¼±¾»ú,ÒÔ±¾»ú¹ÜÀíÔ±µÇ¼¾Í½â¾öÁËÎÊÌâ.
ÏêϸÐÅÏ¢:
C:\Documents and Settings\Administrator>cd c:\\windows\\microsoft.net\\framework\\v2.0.50727
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis -ga administrator
Start granting administrator access to the IIS metabase and other directories us
ed by ASP.NET.
Finished granting administrator access to the IIS metabase and other directories
used by ASP.NET.
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis -i
Start installing ASP.NET (2.0.50727).
..............
Finished installing ASP.NET (2.0.50727).
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>iisreset /noforce
Attempting stop...
Internet services successfully stopped
Attempting start...
Internet services successfully restarted
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>
Ïà¹ØÎĵµ£º
ÏÂÎçÔÚExcelµ¼ÈëSQLʱ£¬·¢ÏÖÔÁ¬½ÓExcelµÄÊý¾ÝÁ¬½Ó´®¹ýʱÔì³ÉеÄExcel¸ñʽ*.xlsxÎÞ·¨Ê¶±ð¡£
°ÑеÄÁ¬½Ó´®Ìæ»»~
·Ö±ð²âÊÔ03/07µÄExcelÎļþ¾ù¿Éͨ¹ý~
Office 97-2003°æ±¾
Excel: Provider= Microsoft.Jet.OLEDB.4.0;Data Source=ÎļþλÖÃ;Extended Properties=Excel 8.0;
Access: Provider= Microsoft.Jet.OLEDB ......
MS Access ODBC connection strings
Standard Security:
"Driver= {MicrosoftAccessDriver(*.mdb)};DBQ=C:\App1\Your_Database_Name.mdb;Uid=Your_Username;Pwd=Your_Password;"
Workgroup:
"Driver={Microsoft Access Driver (*.mdb)}; Dbq=C:\App1\Your_Database_Name.mdb; SystemDB=C:\App1\Your_Database_Name.mdw ......
1.´íÎóÀàÐÍ£º
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] ²Ù×÷±ØÐëʹÓÃÒ»¸ö¿É¸üеIJéѯ¡£
Õâ¸ö´íÎóÒ»°ãÖ»ÓÐÔÚʹÓÃACCESSÊý¾Ý¿âʱ²Å»á³öÏÖ¡£ÒòΪACCESSÔÚ´ò¿ªÊ±»áÉú³ÉÒ»¸öÁÙʱÎļþ.ldb£¬ÕâʱÎļþ¼ÐÈç¹ûûÓÐдÈëȨÏÞʱ£¬Ôò»á·¢Éú´íÎó¡£
½â¾ö·½·¨ÈçÏ£º
1 ......
Ò». Ora-24801:ÔÚOCI_lobº¯ÊýÖзǷ¨µÄ²ÎÊýÖµ
°ÑÒ»Õź¬ÓГ±¸×¢”×ֶεıíͨ¹ýODBCµ¼³öµ½OracleµÄʱºòÒ»Ö±³öÏÖÈçÉÏͼËùʾµÄÌáʾÐÅÏ¢¡£³¢ÊÔÈ¥µôÏà¹Ø×Ö¶ÎÖпոñ×Ö·û£¬È¥µô×Ö¶ÎΪ¿ÕµÄ¼Ç¼£¬»¹Êǵ¼³öʧ°Ü¡£×îºóżȻ·¢ÏÖ£¬ÖØн¨Ò»ÕÅÏàͬ½á¹¹µÄ¿Õ±í£¬È»ºó¸´ÖÆÔ±íµÄ¼Ç¼£¬ÔÙÕ³Ìùµ½Ð±íÖУ¬µ¼³öµ½Oracle¾ ......
ACCESS SQLÓï·¨²Î¿¼
=================
Ò». »ù´¡¸ÅÄî
¿ÉÒÔʹÓõÄÊý¾ÝÀàÐÍÈçÏ£º
1. TEXT£ºÎı¾ÐÍ£¨Ö¸¶¨³¤¶Èʱ£©£¬±¸×¢ÐÍ£¨²»Ö¸¶¨³¤¶Èʱ£©£»
2.
CHAR£¬NCHAR£¬VARCHAR£¬NVARCHAR£ºÎı¾ÐÍ£¬¿ÉÒÔÖ¸¶¨³¤¶È£¬·ñÔòĬÈÏֵΪ255£¡
3. ......