Im new to java programming.
I want to establish a connection to
my MS-sql database using java.
How do i do it?

Recommended Answers

All 2 Replies

First declare your URL (in string format of cours
Remember your URL is
1 a String
2 "jdbc:odbc:"+dataSourceName;

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")//often the standard;
Connection con = DriverManager.getConnection(url,"username","password");
Statement stmt = con.createStatement();

this is as far as connection goes

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")//often the standard;

Case Sensitive

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.