¹òÇó C#.net ODBCÔÚOracleÊý¾Ý¿âÖд´½¨±í
¸÷λ´óÏÀ£¬Ð¡ÃÃÏëÓà C#.net ODBCÁ¬½Ó ÔÚOracleÊý¾Ý¿âÖд´½¨±í£¬Çë´ó¼Ò°ïæһÏÂÌØ¼±£¡£¡
ÁíÍâÎÒÓÐдÁË´úÂë¿É×ÜÊDZ¨´í,´ó¼Ò°ïÎÒ¿´Ò»Ï£¡create±íµÄÓï¾äÔÚoracleµÄ¹¤¾ßÖÐÖ´ÐпÉÒÔ£¬µ«ÊÇÔÚÏÂÃæµÄ´úÂëÖÐÖ´Ðб¨
¡±[Microsoft][ODBC driver for Oracle][Oracle]ORA-00955: Ãû³ÆÒÑÓÉÏÖÓжÔÏóʹÓᰵĴíÎó
ÎÒÓõÄÊÇDNSÁ¬½ÓÊý¾Ý¿â
public bool ChkTable(string TableName) //¼ì²é±íÊÇ·ñ´æÔÚ
{
string sql = "";
OdbcConnection OdbcConn = new OdbcConnection(sConn);
OdbcCommand cmd = new OdbcCommand("", OdbcConn);
try
{
OdbcConn.Open();
sql = "SELECT COUNT(TABLE_NAME) * from USER_TABLES";
sql += " WHERE TABLE_NAME='" + TableName.ToUpper() + "' ";
cmd.CommandText = sql;
oResult= cmd.ExecuteNonQuery();
}
catch
&
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÄÚÈÝÈçÌâ¡£¡£ÔÚC#Àï¸ÄÈçºÎÐ´ÄØ£¿
±¾À´Ë¼Â·ÊÇÏȱȶԽڵãÃû³Æ£¬ÈçÊǵϰ¾Í±£´æÒªÉ¾³ý½ÚµãµÄϱê·ÅÔÚÊý×éÀȻºóÑ»·É¾³ý£¬µ«·¢ÏÖ¡£¡£µ±ÎÒɾ³ýµÚÒ»¸öºó£¬ËùÓнڵãϱêÊýÁ¿¶¼·¢Éú¸Ä±ä¡£¡£
¾Í²»ÄÜÔÙ°´ÕÕ֮ǰ¼Í¼µÄ½Úµã ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......