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

oracleÁ¬½Ó×Ö·û´®ÎÊÌ⣿

  OracleConnection oledbCon = new OracleConnection("Data Source = zghouseDB; User Id = scott; Password = oracle; Integrated Security = no;");
            if (oledbCon.State == ConnectionState.Closed)
            {
                oledbCon.Open();
                if (oledbCon == null)
                {
                    MessageBox.Show("odbcÊý¾Ý¿âÁ¬½Óʧ°Ü", "ϵͳÌáʾ");
                }
            }
            return oledbCon;

ÔÚÖ´ÐÐoledbCon.Open();Õâ¾äµÄʱºò±¨´í£¬ÀàÐÍΪ£ºORA-12154: TNS: ÎÞ·¨½âÎöÖ¸¶¨µÄÁ¬½Ó±êʶ·û
Çë°ï°ï棡
ORA-12154  ÕâÊǸö±È½Ï³£¼ûµÄ´íÎó¡£Äã´ò¿ª¼àÌý·þÎñ¿´¿´

# listener.ora Network Configuration File: F:\oracle\product\10.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = F:\oracle\product\10.1.0\db_1)
      (PROGRAM = extproc)
    ) <


Ïà¹ØÎÊ´ð£º

OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......

imp µ¼Èë oracle ÎÊÌâ

µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£

ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º

IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......

ORACLE°²×°ÎÊÌâ

oracle°²×°Ê±£¬ÔÚ½øÐмì²âʱ£¬ÌáÊ¾ÍøÂç¼à²âδ³É¹¦£¬ÐèÒª°²×°ÐéÄâÍø¿¨

µ«ÊÇÎÒÃǰ칫ÊÒͬÑùÅäÖõÄÁ½Ì¨µçÄÔ£¬ÎªÊ²Ã´Ò»Ì¨³öÏÖÍøÂç¼à²âδ³É¹¦£¬¶øÁíһ̨»ú×Ó¾ÍûÓгöÏÖÕâÖÖÇé¿ö

ÔÚʲôÇé¿öÏ£¬»á³öÏÖÍøÂç¼à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ