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 SQL Exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Storm Applied this week in the Other Open Source APIs forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL Exception" Watch "SQL Exception" New topic

SQL Exception

Ola gharably

Joined: Jul 01, 2003
Posts: 10
Hi All
well, this is the first for me to try making connection between java and databases using MSAccess.
1. first of all I downloaded jdk1.3.1 and Fortee for java, release 2.0 in order to , before starting real work, try an example.
2. I've changed my path to be c:\jdk1.3.1\bin.
3. created the microsoft access application.
4.tried this very simple example :
import java.sql.*;
public class CreateCoffees extends Object {
public static void main (String args[]) {
String url = "jdbc dbc:CAFEJAVA";

catch(ClassNotFoundException ex){
System.err.println("ClassNotFoundException: ");

Connection con = DriverManager.getConnection(url);
catch (SQLException s){
System.err.println("SQL Exception: ");
after I run the code the following run time error appears:
SQL Exception:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
Ulrich Freyer-Hirtz

Joined: Jun 30, 2003
Posts: 1
you need the DB Connection registered at the System Level. In WinXP go to System/Admnstration/DataSource and create a new DataSource with SystemDSN Name equals the name you are using in your Program.
Hope that helps
It is sorta covered in the JavaRanch Style Guide.
subject: SQL Exception