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 error when i run the program 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 "error when i run the program" Watch "error when i run the program" New topic

error when i run the program

sai donthneni
Ranch Hand

Joined: Mar 26, 2006
Posts: 50
This is the program and I am trying to connect to MS Access database.

import java.sql.*;

class jdbcDemo
public static void main(String args[])
String url="jdbcdbc:Part6";
Connection con=DriverManager.getConnection(url);
Statement stmt;
ResultSet rs=stmt.executeQuery("SELECT Auth_ID, Auth_Name FROM AUTHOR_t");

int i=rs.getInt(1);
String name=rs.getString(2);


catch(Exception e)


The Exception I am getting when I am running the program is

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not fou
nd and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at jdbcDemo.main(
[ August 09, 2006: Message edited by: sai donthneni ]
surendar prabu
Ranch Hand

Joined: Jul 24, 2006
Posts: 102
check whether your DataSourceName is pointing to your database correctly or not.If not configure that correctly.

and use finally block to close your connection and statement.

SCJP 1.4
sai donthneni
Ranch Hand

Joined: Mar 26, 2006
Posts: 50
My datasource has been mentioned properly. Do I have to mention that it is on the localhost? My database name is Part6. Do I have to download the drivers seperately or do they come with the database server itself?
I agree. Here's the link:
subject: error when i run the program