« Managing Multiple Configuration File For Different Application Life cycles In .Net Applications | Export to PDF, Excel and Image in asp.net »

Oracle Connection String Without tnsnames.ora file for .net

by Vahid 12. July 2009 04:51

ever wanted to connect to an oracle database in your .net application (asp.net, windows client ect) but tnsnames.ora file was missing? ok,i just found a solution for this in connectionstrings.com. you can use the following connection strings to connect to an oracle database using both microsoft .net provider for oracle database and odp.net:

.NET Data Provider for Oracle

SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=yourHost)(PORT=yourPort))(CONNECT_DATA=(SERVICE_NAME=yourOracleSID)));uid=yourUsername;pwd=yourPassword;

Oracle Data Provider for .NET / ODP.NET

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;

.Net | Technical

Comments (0)

Differences between asp.net web Site and asp.net Web ApplicationHave ever wondered what the differences between 2 types of asp.net web projects in visual studio 200…Managing Multiple Configuration File For Different Application Life cycles In .Net Applications All of us have already dealt with the problem of promoting configuration files in different applic…Could not load file or assembly ‘Oracle.DataAccess’ or one of its dependencies. An attempt was made to load a program with an incorrect formatI had deploying an asp.net application to a windows 2008 64bit server. the application uses od…

Oracle Connection String Without tnsnames.ora file for .net#

Oracle Connection String Without tnsnames.ora file for .net