Can i oracle C# connection without oracle client?

Question

I want to do oracle connection with C# but I want it without oracle client. Is that possible?

pap · Accepted Answer · 2012-08-09 08:04:39Z

1

Yes. The oracle JDBC "THIN" client is a standalone pure java client so you don't need to install any native Oracle client (SQL*NET etc). Check http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html for Oracle 11, you want the ojdbc5.jar or ojdbc6.jar depending on if you're using Java5 or Java6.

If you are using another version of oracle, just google for instance "oracle 10g jdbc thin" for the Oracle 10 drivers (first hit when I search).

answered Aug 9, 2012 at 8:04

pap

27.7k6 gold badges44 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

pap Over a year ago

If you want it in C#, why did you ask for JDBC and tag your question JAVA?

Ahiel · Accepted Answer · 2012-08-09 08:06:48Z

0

you need to have only the driver (jar). here is example:

Class.forName ("oracle.jdbc.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@//myserver:PORT/SID", "USER", "PASS");
connection = DriverManager.getConnection(url, username, password);

answered Aug 9, 2012 at 8:06

Ahiel

5033 silver badges11 bronze badges

2 Comments

CompEng Over a year ago

Class.forName : which class? can you give some code sample ? thanks

CompEng Over a year ago

how I can write my service_name instead of sid?

Collectives™ on Stack Overflow

Can i oracle C# connection without oracle client?

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related