Çë½ÌDRIVER={Microsoft ODBC for Oracle} Á¬½ÓÎÊÌ⣡
ÊÇÕâÑùµÄÎÒ×°ÁËһ̨2003µÄÐéÄâ»ú£¡
ÐéÄâ»úIP£º192.168.1.108
±¾»úIP£º192.168.1.100
ÎÒÔÚÐéÄâ»úÉÏ×°ÁËoracle 10G ,ÏÖÔÚÏë±àд¸ö³ÌÐò¶ÁÈ¡oracleÊý¾Ý¿âÀïµÄ¼Ç¼£¬
ÎÒÔÚ±¾»ú×°Á˸öoracle XE Client£¬ÇëÎʸÃÈçºÎÁ¬½Ó ÐéÄâ»úÉϵÄoracle
ÎÒÓà DRIVER={Microsoft ODBC for Oracle};UID=¡°system¡°;PWD=¡±5897577¡°;SERVER=¡±Êý¾Ý¿âÃû×Ö ;¡±
°ÑÎÒдµÄ³ÌÐò·Åµ½ÐéÄâ»úÉÏ¿ÉÒÔÁ¬½Ó£¬·Åµ½±¾»úÕâÑù¾Í²»ÄÜÁ¬½ÓÁË£¡
ÇëÎÊÈçºÎÐ޸쬻òÕ߯äËû·½·¨£¡
ÄÇÎÒÈí¼þÖÐÔõÃ´Ð´ÄØ£¿
ÂÛ̳ÈËÆøÔõôÕâôÉÙ
Ïà¹ØÎÊ´ð£º
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÄÜ·ñÓÃÓï¾äʵÏÖ¡£¶ø²»ÊÇÏֳɵŤ¾ß£¿
Â¥ÉϵÄÐֵܿÉÒÔÏêϸһЩÂð£¿
×£Äã½ÚÈÕ¿ìÀÖ£¡¹þ¹þ
½ÚÈÕ¿ìÀÖ
SQL code:
Ò». µ¼³ö¹¤¾ß exp
1. ËüÊDzÙ×÷ϵͳÏÂÒ»¸ö¿ÉÖ´ÐеÄÎļþ ´æ·ÅĿ¼/ORACLE_HOME/bin
......
Èç¹ûÒ»¸ö³ÌÐòÏëÖ§³ÖsqlserverÓëoracleÊý¾Ý¿âµÄ»°¡£³ýÁËdbhelperÀàÐèÒª¸Ä±äÖ®Í⣬²ÎÊý´«µÝÒ²ÊǸöÎÊÌâ¡£
sqlserverµÄ²ÎÊýǰ׺ÊÇ ¡°@¡±£¬¶øoracleÊÇ ¡°:¡±
ÇëÎÊÓÐûÓÐʲôͨÓýâ¾ö·½·¨£¿ÎÒ²»ÏëÒ»¸öselect ......
ÔÚ´æÈ¡Ð¡Êý£¬ÀýÈç0.5µÄʱºò£¬ÎªÊ²Ã´´æÈ¡µ½Êý¾Ý¿âÖбä³É .5 µÄÐÎʽ£¿
½â¾ö·½°¸ÒѾÓÐÁË£¬ÎÒÖ÷Òª¹ØÐĵÄÊÇoracleΪʲô»áÕâô´æ´¢£¿
ÄãËù¿´µ½µÄÊÇ´æ´¢µÄÊý¾ÝµÄÏÔʾ·½Ê½£¬Ö»ÊÇÒ»¸ö±íÏ󣬲¢²»Ó°ÏìÊý¾ÝÔÚÊ ......