ASP.NETÅäÖÃOracleµÄÏà¹ØËµÃ÷
² Oracle9iµÄ°²×°£¬Çë²ÎÕÕ¹Ù·½µÄ°²×°ËµÃ÷¡£
² Oracle9i°²×°³É¹¦ÒÔºó£¬Ê¹ÓùÜÀíÔ±£¨Óû§Ãû£ºsys¡¢ÃÜÂ룺sys£©µÄÉí·ÝµÇ¼½øÈ¥£¬´´½¨Ò»¸öÓû§ddymis£¬ÃÜÂ룺ddymis,½ÇɫĬÈϸ³Óèdba¡£
² Oracle9i°²×°³É¹¦ÒԺ󣬾ßÌåµÄȨÏÞÉèÖÃÈçÏ£º
1. ÒÔAdministratorȨÏ޵ǼWindows.
2. Æô¶¯Window ×ÊÔ´ä¯ÀÀÆ÷ÕÒµ½ORACLE_HOMEĿ¼£¬ÈçC:\Oracle\ora92
3. ÓÒ¼üµ¯³ö²Ëµ¥£¬Ñ¡Ôñ¸ÃĿ¼¹²ÏíÓ밲ȫ£¨Win2000ÏÂÒªµã»÷ÊôÐÔ£©
4. µã»÷ “°²È«” ҳǩ
5. ÔÚ×éºÍÓû§Ãû³ÆÁбíÖеã»÷“Authenticated Users” Ïî.
6. ÔÚ¸ÃÓû§µÄȨÏÞÁбíÖУ¬½«“¶ÁÈ¡ºÍÔËÐДµÄÑ¡Ôñ¿òÖÃΪ²»Ñ¡ÖÐ״̬
7. Ôٴεã»÷“¶ÁÈ¡ºÍÔËÐДµÄÑ¡Ôñ¿ò£¬½«ÆäÉèÖÃΪѡÖÐ״̬
8. µã»÷“¸ß¼¶”°´Å¥²¢ÔÚȨÏÞÏîÄ¿ÖÐÈ·¶¨“Authenticated Users” ÊÇ·ñÓµÓГ¶ÁÈ¡²¢ÔËÐДȨÏÞ²¢Ó¦ÓÃÓÚ“¸ÃÎļþ¼Ð£¬¼°×ÓÎļþ¼ÐºÍÎļþ”. Èç¹û²»ÊÇ£¬Ë«»÷ÕâÑù£¬²¢È·±£È¨ÏÞ¿ÉÒÔ“Ó¦ÓÃÓÚ” “¸ÃÎļþ¼Ð£¬¼°×ÓÎļþ¼ÐºÍÎļþ”. ¸ÃÏî·Ç³£ÖØÒªÄãÒ»¶¨ÒªºË²é.
9. µã»÷“È·¶¨” °´Å¥
10. Windows.ÖØÆô¶¯, ÒÔʹµÃËùÓеÄÐÞ¸ÄÉúЧ.
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/daichenghua/archive/2009/10/17/4687645.aspx
Ïà¹ØÎĵµ£º
OracleÊý¾Ý¿âÊÇÒ»ÖÖ´óÐ͹ØÏµÐ͵ÄÊý¾Ý¿â£¬ÎÒÃÇÖªµÀµ±Ê¹ÓÃÒ»¸öÊý¾Ý¿âʱ£¬½ö½öÄܹ»¿ØÖÆÄÄЩÈË¿ÉÒÔ·ÃÎÊÊý¾Ý¿â£¬ÄÄЩÈ˲»ÄÜ·ÃÎÊÊý¾Ý¿âÊÇÎÞ·¨Âú×ãÊý¾Ý¿â·ÃÎÊ¿ØÖƵġ£DBAÐèҪͨ¹ýÒ»ÖÖ»úÖÆÀ´ÏÞÖÆÓû§¿ÉÒÔ×öʲô£¬²»ÄÜ×öʲô£¬ÕâÔÚOracleÖпÉÒÔͨ¹ýΪÓû§ÉèÖÃȨÏÞÀ´ÊµÏÖ¡£È¨ÏÞ¾ÍÊÇÓû§¿ÉÒÔÖ´ÐÐijÖÖ²Ù×÷µÄȨÀû¡£¶ø½ÇÉ«ÊÇΪÁË·½±ãDBA¹Ü ......
<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"\@ËÎÌå" ......
1£¬SqlServer´æ´¢¹ý³ÌµÄÊÂÎñ´¦Àí
Ò»ÖֱȽÏͨÓõijö´í´¦ÀíµÄģʽ´ó¸ÅÈçÏ£º
Create procdure prInsertProducts
(
@intProductId int,
@chvProductName varchar(30),
@intProductCount int
)
AS
Declare @intErrorCode int
Select @intErrorCode=@@Error
Begin transaction
if @intError ......
ASP.NETÖ¸ÁîÔÚÿ¸öASP.NETÒ³ÃæÖж¼ÓС£Ê¹ÓÃÕâЩָÁî¿ÉÒÔ¿ØÖÆASP.NETÒ³ÃæµÄÐÐΪ¡£ÏÂÃæÊÇPageÖ¸ÁîµÄÒ»¸öÀý×Ó£º
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb"
Inherits="_Default" %>
ÔÚASP.NETÒ³Ãæ»òÓû§¿Ø¼þÖÐÓÐ11¸öÖ¸Áî¡£ÎÞÂÛÒ³ÃæÊÇʹÓúǫ́±àÂëÄ£ÐÍ»¹ÊÇÄÚÖñ ......