aspose file tools*
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "error when i run the program" Watch "error when i run the program" New topic
Author

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[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbcdbc:Part6";
Connection con=DriverManager.getConnection(url);
Statement stmt;
stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("SELECT Auth_ID, Auth_Name FROM AUTHOR_t");

while(rs.next())
{
int i=rs.getInt(1);
String name=rs.getString(2);
System.out.println("Name="+name);

}

stmt.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}

}



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(jdbcDemo.java:13)
[ 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: http://aspose.com/file-tools
 
subject: error when i run the program