JDBC &ODBC

[sameera liyanage]

what is the different between JDBC & ODBC?
give example

[Ulf Dittmer]

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]

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]

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]

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

[Sagar Rohankar]

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