ÐÂÊÖÇë½ÌOracleÁ¬½ÓÎÊÌ⣡ - Oracle / »ù´¡ºÍ¹ÜÀí
±¾ÈËÊÇÒ»ÐÂÊÖ¼æ²ËÄñ£¬Ïò¸ßÈËÇë½ÌÏÂADOµÄOracleÁ¬½ÓÎÊÌ⣬лÁË£¡
ǰÆÚ´¦Àí£º
import "c:\program files\common files\system\ado\msado15.dll" \
no_namespace \
rename ("EOF", "adoEOF")
_ConnectionPtr m_pConnection;
ÕâÀïÓ¦¸ÃûÓÐÎÊÌâ°É
void COHDCXDlg::ConnectDB()
{
CoInitialize(NULL);
try
{
m_pConnection.CreateInstance(__uuidof(Connection));
m_pConnection->Open("Provider=OraOLEDB.Oracle.1;Password=manager;User ID=system;Data Source=oradb;Persist Security Info=True","","",adModeUnknown);
}
catch(_com_error e)
{
CString errormessage;
errormessage.Format("Êý¾Ý¿âÁ¬½Óʧ°Ü£¡\r\n´íÎóÐÅÏ¢£º%s", e.ErrorMessage());
AfxMessageBox(errormessage);
}
}
Ö´ÐкóÀÏÊÇÌáʾ£ºÊý¾Ý¿âÁ¬½Óʧ°Ü£¡
ÎÒµÄÊý¾Ý¿â¾ÍÊÇͨ¹ýsqlplus½¨µÄ¼¸¸ö¼òµ¥±í£¬system£¬manager£¬oradbÊÇsqlplus½çÃæµÇ½ʱµÄÊäÈëÏî¡£
ÁíÍ⣬ÄÜ·ñ¸æÖªOpen()º¯ÊýµÄ²ÎÊý¾ßÌåÖ¸Êý¾Ý¿âÖеÄʲô£¿
µ«ÊÇ£¬system¾ÍÊÇsqlplusµÄÓû§Ãû
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......