jQuery in Action, 3rd edition
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
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
I agree. Here's the link: http://aspose.com/file-tools
subject: SQL Exception
It's not a secret anymore!