VBÓëoracleÊý¾Ý¿âÁ¬½ÓÎÊÌ⣬ÔÚÏßµÈ
ÎÒ×öÁËÒ»¸ö³ÌÐò£¬ÆäÖÐÓÐÁ¬½ÓORACLEÊý¾Ý¿âµÄ²¿·Ö£¬ÔÚͬһ̨»úÆ÷ͬһÌõ¼þÏÂÓÃÔ´´úÂëÁ¬½ÓÕý³££¬µ«Éú³ÉÖ´Ðз½Ê½Ö®ºóʲô¶¼Ã»ÓбäµÄÇé¿öϾÍÁ¬²»ÉÏÊý¾Ý¿âÁË£¬Çë¸÷λ°ïæ·ÖÎöÏÂÊÇʲôÔÒò£¿
ÕâÊÇÁ¬½ÓÊý¾Ý¿â²¿·ÖµÄ´úÂë
DLYHM = "USER ID=" + LSDLYHM
DLMM = "password=" + LSDLMM
DLSLM = "Data Source=" + LSDLSLM
LSsjk = DLYHM + ";" + DLMM + ";" + DLSLM
LSsjk = "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;" + LSsjk
Set LJSJK_SA = New ADODB.Connection
LJSJK_SA.Open LSsjk
ÔÚͬ»úÉÏÉú³ÉEXEÖ®ºó¾ÍÁ¬½Ó²»ÉÏÊý¾Ý¿âÁË
ÎÒ×öÁËERRµÄ´íÎóÅжϣ¬Õý³£Ê±µÄÖµÊÇ0,Á¬½Ó²»ÉÏÊý¾Ý¿âʱµÄÖµÊÇ-2147467259
ûÈË¿´Ï°ïæ·ÖÎöÏÂÔÒòÂð£¿
{{
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......