aspose file tools*
The moose likes JDBC and the fly likes JDBC connectivity error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC connectivity error" Watch "JDBC connectivity error" New topic
Author

JDBC connectivity error

nandini anusha
Greenhorn

Joined: Sep 28, 2009
Posts: 1
Hi all,
First of all i want to create a servlet which will fetch only the database records & will display it.But i'm failing to do that.


First, i have create the database in the MS Access 2007 with two columns roll & sname with datatype number & text respectively. i saved it as Database2.accdb.


Then i've added the data source through Data Sources (ODBC) in Control Panel of that Database2.accdb. database by selecting the Microsoft Access Driver(*.mdb,*.accdb).


And i created html file and i opened it.But i'm getting error as




HTTP Status 500 - java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

--------------------------------------------------------------------------------

type Status report

message java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

description The server encountered an internal error (java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified) that prevented it from fulfilling this request.


--------------------------------------------------------------------------------

Apache Tomcat/5.5.28

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC connectivity error