¹òÇó 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 ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......