Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Óëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

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 ......

Çë½ÌÒ»¸öoracle¹ÜÀíµÄÎÊÌ⣡ - Oracle / »ù´¡ºÍ¹ÜÀí

·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ