File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC connectivity error

 
nandini anusha
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic