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

adoÁ¬½ÓoracleµÄ¹ÖÎÊÌâ

ÒÔǰ³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
        ::CoInitialize(NULL);
        hr=m_pConnection.CreateInstance(__uuidof(Connection));
        if   (SUCCEEDED(hr))
            MessageBox( "ok ");
        else
            MessageBox( "bad ");
        m_pConnection-> Open( "Provider=MSDAORA.1;Data   Source=abc; ", "eval ", "eval123 ",adModeUnknown);
}
catch   (_com_error   e)
{
        AfxMessageBox(e.ErrorMessage());
        AfxMessageBox( "Êý¾Ý¿âÁ¬½Ó²»³É¹¦! ");
}
½á¹ûÏÈÏÔʾok,È»ºó¾ÍÊÇ "δָ¶¨µÄ´íÎó "ºÍ "Êý¾Ý¿âÁ¬½Ó²»³É¹¦! "
Ö÷Òª»³ÒÉm_pConnection-> Open( "Provider=MSDAORA.1;Data   Source=abc; ", "eval ", "eval123 ",adModeUnknown);
µ«ÒÔǰ¶¼ÊǺúõİ¡,Ææ¹ÖÁË,Íû°ïæ½â¾ö,ÏÈлÁË
²éÒ»ÏÂÊý¾ÝÔ´¡£³ÌÐò±¾Éíû´í

Ê×ÏÈÄãÓÐûÓн¨Á¢abcÊý¾ÝÔ´°¡,
ÏÈͨ¹ýODBC²âÊÔÒ»ÏÂÄãµÄÊý¾ÝÔ´Á¬½ÓÊÇ·ñÕý³£

ÊDz»ÊÇÄã˵µÄÄǾ仰¸ñʽÓÐÎó£¬ÊDz»ÊǶàÁ˿ոñʲôµÄ

ÀÏ´ó,Äã½²µÄ½¨Á¢abcÊý¾ÝÔ´ÊÇʲôÒâ˼°¡
ÓÃadoÁ¬½Ó²»ÒªÔÚodbcÀïÃæÉèÖõİ¡
ÍûÖ¸½Ì


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

Ò»Ä깤×÷¾­Ñ飬ÊìϤoracleÖ麣ÕÒ.net¹¤×÷Òª¶àÉÙ¹¤×Ê£¿

ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼

Ö麣ÄDZßËÆºõûÉîÛÚºÃ.

Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......

½èˮԴÈËÆø£¡oracle jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

¹òÇó lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......

imp µ¼Èë oracle ÎÊÌâ

µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£

ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º

IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ