ÈçºÎÔÚACCESSÖзÃÎÊORACLE£¿ - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒ´ÓORACLE½«Ä³±íµ¼ÈëÖÁACCESSÖУ¬ÔÚACCESSÖÐʹÓÃSQLÈçÏ£º
select * into ouform from DEPT_DICT in [ODBC][ODBC;Driver={Microsoft ODBC for Oracle};UID=COMM;PWD=COMM;SERVER=TEST;]
Ö´Ðк󷵻ØÈçÏ´íÎó£¬ÇëÎÊÕâÊÇÔõô»ØÊ£¿ÈçºÎ½â¾ö£¿
¡°Microsoft Jet Êý¾Ý¿âÒýÇæÕÒ²»µ½ÊäÈë±í»ò²éѯ'DEPT_DICT'¡£È·¶¨ËüÊÇ·ñ´æÔÚ£¬ÒÔ¼°ËüµÄÃû³ÆµÄƴдÊÇ·ñÕýÈ·¡£¡±È·¶¨´æÔÚDEPT_DICT±í£¡
°ï°ïæ°¡ ºÜ¼±
ÄãÒѾ½«±íµ¼ÈëACCESSÁË,ºÍORACLEÒѾûÓÐʲô¹ØϵÁË,
³ý·ÇÄãµ¼Èë²»³É¹¦»òÕßÄã½øÐеÄACCESSÓï·¨ÓÐÎÊÌâ
odbcÅäÖúÃûÓУ¬»¹ÓÐÄãµÄ±íËùÊôÓû§Êǵ±Ç°Á¬½ÓµÄÓû§Âð?
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......