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 not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html
Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..
cm ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......
Óиö´æ´¢¹ý³ÌÓÐÈý¸öInt²ÎÊýºÍÒ»¸öOut²ÎÊý.
Ö´ÐÐʱÏȽ«Ò»Ð©Êý¾Ý²åÈëµ½Ò»¸ö±íÖÐ.È»ºóÔÙ´Ó±íÖÐÈ¡³öÊý¾Ý½øÐÐÐÐתÁÐ,ºÏ¼ÆµÈÂß¼.½«´¦Àí½á¹û·Åµ½Ò»¸ö±íÖÐ.²¢½«Idͨ¹ýOut²ÎÊý·µ»Ø.
µ«ÔÚÖ´ÐÐʱ¿ÉÒÔ»ñÈ¡µ½OutÖµ,µ«¾ÍÊÇà ......
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......