Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÀïÃæÉèÖõİ¡
ÍûÖ¸½Ì


Ïà¹ØÎÊ´ð£º

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö

ÒýÓÃ
            vStream := TMemorySt ......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

Oracle¿Í»§¶Ë°²×°ºóODBCÎÞ·¨Ê¹ÓÃ

°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......

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

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

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

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

sqlplusÁ¬½ÓoracleÊý¾Ý¿âÔ­Àí£¿

sqlplusÁ¬½ÓOracleÊý¾Ý¿âµÄÕû¸öÁ÷³Ì£¬
ÀýÈç sqlplus /nolog
    conn system/oracle£¨ÃÜÂ룩

Õâ¸öÁ¬½ÓOracleµÄÕû¸ö»úÖÆÊÇʲô£¨×¢ÖØÓÚÁ¬½ÓµÄÔ­ÀíÉÏ£©

Èç¹ûÓÐË­¶®»òÓÐÏà¹ØÄÚÈݸøÓèÌáÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ