This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
 
Similar Threads
java.sql.SQLException[ODBC Driver Manager]Data source name not found and no default driver specified
JDBC:ODBC Oracle Connection
MS Access Web Connection using JDBC/Applet
Regarding database connectivity in servlets
Error trying to connect MS Acess 12 database