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=Êý¾Ý¿âÃû; ¼´¿ÉÁ¬½Ó³É¹¦¡£ÇëÎʼÙÈçÎÒÒªÁ¬½Ó¾ÖÓòÍøÖеÄһ̨·þÎñÆ÷£¬¶øÎÒ×Ô¼ºµÄµçÄÔ×÷
¿Í»§¶Ë£¬ÇëÎʿͻ§¶ËÕâ±ßÒªÔõô×ö£¿
Á¬½ÓµÄ·½Ê½ÊÇÄÄÖÖ£¿{{
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......
Çë¸÷λ¸ßÊÖ°ïæ oracleºº×ÖתƴÒô
±ÈÈçÏÖÔÚÓиöÁÐ ÀïÃæµÄºº×ÖΪÄãºÃ ÎÒÏë²é³öÀ´µÄÊÇN ÇëÎʸ÷λ¸ßÊÖÈçºÎʵÏÖ ¸ø¸öÏêϸµÄ¿´¿´ лÁË
ÓÐÖªµÀµÄ¸æËßÒ»Éù ллÁË
ûÕÒµ½°¡ Äܸø·¢Ò»¸öÂð
ÄÄλ˧¸çÄܸøÏêϸµÄËµÒ ......
¿ª·¢¹¤¾ßÊÇC#£¬Ð´µÄC/SģʽµÄ³ÌÐòʹÓÃORACLE OleDbµÄ·½Ê½Á¬½Óoracle 10GÊý¾Ý¿â£¬Õý³£²Ù×÷ûÎÊÌ⣬ֻҪһ·ÖÖÓ²»²Ù×÷£¬È»ºóÓ¦ÓóÌÐò¼ÌÐø¶ÔÊý¾Ý¿â²Ù×÷¾Í»á±¨³ö¡°Ã»ÓпÉÓõĴíÎóÐÅÏ¢£¬´íÎó´úÂ룺E_FAIL(0x80004005)¡±£¬Ê ......