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

ORACLE Óë ACCESS µ¼Êý¾ÝµÄÎÊÌ⣡

ORA Ïò ACCESS Öе¼Êý¾Ý£¬ÓõÄÊÇÊý¾Ý¹ÜµÀ£¡

ORAºÍACCESSµÄÁ¬½Ó·½Ê½£¬¶¼ÊÇODBCÁ¬½Ó£¡

PB°æ±¾ÊÇ PB6.5£¡

¿Í»§ÄDZßÔËÐÐʱ£¬³öÏÖ dbms odbc is not supported in your current installation µÄ´íÎ󣬲éÁËÏÂ×ÊÁÏÊÇȱÉÙÎļþ£¬

ĿǰÎÒ°Ñ pbdwe60.dll ºÍ pbvm60.dll ·Åµ½Ó¦ÓóÌÐòµÄĿ¼Ï£¬Í¬Ñù±¨ÏàͬµÄ´íÎó£¡

¶¼ÐèҪʲôÎļþ£¬ÐèÒª·ÅÔÚʲôλÖã¿

¶àл£¡¶àл£¡
²Î¿¼:

SQL code:
²»°²×°Oracle¿Í»§¶ËµÄÁ¬½Ó·½·¨

¡¡¡¡½üÀ´ÊÕÀ´²»ÉÙÍøÓÑÀ´ÐÅ£¬·´Ó³Ê¹Óñ¾·½·¨²»ÄÜÁ¬½ÓÊý¾Ý¿â¡£ ÎÒ¼ì²éÁËһϣ¬ÊÇÍøÓÑÍü¼Ç¼ÓÈëODBC¼°PowerBuilderµÄ¶¯Ì¬¿â.ÒÔPB7.0ΪÀý£¬Ìز¹³äÈçÏ£ºÇ뽫ÒÔÏÂÎļþ¿½±´µ½ÔËÐÐÎļþËùÔÚĿ¼£º

¡¡¡¡Ò»¡¢ODBC¶¯Ì¬¿â

¡¡¡¡ctl3d32.dll msvcrt40.dll odbc16gt.dll odbc32.dll odbc32gt.dll odbccp32.dll odbccr32.dll odbcint.dll

¡¡¡¡¶þ¡¢½¨Á¢EXTRA×ÓĿ¼£¬½«MSVCRT.DLLÎļþ¿½±´µ½¸Ã×ÓĿ¼ÏÂ

¡¡¡¡EXTRA\MSVCRT.DLL

¡¡¡¡Èý¡¢ORACLE¶¯Ì¬¿â¼°ÅäÖÃÎļþ

¡¡¡¡Tnsnames.ora CORE35O.DLL NASNSNT.DLL NAUNTSNT.DLL NCRNT.DLL Nlnt.dll NLSRTL32.DLL Nnfdnt.dll NNFNNT.DLL ¡¡¡¡NSNT.DLL NTNT.DLL NTTNT.DLL CIW32.DLL Ora73.dll OTRACE73.DLL Sqlnet.ora Sqltnsnt.dll CORE35.DLL

¡¡¡¡ËÄ¡¢PB¶¯Ì¬¿â

¡¡¡¡pbvm70.dll pbdwe70.dll Pbo7370.dll PBO8470.DLL pbodb70.dll libjcc.dll




ȱÉÙODBCÊý¾ÝÔ´Ö§³Ö£¡
°²×°oracleÁËÂð£¿


oracle°²×°ÓÐÎÊÌâÁË£¬odbcÀïÄܲâ³É¹¦Âð


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

ACCESSÎı¾¿ò³¤¶ÈÊǶàÉÙ? - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿

²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û

ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ