ƽʱ¶¼ÊÇÁ¬½Ó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Óï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿ ¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼ Ö麣ÄDZßËÆºõûÉîÛÚºÃ. Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......
µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£ ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü: "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......
Óиö´æ´¢¹ý³ÌÓÐÈý¸öInt²ÎÊýºÍÒ»¸öOut²ÎÊý. Ö´ÐÐʱÏȽ«Ò»Ð©Êý¾Ý²åÈëµ½Ò»¸ö±íÖÐ.È»ºóÔÙ´Ó±íÖÐÈ¡³öÊý¾Ý½øÐÐÐÐתÁÐ,ºÏ¼ÆµÈÂß¼.½«´¦Àí½á¹û·Åµ½Ò»¸ö±íÖÐ.²¢½«Idͨ¹ýOut²ÎÊý·µ»Ø. µ«ÔÚÖ´ÐÐʱ¿ÉÒÔ»ñÈ¡µ½OutÖµ,µ«¾ÍÊÇà ......
±¾À´ÒªÐ´¸ö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 ......