vc Á¬½ÓoracleÊý¾Ý¿â - VC/MFC / Êý¾Ý¿â
bool CMcchangeportApp::ConnectDateBase()
{
try
{ m_pConnection.CreateInstance(__uuidof(Connection));
m_pConnection->Open("Provider=MSDAORA.1;Data Source=WE8;","hj","014",adModeUnknown);
}
catch(_com_error &e)
{
CString err;
err.Format("%s", (char*)(e.Description()) );
AfxMessageBox(err);
return false;
}
catch(...)
{
AfxMessageBox("Unknown Error...");
return false;
}
return true;
}
ÕâÊÇÁ¬½Óº¯Êý,
C/C++ code:
bool CMcchangeportApp::p_delJDK_exes(_RecordsetPtr &ADOSet,_variant_t &tran_no,_variant_t &exestypid,_variant_t &tranexesno,_variant_t &exec_re)
{
if ( ADOSet->State == adStateOpen) ADOSet->Close();
try
{
_CommandPtr pCmdChange = NULL;
_ParameterPtr param;
param.CreateInstance(__uuidof(Parameters));
pCmdChange.CreateInstance(__uuidof(Command));
pCmdChange->CommandType = adCmdStoredProc;
pCmdChange->CommandText = "commpackages.p_delJDK_exes";
//adVarChar,adInteger,adNumeric
//sizeof(double)
param=pCmdChange->CreateParameter((_bstr_t)"tran_no",adVarChar,adParamInput,11,_variant_t(tr
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......