Á¬½ÓÆäËû»úÆ÷µÄoracle.
LY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.251)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ly) ) ) ÕâÊDZðÈ˸øÎÒµÄһЩÅäÖÃÐÅÏ¢£¬ÎÒÏëÁ¬µ½192.168.0.251Õą̂»úÆ÷µÄÊý¾Ý¿â£¬ÎÒµÄoracle°æ±¾ÊÇ10G£¬ºÜ¾ÃûÓùýoracleÁË£¬Âé·³²½ÖèÏêϸһµã£¬Ð»Ð»
½«ËüÃÇÌí¼Óµ½%oracle_home%\NETWORK\ADMINϵÄtnsnames.oraÎļþÖÐ µÇ¼µÄʱºòÊäÈëÓû§ÃûÃÜÂëºó£¬¿âÃûÌîlyÒýÓà ½«ËüÃÇÌí¼Óµ½%oracle_home%\NETWORK\ADMINϵÄtnsnames.oraÎļþÖÐ µÇ¼µÄʱºòÊäÈëÓû§ÃûÃÜÂëºó£¬¿âÃûÌîly ¶ÔµÄ Ò²¿ÉÒÔʹÓÃͼÐι¤¾ßnet manager net·þÎñÃû£ºLY£¨Ëæ±ãÌîÒ»¸ö¶¼¿ÉÒÔ£© Ö÷»úÃû£º192.168.0.251 Oracle·þÎñÃû£ºly Á¬½ÓµÄʱºòҪעÒ⽫windows·À»ðǽ¹Ø±Õ 1¡¢¿ªÊ¼-->oracle-->¼¯³ÉÅäÖùÜÀí-->net manager 2¡¢Ìí¼ÓÍøÂçÅäÖà 3¡¢Êý¾Ý¿âʵÀýÃûLY 4¡¢Ä¬ÈÏÁ½²½ 5¡¢ÊäÈëÒªÁ¬½ÓµÄipµØÖ·£º192.168.0.251 6¡¢×¢Ò⣺LY_192.168.0.251 7¡¢Íê³É ×¢Ò⣺×îºÃÊÇÓÃÕâ¸ö¿ÉÊÓ»¯½çÃæÀ´ÅäÖ㬶ø²»Òª×Ô¼ºÈ¥ÐÞ¸Ätnsname.oraÎļþÒýÓà 1¡¢¿ªÊ¼-->oracle-->¼¯³ÉÅäÖùÜÀí-->net manager 2¡¢Ìí¼ÓÍøÂçÅäÖà 3¡¢Êý¾Ý¿âʵÀýÃûLY 4¡¢Ä¬ÈÏÁ½²½ 5¡¢ÊäÈëÒªÁ¬½ÓµÄipµØÖ·£º192.168.0.251 6¡¢×¢Ò⣺LY_192.168.0.251 7¡
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬ -A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô? 2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8). ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ. ²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô? Äĸö»Ø¸öÌ ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
ÇëÎÊÒ»ÏÂ,C# winformÖÐͨ¹ýOleDbCommand,Ôõôµ÷ÓÃoracle·µ»ØÓαêÀàÐ͵ĺ¯Êý?¼±!!! /// <summary> /// Ö´Ðдø²ÎÊýµÄ´æ´¢¹ý³Ì·µ»ØÊý¾Ý¼¯ &nb ......