This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes JDBC &ODBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC &ODBC" Watch "JDBC &ODBC" New topic
Author

JDBC &ODBC

sam liya
Ranch Hand

Joined: Nov 25, 2008
Posts: 1238
what is the different between JDBC & ODBC?
give example
Ulf Dittmer
Rancher

Joined: Mar 22, 2005
Posts: 42954
    
  73
For basic definitions, Google and Wikipedia are your best options. There's not much point in writing here what has been written multiple times before elsewhere.
Sagar Rohankar
Ranch Hand

Joined: Feb 19, 2008
Posts: 2902
    
    1

aruna sameera wrote:what is the different between JDBC & ODBC?

Short note:
JDBC: A Java way to get connected to the databases.
ODBC: Its MS Windows library specific way to get connected to MS SQL server .
Raghavan Muthu
Ranch Hand

Joined: Apr 20, 2006
Posts: 3370

Sagar Rohankar wrote:
aruna sameera wrote:what is the different between JDBC & ODBC?

Short note:
JDBC: A Java way to get connected to the databases.
ODBC: Its MS Windows library specific way to get connected to MS SQL server .


ODBC is not specifically for MS SQL Server alone. You can try with any compliant database.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

...and its not specifically a Microsoft technology (though MS are one of its main proponents). Its a standard.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Sagar Rohankar
Ranch Hand

Joined: Feb 19, 2008
Posts: 2902
    
    1

oops, Thanks Raghvan, I missed that, Its because of mostly my ODBC connection end up with SQL Server OR MS Access, only

And Paul , Thanks, for letting me know, as its standard.. Thats means we can have ODBC connection on Linux platform also
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC &ODBC