Oracle¿Í»§¶Ë°²×°ºóODBCÎÞ·¨Ê¹ÓÃ
°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Administrator\\product\\11.1.0\\client_1\\SQORA32.DLL"
½¨ODBCÊý¾ÝÔ´µÄʱºòÄÜ¿´µ½126µÄ´íÎó£º
The setup routines for the Oracle in instantclient11_1 ODBC driver could not be loaded due to system error code 126.
Ó¦ÓóÌÐòÁ¬½ÓÊý¾Ý¿âµÄʱºòÊÇ1114µÄ´íÎó£º
Error Cannot Load Resource File sqresus.dll
ERROR[IM003] Specified driver could not be loaded due to system error 1114 (Oracle in OraOdac11g_home1).
ÎÊÌâÊÇÎÒ3¸öÔÂǰ¾ÍÊÇÓÃͬÑùµÄ°ü°²×°µÄ£¬µ±Ê±Ê²Ã´ÎÊÌⶼûÓС£Õâ´ÎÊÇÁ½Ì¨»úÆ÷ÈÃITµÄÈËÐÂ×°ÁËÁ½Ì¨Ó¢ÎĵÄXP+SP2¡£È»ºóÁ½Ì¨¶¼ÓÐÕâÑùµÄÎÊÌâ¡£ºóÀ´´ÓÍøÉÏÏÂÁËÒ»¸ö×îеÄODBCÇý¶¯£¬¿´°üÀïÃæµÄDLLÎļþµÄÈÕÆÚºÍ³ß´ç£¬ºÍÎÒ»úÆ÷ÉϵͼÊÇÒ»ÑùµÄ¡£ºóÀ´»¹ÊÇ×°ÁËÒ»´Î£¬È»ºóODBC¶àÁËÒ»¸öÃûΪOracle in instantclient11_1µÄÏ°æ±¾Ò»Ñù»¹ÊÇ11.01.00.07£¬°²×°ºóÖØÆô£¬ÎÊÌâÕվɡ£
ÄÄλÓöµ½¹ýÀàËÆµÄÎÊÌ⣿ÏÈлÁË¡£
´ó¼Ò°ï°ï濴һϰÉ
{{
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
Ò»¶Ô¶à¹ØÏµ²éѯ
±í:
ea,eb,ga,gb
±í¹ØÏµÈçÏÂ
ea1=eb1
ga1=gb1
eb1=gb31 and eb3 = gb33
ÊÂÀýÊý¾Ý¼°¹ØÏµÈçÏÂ:
SQL code:
SELECT ea1, eb3, gb1, gb3, gb31, gb33
from (S ......
ΪʲôÔÚwindows7ÉÏ×°²»ÉÏoracleÊý¾Ý¿â£¿£¿£¿
ÒòΪ²»Ö§³Ö
¿ÉÒÔ°²×°Êý¾Ý°¡£¬ ÄãÓõÄÄǸö°æ±¾µÄWindows 7°¡£¬Ä¿Ç°7600µÄ¼æÈÝÐÔÓкܴóÌáÉýÁË£¬£¬ÎÒÊÇÓÃSQL Sever 2005£¬¾ÍûÓÐÎÊÌ⣬oracleÓ¦¸ÃÒ²¿ÉÒԵģ¬Èç¹û²» ......
Ê×ÏÈ˵˵±¾ÈËÏë·¨
±¾ÈËÏëÒÔһֱѧϰoracleÊý¾Ý¿â²¢ÇÒÂýÂýµÄÉîÈëÏÂÈ¥,ËùÒÔ¾ÍÉæ¼°µ½Ê¹ÓõÄÎÊÌâµÄ,ÒòΪʹÓõĻú»áÔ½¶àËùÒÔѧÆðÀ´Ó¦¸ÃÔ½¿ì.
ËùÒÔÎÒÏëÒÔºóÔÚÏîÄ¿Öж¼Ê¹ÓÃ,ÄÇô¾Í»áÉæ¼°µ½ÊÕ·ÑÎÊÌâ,
±ÈÈç˵ÎÒÃǹ«Ë ......