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

Çë½ÌADO.NET·ÃÎÊOracleµÄ×Ö·û´®µÄ¸ñʽ

ƽʱ¶¼ÊÇÁ¬½ÓMSSQL û̫עÒâÕâ¸öÎÊÌâ..½ñÌìÒòΪÐèÒª.ÔÚÍøÉÏÕÒÁËÒ»ÏÂ..Óкöà.. ¶¼ÊÔÁË.²»ÐÐ
ºÜ¶à¶¼ÊDZ¨:
    δ´¦ÀíµÄÒì³£;System.Exception System.Data.OracleCilent ÐèÒª Oracle ¿Í»§¶ËÈí¼þ 8.1.7 »ò¸ü¸ßµÄ°æ±¾..
ÓôÃÆÁË..
ÔÚ´ËÇë½Ìһϴó¼Ò..
Êý¾Ý¿â·þÎñÆ÷Ip:192.168.10.100
¶Ë¿Ú:1522
Óû§Ãû:admin
ÃÜÂë:admin
PS : ÎÒÓõÄÊÇVS 2008 ²Ù×÷ϵͳÊÇ:Server 2008 ÆóÒµ°æ ûÓа²×°Oracle ÊÇͨ¹ýIPÔ¶³ÌÁ¬½ÓµÄOracleÊý¾Ý¿â·þÎñÆ÷
°Ñ oracle ¿Í»§¶Ë×°Ï¡£

User ID=Óû§ID;Password=ÃÜÂë;Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST=·þÎñÆ÷IP)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ʵÀýÃû³Æ)))

²»°²×°oracle¿Í»§¶ËÁ¬½ÓORACLE
http://www.cnblogs.com/land/archive/2009/08/17/1548120.html

ѧϰ

½¨Òé°²×°oracle¿Í»§¶Ë¡£½â¾ö·½°¸»¹ÊÇÕý¹æÒ»Ð©±È½ÏÎÈÍס£

ÒýÓÃ
°Ñ oracle ¿Í»§¶Ë×°Ï¡£

Ò»¶¨Òª×°¿Í»§¶ËµÄÂð??²»×°¾Íû°ì·¨·ÃÎÊÁË..???

ÒýÓÃ
ÒýÓà 1 Â¥ xiaohui_1 µÄ»Ø¸´:
°Ñ oracle ¿Í»§¶Ë×°Ï¡£

Ò»¶¨Òª×°¿Í»§¶ËµÄÂð??²»×°¾Íû°ì·¨·ÃÎÊÁË..???

ÎÒÓдÎÒ²ÊÇÁ¬²»ÉÏ °Ñ¿Í»§¶Ë×°Ï ¾ÍOKÁË¡£

ÒýÓÃ
ÒýÓà 6 Â¥ ycpaladin µÄ»Ø¸´:
ÒýÓà 1 Â¥ xiaohui_1 µÄ»Ø¸´:
°Ñ oracle ¿Í»§¶Ë×°Ï¡£

Ò»¶¨Òª×°¿Í»§¶ËµÄÂð??²»×°¾Íû°ì·¨·ÃÎÊÁË..???

ÎÒÓдÎÒ²ÊÇÁ¬²»ÉÏ °Ñ¿Í»§¶Ë×°Ï ¾ÍOKÁË¡£


Ïà¹ØÎÊ´ð£º

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

Ò»Ä깤×÷¾­Ñ飬ÊìϤoracleÖ麣ÕÒ.net¹¤×÷Òª¶àÉÙ¹¤×Ê£¿

ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼

Ö麣ÄDZßËÆºõûÉîÛÚºÃ.

Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......

imp µ¼Èë oracle ÎÊÌâ

µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£

ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º

IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......

ADO.NETµ÷ÓÃOracle´æ´¢¹ý³Ì?

Óиö´æ´¢¹ý³ÌÓÐÈý¸öInt²ÎÊýºÍÒ»¸öOut²ÎÊý.
Ö´ÐÐʱÏȽ«Ò»Ð©Êý¾Ý²åÈëµ½Ò»¸ö±íÖÐ.È»ºóÔÙ´Ó±íÖÐÈ¡³öÊý¾Ý½øÐÐÐÐתÁÐ,ºÏ¼ÆµÈÂß¼­.½«´¦Àí½á¹û·Åµ½Ò»¸ö±íÖÐ.²¢½«Idͨ¹ýOut²ÎÊý·µ»Ø.
µ«ÔÚÖ´ÐÐʱ¿ÉÒÔ»ñÈ¡µ½OutÖµ,µ«¾ÍÊÇà ......

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