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

Çë½Ìoracleµ¼³öµ½sql server2005

û¸É¹ýÕâÊ£¬Ò²²»ÖªµÀoracleÊý¾Ý¿âɶÑù£¬Çë½Ì´óϺÃǾßÌå²½ÖèÊÇʲô£¿ÐèҪעÒâЩʲô£¿
ÊÇÕû¸ö¿âµÄÊý¾Ý»¹ÊÇ±íµ¥?

Õæ¸öÊý¾Ý¿â

Õû¸öÊý¾Ý¿â£¬ÁíÍâÎÒÊÇ´Óһ̨װÓÐoracleµÄµçÄÔµ¼Èëµ½Áíһ̨װÓÐsql serverµÄµçÄÔÖС£¶àл£¡
ÒýÓÃ
ÊÇÕû¸ö¿âµÄÊý¾Ý»¹ÊÇ±íµ¥?



¸ÕgoogleÁËÏ£¬Ò²Ã»ÕÒµ½oracle µ¼ÈëSQL serverµÄ·½·¨,Ö»ÕÒµ½Á˸öSQL server ºÍ oraclµÄÁ¬½Ó£¬ Èç¹û¿ÉÒÔ£¬Á¬½ÓÉÏÁ˾ͿÉÒÔʹÓÃÁË£¬¾Í²»Óõ¼ÈëÁË°É. 

Â¥Ö÷¿ÉÒÔÊÔÊÔ..

ÒÔSQL Server 2000ΪÀý˵Ã÷SQL Serverµ½OracleÁ¬½Ó·þÎñÆ÷µÄ¾ßÌåʵÏÖ¹ý³Ì¡£

1.ÒªÇópc»úÉÏ°²×°oralce¿Í»§¶ËÈí¼þºÍsqlserver2000Èí¼þ¡£

2.¿Í»§¶ËµÄÅäÖÃtnsnames.oraÎļþ£¬ÅäÖÃËùÒªÁ¬½ÓµÄÊý¾Ý¿â·þÎñÆ÷£¨windows£¬unixµÈƽ̨¾ù¿ÉÒÔ£©

eg£ºtnsnames.ora

......

TEST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.11.90)(PORT = 1521))

)

(CONNECT_DATA =

(sid = blue)

(SERVER = DEDICATED)

)

)

......

3.ÅäÖÃwindowsµÄODBCÊý¾ÝÔ´£º

¿ªÊ¼²Ëµ¥—¡·ÉèÖס·¹ÜÀí¹¤¾ß—¡·Êý¾ÝÔ´£¨ODBC£©—¡·½øÈëÅäÖÃÓû§DSN»òÕßϵͳDSN¾ù¿ÉÒÔ£ºÌí¼Ó—¡·Ñ¡ÔñMicrosoft ODBC for oracle—¡·×Ô¶¨ÒåÊý¾ÝÔ´Ãû³Æ£¨×îºÃ¸útnsÖÐÁ¬½Ó´®Í¬Ãû£¡£©—¡··þÎñÆ÷Ãû³Æ£¨±ØÌÌîдtnsÎļþÖеÄÁ¬½Ó´®Ãû³Æ£©—¡·Íê³É¡£



Ïà¹ØÎÊ´ð£º

sql server 2000 +aspÍøÕ¾7¸öСʱºó³öÎÊÌâ

×Ô´ÓÖ±½ÓÔÚÒ»¸ö±íÀï¼ÓÁ˸ö×ֶΣ¨varchar ÆäËûĬÈÏ£¬²»²åÈë×Ô¼ºÄ¬ÈÏΪ <null>£©ºó,ÖØÆôÍøÕ¾+sql server 2000 6-8¸öСʱºó³öÏÖÎÊÌ⣺ÍøվдÊý¾Ý¿âʱ½Å±¾³¬Ê±

Active Server Pages ´íÎó 'ASP 0113' ......

¹ØÓÚÔÚlinuxÏÂжÔØoracle10gµÄÎÊÌâ

¿´µ½ÍøÉÏÓкܶàÏàͬµÄ´ð°¸£¬µ«ÊÇÔÚÎÒʹÓÃvmϲ¢Ã»Óз¢ÏÖÕâЩĿ¼¡£

²Ù×÷ϵͳ£ºcentos4.5
ÐéÄâ»úÉÏ°²×°£¬Ö®Ç°°²×°ÁËoracle10g£¬½ñÌìÐèÒªÍêȫжÔØ£¬ÌýºÜ¶àÈË˵ֱ½Óɾ³ýÎļþĿ¼¼´¿É£¬Çë¸÷λ°ïæÊDz»ÊÇÕâÑù£¬ ......

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 ......

linux ϵÄjava ³ÌÐòµ÷ÓÃsqlplusÖ´ÐÐ.sqlÎļþÂÒÂë

                        ÏÖÔÚÎÒµÄÇé¿öÊÇÕâÑù£º

                        ÎÒµÄ ......

sql ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ