Oracle Connection String
Most of the time I use tns.ora file for Oracle connection.
But if i install oracle client or odac then tns.ora file is created and accessed.
but some time your client may not have that component. so i need direct connection string.
The syntax is:
string connectionString = “Data Source =(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle.dcl.net)(PORT = 1521)) )(CONNECT_DATA = (SERVICE_NAME = umrdb) )); User ID=rraquib; Password=rraquib”;
No comments yet.
-
Recent
- Java Script Mouse position for IE, FF, Safari
- Event, KeyPress in IE and firefox and preventDefault or return false
- WebRequest AND HttpWebRequest to get Image from Server
- Linq JOIN
- Regex for hour (Example 0-23.99)
- SQL Update and JOIN
- SQL 2005 and SQL2008 Enabling Notifications. SQL Chache Dependancy Part-I
- Label Text Blinking Using JavaScript with MasterPage or Page via Page_Load
- Fire a Client side event or DOM event manually
- Fire a Client Side Event or DOM Event Manualy from Javascript or composite control
- Hello world!
- Copy data Of One table to another table with trigger.
-
Links
-
Archives
- October 2009 (3)
- September 2009 (2)
- August 2009 (1)
- February 2008 (12)
- January 2008 (6)
-
Categories
-
RSS
Entries RSS
Comments RSS
