visual c#ÎÞ·¨Á¬½Óoracle£¿£¿£¿
´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£
ÆäÖÐÊý¾Ý¿âÊÇÅäÖúÃÁ˵ģ¬ÒòΪÓÃSQL developer¿ÉÒÔ·ÃÎʵ½Êý¾Ý¿â
»¹Çë´óÏÀÃÇ°ïæ½â¾öÏÂÎÊÌâ
Ò»°ãÊÇ·ÅÔÚʲôλÖõÃѽ£¿
ÎÒ¿´¹ýÁËÓа¡~~~
ÊÇÔÚÒýÓÃÖÐOracle.DataAccessÎÞ·¨ÓëC:\oracle\product\10.1.0\Db_1\BIN\Oracle.DataAccess.dllÁ¬½Ó£¬É¾³ýºóÖØÐÂÌí¼ÓÒýÓü´¿É£¡
¹þ¹þ¹þ£¬Work it out myself!
΢ÈíµÄ²úÆ·Óë·Ç΢ÈíµÄ²úÆ·½áºÏ×ÜÊÇ´æÔÚÎÊÌâµÄ....Õâ¾ÍÊǾºÕù
Äã°²×°ÁËODACÁËÂð?ÊÇOracleµÄ²»ÊÇ΢ÈíµÄ
Äã°ÑÒýÓÃÎļþµÄ·¾¶ÐÞ¸ÄÁË¡£
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}
Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£
ÒýÓÃ
try
{
connection.connect( ......
£¨1£©string ConnString = "server=localhost;integrated security=sspi;database=pubs;";
£¨2£©string strConnection="user uid=sa;pwd=123456;Database=test;Server=test;Connect ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......