Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

QTPÁ¬½Óoracle²¢²Ù×÷Êý¾Ý¿âµÄ·½·¨

QTPÁ¬½Óoracle²¢²Ù×÷Êý¾Ý¿âµÄ·½·¨ÕâÀïÒÔoracle  9iΪÀý×Ó£¬ÆäËûµÄÊý¾Ý¿âÁ¬½Ó·½·¨ÊÇÏàͨµÄ¡£
a.Ê×ÏÈÒªÔÚ±¾»ú½¨ÒéODBCÊý¾ÝÔ´£¬Õâ¸öÊôÓÚ»ù±¾²Ù×÷£¬ÕâÀï²»½²£¬Ìø¹ý£»
b.»ñÈ¡oracleµÄÁ¬½Ó´®µÄ·½·¨£¬ÔÚ±¾µØÐ½¨Ò»¸ö.txtÎļþ£¬ÐÞ¸ÄÀ©Õ¹ÃûÃû*.udl£¬Ë«»÷*.udlÎļþ£¬´ò¿ªÊý¾Ý¿âÁ´½ÓÊôÐÔ£¬¶¨Î»µ½“Ìṩ³ÌÐò”Ñ¡ÏÔ¿¨£¬Ñ¡ÖÐ oracleµÄÁ¬½Ó  oracle provider for OLE DB,µã»÷ÏÂÒ»²½£¬ÊäÈëÊý¾ÝÔ´£¬Êý¾Ý¿âÓû§ÃûÒÔ¼°ÃÜÂ룬µã»÷²âÊÔÁ¬½Ó£¬È»ºóÓÃUE»ò¼Çʱ¾´ò¿ª*.udlÎļþ£¬oracleµÄÁ¬½Ó´®ÒѾ­Éú³ÉÁË£¬ÀýÈç
Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=test;Data Source=192.168.13.19
ÒÔÉϾÍÊÇudlÎļþÉú³ÉµÄoracleÁ¬½Ó´®
ÏÖÔÚÎÒÃÇÐèÒªÊÖ¶¯Ìí¼ÓÒ»¸öoracleÁ¬½Ó´®µÄÃÜÂë×Ö¶ÎPassword£¬²åÈëµ½User IDºóÃæ£¬ÖмäÓ÷ֺŸô¿ª£»
¼´ Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=test;;Password=test;Data Source=192.168.13.19
c.ÔÚqtpÖÐÀ´Á¬½ÓÊý¾Ý¿â
Dim Cnn  '¶¨ÒåÒ»¸öÊý¾Ý¿âÁ¬½Ó´®
Set Cnn = CreateObject("ADODB.Connection")
Cnn.ConnectionString ="Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=test;Password=test;Data Source=192.168.13.19 "
Cnn.Open   '´ò¿ªÊý¾Ý¿âÁ¬½Ó
If Cnn.State = 0 Then      'ÅжÏÊý¾Ý¿âÁ¬½ÓÊÇ·ñ³É¹¦
     Reporter.ReportEvent micFail, "testing", "Á¬½ÓÊý¾Ý¿âʧ°Ü"
else
     Reporter.ReportEvent micPass, "testing",   "Á¬½ÓÊý¾Ý¿â³É¹¦"
End If
 
if Cnn.State<> 0  then
  
    Set Rs=CreateObject("ADODB.Recordset")    'Éú³É¼Ç¼¼¯¶ÔÏó
 strsql ="Select  *    from t_sys_user"   '´ÓÊý¾Ý¿âÖвéѯt_sys_userµÄËùÓмǼ
        Rs.Open strsql ,Cnn,1,3   'Ö´ÐÐsqlÓï¾ä£¬¼Ç¼¿ÉÒÔ×ÔÓÉÒÆ¶¯£¬µ¥Êý¼Ç¼´¦ÓÚÖ»¶Áģʽ
        ydl=Rs("USER_ID")         'È¡µÃ×Ö¶ÎΪUSER_IDµÄ¼Ç¼£¬Óα궨ÒåÔÚµÚÒ»ÐУ¬ËùÒÔÈ¡µÃµÄÊǸÃ×Ö¶ÎËùÔÚÐеĵÚÒ»ÐÐÊý¾Ý
 msgbox  ydl
    &nbs


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracle sqlplus Óëdos ÖÐÎÄÂÒÂë

1.SQL> select * from v$nls_parameters;
PARAMETER                           VALUE
----------------------------------- ------------------------------------
---------- ......

OracleÊý¾Ý¿âµÄÓÅ»¯Éè¼Æ

[ÕªÒª]Ö÷Òª´Ó´óÐÍÊý¾Ý¿âORACLE»·¾³Ëĸö²»Í¬¼¶±ðµÄµ÷Õû·ÖÎöÈëÊÖ£¬·ÖÎöORACLEµÄϵͳ½á¹¹ºÍ¹¤×÷»úÀí£¬´Ó²»Í¬·½Ãæ½ÏÈ«ÃæµØ×ܽáORACLEÊý¾Ý¿âµÄÓÅ»¯µ÷Õû·½°¸¡£
[¹Ø¼ü´Ê]ORACLEÊý¾Ý¿â¡¢»·¾³µ÷Õû¡¢ÓÅ»¯Éè¼Æ¡¢·½°¸
ÖÐͼ·ÖÀàºÅ£ºTP3 ÎÄÏ×±êʶÂ룺A ÎÄÕ±àºÅ£º1671£­7597(2008)0720043£­01
¡¡¡¡
¡¡¡¡ORACLEÊý¾Ý¿âÖÐÊý¾Ý´æÈ¡ÐÔÄ ......

²é¿´oracleµÄϵͳÎļþÄÚÈÝ

ÔÚÃüÁî¸ñʽÏ£¬½øÈësqlplusµÄ±à¼­×´Ì¬ÖÐ
 
£¨1£©²é¿´¿ØÖÆÎļþµÄÄÚÈÝ£º
SQL> DESC v$controlfile
 Ãû³Æ                               &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ