How to connect oracle databse
来源:互联网 发布:网络自制剧最新排行榜 编辑:程序博客网 时间:2024/05/21 23:51
1. 下載客戶端Oracle Developer Tools for Visual Studio_32bit
安裝后通過配置tnsnames.ora指定連接
C:\app\user name\product\11.2.0\client_1\Network\Admin\
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
0 0
- How to connect oracle databse
- How to open and close wallet for Oracle Databse 11g?
- How to Connect to Oracle via JDBC
- How to connect Ubuntu remotely
- Using rman duplicate active databse to create Oracle 11g dataguard
- Java JDBC - How to connect to Oracle using Service Name instead of SID
- JDBC connect to oracle
- how to let viewpad7 connect to ubuntu
- How to Connect to MySQL Using C#
- QT7 How to connect Qt to SQLite
- How to Connect Oracle 9i with SQL Server 2000 for establishing the linked server
- How to Connect Oracle 9i with SQL Server 2000 for establishing the linked server
- C# how to connect the database
- How to connect DB in Java
- How to connect SQLPlus without tnsnames.ora
- Docker: how to connect two bridges
- How to connect with apple In China
- Oracle下的Databse,Instance,Schemas
- 反编译教程
- 一顺眸
- 关于jena OWL持久化 Table 'jena.jena_sys_stmt' doesn't exist的解决
- /dev/tty /dev/ttyS0 /dev/tty0区别
- ASP.NET AJAX(Atlas)和Anthem.NET——管中窥豹般小小比较
- How to connect oracle databse
- 一直伴随着互联网的成熟
- JavaScript权威指南 第一部分 读书笔记
- HDCP的key交互
- mysql相似于oracle的to_char() to_date()方法
- IOS7新特性之Xcode
- 喝牛奶最好一口一口慢慢喝
- Mongodb 在CentOS6.2上的安装
- 《高效学习OpenGL》 之 反馈 glFeedbackBuffer(), glPassThrough()