Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÎļþÖеÄÁ¬½Ó´®Ãû³Æ£©—¡·Íê³É¡£



Ïà¹ØÎÊ´ð£º

aspÁ¬½ÓSQL2005 ³öÏÖ ÎÞЧµÄÁ¬½Ó(0x80004005) ´íÎó£¡

´íÎóÐÅÏ¢£º
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][Shared Memory]ÎÞЧµÄÁ¬½Ó¡£
/bbsxp/test.asp, µÚ 24 ÐÐ

»úÆ÷ÅäÖÃ:xp sp3 ,SQL 2005(vs ......

¸ß·ÖÇóASP.NET to oracleÊý¾ÝÒç³ö´íÎó

OCI-22053: Òç³ö´íÎó

ÎÒ²éÁËÏÂ
http://www.cnblogs.com/jackhuclan/archive/2008/11/13/1332575.html

Òâ˼ÊÇOracle ÊýÖµÊý¾ÝÀàÐÍ×î¶à¿É´æ´¢ 38 ¸ö×ֽڵľ«¶È¡£
µ±½« Oracle Êýֵת»»Îª¹«¹²ÓïÑÔ ......

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

SQLÓï¾äÕýÈ·µ«ÊÇRESULTSETÖÐûÓÐÖµ

StringBuffer str = new StringBuffer("select * from menu where parentid=1 and mid <>1 order by parentid");

List list = new ArrayList();
ResultSet rst = null;
DataBa ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ