visual c#ÎÞ·¨Á¬½Óoracle£¿£¿£¿
´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£
ÆäÖÐÊý¾Ý¿âÊÇÅäÖúÃÁ˵ģ¬ÒòΪÓÃSQL developer¿ÉÒÔ·ÃÎʵ½Êý¾Ý¿â
»¹Çë´óÏÀÃǰïæ½â¾öÏÂÎÊÌâ
Ò»°ãÊÇ·ÅÔÚʲôλÖõÃѽ£¿
ÎÒ¿´¹ýÁËÓа¡~~~
ÊÇÔÚÒýÓÃÖÐOracle.DataAccessÎÞ·¨ÓëC:\oracle\product\10.1.0\Db_1\BIN\Oracle.DataAccess.dllÁ¬½Ó£¬É¾³ýºóÖØÐÂÌí¼ÓÒýÓü´¿É£¡
¹þ¹þ¹þ£¬Work it out myself!
΢ÈíµÄ²úÆ·Óë·Ç΢ÈíµÄ²úÆ·½áºÏ×ÜÊÇ´æÔÚÎÊÌâµÄ....Õâ¾ÍÊǾºÕù
Äã°²×°ÁËODACÁËÂð?ÊÇOracleµÄ²»ÊÇ΢ÈíµÄ
Äã°ÑÒýÓÃÎļþµÄ·¾¶ÐÞ¸ÄÁË¡£
Ïà¹ØÎÊ´ð£º
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html
Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..
cm ......