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

ÈçºÎÔÚ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ÅäÖúÃûÓУ¬»¹ÓÐÄãµÄ±íËùÊôÓû§Êǵ±Ç°Á¬½ÓµÄÓû§Âð?


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

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 / ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ