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¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î
http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö
ÒýÓÃ
vStream := TMemorySt ......
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
¹ØÓÚORACLEÈÏÖ¤¿¼ÊÔ¶¼°üÀ¨ÄÄЩ°¡£¿
СµÜ¶ÔÓÚÕâ¸öÈÏÖ¤²»ÔõôÁ˽⣬Ã÷°×È˸ø½²½²¡£
ÎÒ¾ÍÌý˵¹ýÓÐOCPÈÏ֤ʲôµÄ...
Õâ¸ö²»´í£¬Äã¿ÉÒÔÁ˽âÏÂ
http://www.oracle.com.cn/viewthread.php?tid=4834&extra=pag ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......