ORACLEÁ¬½Ó·½·¨ - VC/MFC / Êý¾Ý¿â
ÈçÏÂVC6²Ù×÷ORACLEÁ¬½Ó·½·¨Îª¿É±¨´í£º
_bstr_t connStr£»
connStr="Provider=OraOLEDB.Oracle;User ID=scott;Password=tiger;Data Source=192.168.0.120;";
m_SqlConn->Open(_bstr_t(connStr),(_bstr_t)_T(""),(_bstr_t)_T(""),adConnectUnspecified);
˵Ã÷£º
ÎҵĻú×ÓIPÊÇ192.168.0.120£¬ÎÒÏë×Ô¼ºÁ¬×Ô¼º£¬ÔÚÎҵı¾µØµçÄÔÖÐ×°ÁËORACLE£¬Ã»×°¿Í»§¶Ë¡£
ÕâÑùÁ¬½ÓÊÇ´íÎóµÄ¡£
ÏÖ¸ÄΪ
Data Source=Êý¾Ý¿âÃû; ¼´¿ÉÁ¬½Ó³É¹¦¡£ÇëÎʼÙÈçÎÒÒªÁ¬½Ó¾ÖÓòÍøÖеÄһ̨·þÎñÆ÷£¬¶øÎÒ×Ô¼ºµÄµçÄÔ×÷
¿Í»§¶Ë£¬ÇëÎʿͻ§¶ËÕâ±ßÒªÔõô×ö£¿
Á¬½ÓµÄ·½Ê½ÊÇÄÄÖÖ£¿{{
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
¿ª·¢¹¤¾ßÊÇC#£¬Ð´µÄC/SģʽµÄ³ÌÐòʹÓÃORACLE OleDbµÄ·½Ê½Á¬½Óoracle 10GÊý¾Ý¿â£¬Õý³£²Ù×÷ûÎÊÌ⣬ֻҪһ·ÖÖÓ²»²Ù×÷£¬È»ºóÓ¦ÓóÌÐò¼ÌÐø¶ÔÊý¾Ý¿â²Ù×÷¾Í»á±¨³ö¡°Ã»ÓпÉÓõĴíÎóÐÅÏ¢£¬´íÎó´úÂ룺E_FAIL(0x80004005)¡±£¬Ê ......
OracleÖÐSQLÓï¾äÖÐ
drop table ±íÃû cascadeconstraints
Óë
drop table ±íÃû cascadeconstraint
ÓÐÊ²Ã´Çø±ð£¿
constraintºÍconstraintsÔÚoracleÖÐÊÇÒ»ÑùʹÓõÄ
¹Ù·½½¨ÒéʹÓÃconstraint
ÒýÓÃ
constraintºÍc ......