oracle ÏòSQL µ¼ÈëÊý¾Ý - .NET¼¼Êõ / ASP.NET
ÔÚoracle°æ¿é£¬Ã»ÈËÎÊ´ð
ÔÀ´µÄ¿âÊÇoracleµÄ£¬ÏÖÔÚ»»³ÉSQLµÄÁË£¬Òª°ÑÔÀ´µÄÊý¾Ýµ¼¹ýÀ´£¬¸ßÊÖ°ï°ï°¡
1¡¢ÔÚÄ¿µÄSQL ServerÊý¾Ý¿â·þÎñÆ÷Éϰ²×°ORACLE ClientÈí¼þ»òÕßORACLE ODBC Driver.
ÔÚ$ORACLE_HOME\network\admin\tnsnames.oraÀïÅäÖÃORACLEÊý¾Ý¿âµÄ±ðÃû(service name)¡£
2¡¢ÔÚWIN2000»òÕßwin2003·þÎñÆ÷->¹ÜÀí¹¤¾ß->Êý¾ÝÔ´(ODBC)->
ϵͳDSN£¨±¾»úÆ÷ÉÏNTÓòÓû§¶¼¿ÉÒÔÓã©->Ìí¼Ó->ORACLE ODBC Driver->Íê³É->
data source name ¿ÉÒÔ×Ô¶¨Ò壬ÎÒÒ»°ãÌîORACLEÊý¾Ý¿âµÄsid±êÖ¾£¬
descriptionÀï¿ÉÒÔÌîORACLEÊý¾Ý¿âÏêϸÃèÊö£¬Ò²¿ÉÒÔ²»Ìî->
data source service name ÌîµÚ1²½¶¨ÒåµÄORACLEÊý¾Ý¿â±ðÃû->OK¡£
£¨Óû§DSNºÍÎļþDSNÒ²¿ÉÒÔÀàËÆÅäÖ㬵«Ê¹ÓõÄʱºòÓÐһЩÏÞÖÆ£©
3¡¢SQL ServerµÄµ¼ÈëºÍµ¼³öÊý¾Ý¹¤¾ßÀï->Ñ¡Êý¾ÝÔ´-> Êý¾ÝÔ´£¨ÆäËü£¨ODBCÊý¾ÝÔ´£©£©->
Ñ¡µÚ2²½ÔÚODBCÀﶨÒåµÄϵͳDSN source name£¬Óû§ÃûÃÜÂë´¦ÌîдORACLEϵͳµÄÓû§ÃûºÍÃÜÂë->
ÏÂÒ»²½->Ñ¡ÔñÄ¿µÄ£¬Ñ¡SQL ServerÊý¾Ý¿â£¨¸úÉÏÃæµÚ¶þµã½²µÄÒ»Ö£¬¾Í²»Öظ´ÁË£©¡£
×¢Ò⣺ÔÚORACLE±íºÍSQL Server±íÖ®¼ä'ת»»'ÄDz½ºÜÖØÒª£¬
¿ÉÒԸıäĬÈϵÄ×Ö¶ÎÊý¾ÝÀàÐÍ£¬Èçimage->text,decimal->int
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
C# code:
SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
ÎÒÓÃ.net¿ª·¢wapÍøÕ¾
1£¬ÎÒ´Ó¹¤¾ßÏäÀïÍÏÁËÁ½¸ölink£¬ÕâÁ½¸ölink»áÏÔʾÔÚÁ½ÐУ¬Èç¹ûÈÃÕâÁ½¸ölink´¦ÓÚͬһÐС£
2£¬ÈçºÎÏÔʾÁ½¸ö¿Ø¼þÖ®¼äµÄ¿Õ¸ñÎÊÌâ¡£
¸úwapÓйØÂ𣿲»Ì«Ã÷°×
ÓÑÇé°ï¶¥¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
¾Í ......
sqlserverµÄÊý¾Ý¿â£¬×Ö¶ÎÊÇimageÀàÐ͵ġ£Ôõôд´úÂ룬ÔÚÒ³ÃæÖеã»÷¡°ÏÂÔØ¡±¾ÍÄÜ´ò¿ªÄǸöÏÂÔØ¶Ô»°¿ò£¿
PS£ºOracleLob ÔÚsqlserverÀïÊÇʲô£¿
Response.Redirect("test.jpg")
ÒýÓÃ
Response.Redirect( ......