ÓÃVBÈçºÎ·ÃÎÊoracleÖеÄblob×ֶΣ¿
ÎÒÐèÒªÓÃVBÁ¬½ÓOracle²¢ÏÂÔØblo£â×ֶΣ¬
ÎÒÓÃÒÔÏÂÁ¬½Ó·½Ê½£¬³ÌÐòʼÖÕ²»ÄÜʶ±ð£â£ì£ï£â×ֶΣ¬
connStr = "Provider=msdaora;Persist Security Info=False;User ID=" & _
uid & ";Password=" & pwd & ";Data Source=" & dbname
££££££££££££££££££££££££££££££££££££££££
µ«µ±ÎÒÓÃÒÔÏ·½Ê½Á¬½Óʱ£¬³ÌÐò¿ÉÒÔʶ±ðblo£âÀàÐ͵Ä×ֶΣ¬
connStrTemp = "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=" & _
uid & ";Password=" & pwd & ";Data Source=" & dbname
ËùÒÔÎÒ¾õµÃÈç¹ûÏëʶ±ð¸ÃÀàÐ͵Ä×ֶΣ¬¾ÍÖ»ÄÜÓÃProvider=OraOLEDB.Oracle.1ÕâÖÖÁ¬½Ó·½Ê½
µ«Êý¾Ý¿âÊÇÎÒµçÄÔ±¾µØÉÏ×°×ŵ쬳ÌÐòÒ²ÔÚÎÒµçÄÔÉÏÔËÐУ¬ÕâÑù×ÓûÎÊÌ⣬µ«µ±°Ñ³ÌÐò°²×°ÔÚÆäËûµçÄÔÉϺ󣬾Ͳ»Äܳɹ¦Á¬½ÓÎÒµÄÊý¾Ý¿âÁË£¨Ê¹ÓÃProvider=msdaora¿ÉÒÔÁ¬½Ó£¬È´²»ÄÜʶ±ðblo£â×ֶΡ££©
ÔÚÆäËûµçÄÔÉÏÔËÐÐʱ¾Í²»ÄÜ·ÃÎÊÊý¾Ý¿âÄØ£¬ÎÒÔÚÍøÉÏËÑÁËËÑ£¬´ó¸ÅÓÐÒÔϼ¸¸ö½â¾ö·½°¸£º
£¨1£©°²×°¿Í»§¶Ë£¬µ«¿Í»§¶ËʵÔÚÊÇÌ«´óÁË£¬±È½ÏÂé·³£¬
£¨2£©°²×°¸öÈËÖÆ×÷µÄ¾«¼ò°æ¿Í»§¶Ë£¬²»¹ýÒ²¾õµÃͦÂé·³µÄ£¬
£¨3£©½«oracleÖеÄÔÎļþÌáÈ¡³öÀ´£¬´ò°ü½ø³ÌÐò°²×°°üÖС£
ÎÒ²ÉÓõÄÊǵÚÈýÖÖ·½°¸£¬µ«µ±²ÉÓõÚÒ»ÖÖÁ¬½Ó·½Ê½Ê±²»´æÔÚÎÊÌ⣬µ«²ÉÓõڶþÖÖÁ¬½Ó·½Ê½Ê±£¬È´ÌáʾÁ¬½Ó´íÎ󣬸ü²»ÓÃ˵¶ÁÈ¡blob×Ö¶ÎÁË£¬ËùÒÔÎÒ¾õµÃ¿ÉÄÜÊÇһЩdllÎļþûÓÐÏòϵͳע²á£¬
µ«ÔËÐУºregsvr
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÐèÒªÓö¨Ê±Ö´Ðд洢¹ý³Ì£¬µ«ÊÇÎҵĴ洢¹ý³ÌÀïÓõ½µÄ±íÊÇÓÐÁ´½ÓµÄ£¬¾ÍÏñÕâÑù£º
.....from table_name@cxdb_link
Ò²¾ÍÊÇÎÒ½¨Á¢¶¨Ê±Æ÷µÄÊý¾Ý¿âÓë±íËùÔÚµÄÊý¾Ý¿â²»ÊÇÒ»¸ö¿â£¬£¨ÒòΪ±íËùÔÚµÄÊý¾Ý¿âÎÒûÓÐȨÏÞ½¨Á¢¶¨Ê ......