1. 下載客戶端Oracle Developer Tools for Visual Studio_32bit
安裝后通過配置tnsnames.ora指定連接
C:appuser nameproduct11.2.0client_1NetworkAdmin
SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IP Address)(PORT=1521))(CONNECT_DATA=(SID=SID)))
重啓后可以在VS2010通過Server Explorer連接
在C#中連接
using System.Data.OracleClient;private string connStr =" SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IP Address)(PORT=1521))(CONNECT_DATA=(SID=SID)));uid=NEW_TESTING;pwd=NEW_TESTING;"
OracleConnection conn2 = new OracleConnection(connStr);
2. DbVisualizer
3. PLSQL Developer