File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes How to connect Driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How to connect Driver" Watch "How to connect Driver" New topic

How to connect Driver

eric lee
Ranch Hand

Joined: Nov 04, 2002
Posts: 86
When i run java Test,it shows error message,
how can i solve it? Thanks.
[ODBC Driver Manager]Data source name not found
and no default driver specified
import java.sql.*;
public class Marking{
public static void main(String[] args) {
// Load the driver
try {
// Load the driver class

// Define the data source for the driver

String sourceURL = "jdbc dbc:bookbase";
// Create a connection through the DriverManager
Connection databaseConnection =
// We made it!
System.out.println("Connection established successfully!");
// close connection
catch (ClassNotFoundException cnfe) {
catch (SQLException sqle) {
kishor rao
Ranch Hand

Joined: Dec 10, 2002
Posts: 35
I changed the datasource name to one I have on my system and it compiled and executed without any glitches.
Make sure you have set up the ODBC connection properly.
kishor rao
Ranch Hand

Joined: Dec 10, 2002
Posts: 35
If you have run the program as java test...thats wrong. I dont know where the test class is. You should run it as java Marking.
subject: How to connect Driver
It's not a secret anymore!