Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÐÂÊÖÇë½Ì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()º¯ÊýµÄ²ÎÊý¾ßÌåÖ¸Êý¾Ý¿âÖеÄʲô£¿

ÒýÓÃ
m_pConnection->Open("Provider=OraOLEDB.Oracle.1;Password=manager;User ID=system;Data Source=oradb;Persist Security Info=True","","",adModeUnknown);



Password: ÃÜÂë
User ID£ºÓû§Ãû
Data Source£º¡¡¼àÌýÖеġ­¡­

µ«ÊÇ£¬system¾ÍÊÇsqlplusµÄÓû§Ãû


Ïà¹ØÎÊ´ð£º

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

javaÁ¬²»ÉÏoracle£¿ - Java / Java EE

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ