ÇóvbÔ¶³ÌÁ¬½ÓoracleÊý¾Ý¿âµÄ³ÌÐò
ÎÒÓиöС³ÌÐò£¬ÐèÒª´Óµ¥Î»µÄoracleÊý¾Ý¿âÖжÁÈ¡Êý¾Ý£¬µ«ÊDz»ÖªµÀ¸ÃÔõôд£¬Çë¸÷λ¸ßÊÖÖ¸µã£¬×îºÃÓÐʵÀý£¬»òÔ´³ÌÐò¡£Ð»Ð»ÁË
http://www.connectionstrings.com/oracle
¶¥Æð
Á¬¿â
Dim DLYHM, DLMM, DLSLM As String
Dim Grecordset As New ADODB.Recordset
Dim Gconnection_HQ As New ADODB.Connection
DLYHM = "USER ID=" + Óû§Ãû
DLMM = "password=" + µÇ¼ÃÜÂë
DLSLM = "Data Source=" + DBCSÖеÄʵÀýÃû
LSsjk = DLYHM + ";" + DLMM + ";" + DLSLM
LSsjk = "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;" + LSsjk
Set Gconnection_HQ = New ADODB.Connection
Gconnection_HQ.Open LSsjk
¶ÁÊý¾Ý
Set Grecordset = New ADODB.Recordset
Grecordset.Open "select * from ±íÃû where ×Ö¶ÎÃû='" & ×Ö¶ÎÖµ & "'", Gconnection_HQ, adOpenStatic, adLockOptimistic ¡®Ë÷ÒýÌõ¼þ
±äÁ¿ = Trim(Grecordset.Fields("¶ÁÈ¡×Ö¶ÎÃû"))
Grecordset.Close
Äܲ»ÄܰÑÔ´³ÌÐò·¢¸øÎÒ°¡£¬ÎÒµÄÓÊÏ䣬Èç¹û³É¹¦ÂíÉϸøÄã½á·Ö£¬Âé·³ÁË£¬Å¼ÏÈллÁË£¡
ustbzhy@163.com£¬Ð»Ð»
×Ô¼º¸ù¾Ý´úÂë¸ÄһϾͿÉÒÔÁË£¬²»ÒªÊ²Ã´¶¼ÒªÔ´´úÂ룬ÔÛÃÇÖ®¼äÓõĸ÷ÖÖÐÅÏ¢¶¼²»Ò»Ñù£¬¸øÄãÒ²µÃ×Ô¼º¸Ä
ÐèÒª°²×°oracel¿Í»§¶Ë
oracle¿Í»§¶Ë×°ÉÏÁË£¬µ«ÊÇÓ¦¸ÃÈçºÎÅäÖÃÄØ
×îºÃ½
Ïà¹ØÎÊ´ð£º
ÏëÔÚwarcraft3Àï½øÐÐдÆÁ²Ù×÷¡¾Èç¶Ôսƽ̨ÖеÄʤ¸ºÌáʾÐÅÏ¢¡¿£¬Ð§¹û¾ÍÏñÓÎϷƽ̨ÖÐÒ»Ñù£¬ÎÒÊÔ¹ýÔÚÒ»´°¿ÚÖÐдÈëÎÄ×Ö£¬È»ºóÒ»Ö±Èô°¿ÚÇ¿ÖÆ×îǰ£¬ËäÈ»ÄÜʵÏÖÎÄ×ÖÏÔʾ£¬µ«ÊÇÎÄ×ֻ᲻¶ÏÉÁ˸£¬¶øÇÒÓв»È·¶¨BUG£¬Í¨¹ýÂÛ̳ËÑ ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......
ÎÒÊÇVBµÄгÉÔ±£¬ÏÖÔÚÏëÓÃVBÀ´×ö¸öTXTÎĵµ£¬Çë´ó¼Ò¸øÎÒ´úÂë¼°½éÉÜÒ»ÏÂÏàÓ¦µÄ¿Ø¼þ£¡
·Ç³£¸Ðл£¡£¡£¡£¡£¡£¡
¿ÉÒÔÓÃһЩOFFICE¿Ø¼þ
googleÉÏÕÒһϰÉ,VBдÈëTXT,ºÜ¶àÑùÀý´úÂëµÄ
Ö±½Óµ÷²éÓþͿÉÒÔÁË
Ãæ¶ÔÃÀÅ® ......