vb Á¬½ÓORACLE ´òÓ¡

ÕâÊÇÎÒÔ­À´Á¬½ÓSQLµÄ´òÓ¡µÄ´úÂë
Connection1.Open "Provider=MSDataShape.1;Persist Security Info=True;Data Source=mm;User ID=sa;Password=sa;Initial Catalog=lc-liuh2;Data Provider=SQLOLEDB.1"ÊÇ¿ÉÒÔµÄ
ÏÖÔÚÏë¸Ä³ÉÁ¬½ÓORACLE
Connection1.Open "Provider=MSDataShape.1;Persist Security Info=True;User ID=PATROL;Password=PATROL;Data Source=MYORACLE;Data Provider=MSDAORA.1"»òÕß
Connection1.Open "Provider=MSDataShape.1;Persist Security Info=True;User ID=PATROL;Password=PATROL;Data Source=MYORACLE;Data Provider=OraOLEDB.Oracle.1"
Á½¸ö¶¼Ã»Óа취Á¬½ÓÉÏ,ÏëÎÊÏÂÓ¦¸ÃÔõôÁ¬½Ó,ÎÒÊý¾ÝÒѾ­Á¬½ÓÉÏÁË,²éѯ,ɾ³ý,Ð޸Ķ¼ÊÇûÓÐÎÊÌâ,µ«ÊÇ´òÓ¡ÐèÒª¼ÓProvider=MSDataShape.1À´×öһЩ¹¦ÄÜ

---

Persist Security Info=False ÊÔÊÔ¡£
½«¼¸¸ö Provider Öеİ汾ºÅ .1 È¥µôÊÔÊÔ¡£

---

°´ÕÕÄã˵µÄÊÔÁ˼¸ÖÖÇé¿ö¶¼²»ÐÐ

---

ÕâÑùÊÔ
Provider=MSDataShape.1;Persist Security Info=False;Data Provider=MSDAORA;Data Source=orac;User Id=myUsername;Password=myPassword;

---

È·¶¨Oracle¿Í»§¶ËµÄÇý¶¯°²×°ÁË£¿½ÚµãÒ²ÅäÖÃÁË£¿

Æäʵ Oracle ÓÐ×Ô¼ºµÄµÝ¹é²éѯÓï·¨SQL code:
[ START WITH condition ]
CONNECT BY [ NOCYCLE ] condition

---

¶ÔORACLE²»ÊǺÜÁ˽⡣·¢ÏÖÖ±½ÓÔÚ³ÌÐòÁ¬½ÓºÃÖ®ºóÄÇÑùÀ´×öÊÇ¿ÉÒԵġ£
ÔÚPrivate Sub DataEnvironment_Initialize()Öн«CONNECTSTRING´ò³öÀ´Ö®ºóµÃµ½µÄ½á¹ûÊÇ:
Provider=MSDataShape.1;Persist Secur