create connection string for oracle using c#

Question

0.00/5 (No votes)

See more:

Create a connection string to connect oracle database from asp.net using following information.

ipaddress;
sid
userid;
password;

Posted 2-Feb-12 0:09am

partyabhijeet

Add a Solution

4 solutions

Solution 3

Connection String[^]

Posted 2-Feb-12 0:33am

Tanzy123

Solution 4

Go through the links below
http://www.shabdar.org/c-sharp/101-connect-to-oracle-using-asp-net-and-csharp.html[^]
http://docs.oracle.com/cd/B28359_01/appdev.111/b28844/using_aspnt.htm[^]
http://webdesign.ittoolbox.com/groups/technical-functional/asp-dotnet-l/how-to-connect-oracle-database-in-aspnet-2005-c-using-oledb-provider-1705513[^]
http://www.codeguru.com/csharp/csharp/cs_network/database/article.php/c8477[^]

Thanks
--RA

Posted 2-Feb-12 0:42am

Rajesh Anuhya

Comments

Sridhar Patnayak 2-Feb-12 6:55am

Good one 5+

Rajesh Anuhya 2-Feb-12 8:24am

Thanks Sridhar
--RA

Solution 1

see
http://www.connectionstrings.com/oracle[^]
and other simple way to create connection string use these steps

For connectivity in visual studio 
open Server Explorer
right click add Connection
Follow simple steps
After Creating Connection Right click on Database
Click on properties
In Proprties Connection String will be found.
Copy This String.

Posted 2-Feb-12 0:13am

uspatel

Updated 2-Feb-12 0:17am

v2

Comments

partyabhijeet 2-Feb-12 6:27am

thanks.
what will be server name if i know ipaddress,portal and sid..

how would i get server name??

uspatel 2-Feb-12 6:52am

run query
SELECT host_name
FROM v$instance

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rockstar_ · Accepted Answer · 2012-02-02T00:31:00

Hi friend,

Create Connection string to ORACLE:

1. Open notepad
2. save as "filename.udl" on desktop
3. open filename.udl by double clicking
4. Go to provider tab ans select "Microsoft OLEDB provider for Oracle"
5.click on NEXT
6. It will take you to Connection tab
7. enter the server name
8. user name and password of your oracle
9. click on test connection button
10. You will get successfull connectoin message
11. Then close it.
12. Open the filename.udl file by right clicking on and select open with NOtepad
13. You will find a connection string to Oracle.