oracleÓë.netʱºò±¨´í
ÎÒÈ·¶¨£¬ÎÒoracleÀïÃæµÄÅäÖö¼ÊÇÕýÈ·µÄ£¨ÒòΪÎÒÓÃpb£¬plsql¶¼¿ÉÒÔÁ¬½ÓoracleÊý¾Ý¿â£©
µ«ÊÇÎÒÏë.netÀïÃæÁ¬½ÓoracleÊý¾Ý¿âµÄʱºò¾ÍÊDZ¨´í
ÎÒµÄÁ¬½ÓÎļþÊÇÕâÑùдÁ˵ģºProvider=OraOLEDB.Oracle;User ID=hwuser;Password=hw2001;Data Source=ora8;
ÎÒÊÇÕâÑùЩµÄ·ÃÎÊÊý¾Ý¿â·½·¨
static string oraConStr = ConfigurationSettings.AppSettings["oreConnection"];
/**
* Êý¾Ý¿âÖвéѯÓï¾äÖ´ÐÐ
*/
public DataSet QueryInfo(string sql)
{
DataSet ds = new DataSet ();
OleDbConnection olecon = new OleDbConnection(oraConStr);
OleDbDataAdapter oledba = new OleDbDataAdapter(sql, olecon);
oledba.Fill(ds);
return ds;
}
µ«ÊÇÔÚÎÒÖ´ÐÐ oledba.Fill(ds);µÄʱºò¾Í±¨´í:Óû§´úÂëδ´¦Àí£ºInvalidOperationException¡°Î´ÔÚ±¾µØ¼ÆËã»úÉÏ×¢²á¡°OraOLEDB.Oracle¡±Ìṩ³ÌÐò¡£¡±
Çë¸ßÊÖ°ïÖúÒ»ÏÂÈü£¬Ð»ÁË£¡£¡£¡
oracle¿Í»§¶Ë×°ÁËû£¿»¹ÓÐtnsname.oraÓÐûÓÐÕýÈ·µÄ·ÅÖÃÔÚÖ¸¶¨µÄλÖã¿
Data Source = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =(PROTOCOL = TCP)(HOST =·þÎñÆ÷Ãû)(PORT = ¶Ë¿ÚºÅ)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = Êý¾Ý¿âÃû))); User Id = Óû§Ãû; &nbs
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......