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

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£¬°²×°ºóÖØÆô£¬ÎÊÌâÕվɡ£

ÄÄλÓöµ½¹ýÀàËƵÄÎÊÌ⣿ÏÈлÁË¡£





´ó¼Ò°ï°ï濴һϰÉ
{{


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö

ÒýÓÃ
            vStream := TMemorySt ......

OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......

OracleµÄÔ¼ÊøÊÇ·ñ¿ÉÒÔ¸´ÓÃ

Oracle µÄ Ô¼ÊøÊÇÊÇ·ñ¿ÉÒÔ¸´Óã¿£¨µ÷ÓÃÔ¼ÊøÃû³Æ¾Í¿ÉÒÔÖ±½ÓʹÓøÃÔ¼Êø£©ÔÚÄÄÀï¿ÉÒÔ¹ÜÀíÔ¼Êø¡£
plsqlÓÐÕâ¸ö¹¦ÄÜô£¿


SQL code:
Ö±½ÓÓÃPL/SQL DEVELOPER µã»÷TABLES ÖÐcheck constraints

ÒýÓÃ
SQL ......

oracleÖÐresultset´íÎó

ÔÚoracleÖÐÓÃjdbcÀ´Á¬½ÓÊý¾Ý¿â£¬ÎªÊ²Ã´ResultsetÀïÃæǶÌ×ResultSet,µ½Ñ­»·µÄµÚ¶þ´Î¾Í±¨¿ÕÖ¸Õ룬ÄÄλ֪µÀÊÇÔõô»ØÊÂÂð£¿
´úÂ룺Java code:
while(prors.next()){
System.out.println(prors.getRow ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ