oracle°²×°ÎÊÌâ
1.
ÔÚ°²×°µÄʱºò°²×°µÄoracle 9i release¡£¡£¡£ÊÇ·ñÓ¦¸Ã°²×°Õâ¸ö°æ±¾£¬ÔÙ°²×°¹ý³ÌÖгöÏÖoracle net configuration assistantÅäÖÃÄ£¿é£¬ÊäÈëÖ÷»úºÅºÍ¶Ë¿ÚºÅÒÔ¼°sll¶Ë¿ÚºÅ£¬²»ÖªµÀÊÇʲôÎÊÌâ¡£
2.
SQL*Plus: Release 9.2.0.1.0 - Production on ÐÇÆÚÁù 9ÔÂ 26 16:58:03 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12560: TNS: ÐÒéÊÊÅäÆ÷´íÎó
ÕâÊÇʲôÎÊÌ⣿³õѧ£¬Çë¶àÖ¸½Ì¡£
ÍøÉϵݲװͼ½â¸úÎÒ°²×°Ê±µÄ²»Ò»Ñù£¬¶àÁ˼¸¸ö»·½Ú£¬ÎÒÏÂÔØµÄºÃÏñÊÇOracle9i Database Release2 Client for Windows98_NT_2000_XP£¬Õâ¸ö°æ±¾ÓëOracle9i Database Release2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP/2003ÓÐÇø±ðÂð£¿
ÄãϵÄÊDz»Ö»ÊÇOracleµÄ¿Í»§¶Ë£¿ÓзþÎñÆ÷µÄ»°£¬Åätnsnames.ora¡£
Ó¦¸Ã¾ÍÊǿͻ§¶ËÁË£¬»»¸ö°æ±¾µÄ£¬µ½ÄÄÀïÈ¥ÏÂÔØ±È½Ï·½±ã?
Â¥Ö÷ҪװµÄÓ¦¸ÃÊÇ·þÎñ¶Ë¡£
Oracle9i ¹Ù·½ÏÂÔØµØÖ·
http://www.oracle.com/technology/global/cn/software/products/oracle9i/index.html
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
11gµÄ²»ÊÇÊý¾Ý¿â°É£¬ºÃÏñÊÇʲôÉÌÒµÌ×¼þ£¬ÎÒÊdzõѧoracle£¬Ö÷ÒªÊÇÏȶÔÊý¾Ý¿âÓïÑÔÓиöºÜºÃµÄÁ˽⣬Äĸö°æ±¾¶¼¶ÔÎҴ´ÂÓÐÓàÁË£¬Èç¹ûÕÆÎÕÁË10gÄÇ9iÒ²²»³ÉÎÊÌâÁ˰ɣ¬ÎÒÏëÖªµÀÏÖÔÚÉç»áÉϵÄÖ÷Á÷ÊÇʹÓõÄÄǸö°æ±¾£¬¾Ý˵10gµÄbug±È½Ï¶à£¬²»ÖªµÀ»á²»»á¶ÔÒÔºóµÄǰ¾°ÓÐËùÓ°Ï죿
1¡£Ä¬ÈÏÅäÖðÉ
2.ÄãûÓÐÅ
Ïà¹ØÎÊ´ð£º
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......