Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Java > Other Java > Java Databases
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Java Databases Discussion specific to working with Java Databases. For other Java topics, please see related Java forums. For database discussions not specific to Java, please see the Database category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Java Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old September 26th, 2009, 03:47 AM
Registered User
 
Join Date: Sep 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default JDBC connectivity error

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

Last edited by srinandini; January 20th, 2010 at 09:10 PM.
Reply With Quote
  #2 (permalink)  
Old December 20th, 2010, 08:20 AM
Registered User
 
Join Date: Dec 2010
Location: Pune, India
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Thumbs up

Quote:
Originally Posted by srinandini View Post
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

Hi Srinandini,

Please provide the code,or Exception stack.Without that, we can't comment on the Error you are getting.

For more reference on JDBC-Access 2007 Connectivity, OR DSN please refer the Link.

Reply With Quote
  #3 (permalink)  
Old July 8th, 2011, 05:26 PM
Registered User
 
Join Date: Jul 2011
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

write click on the page in which you have coded the ODBC connection
and then right click and select the option data source and than add the name you added while creating connection in the control panel connections
add the data source name not the database name
__________________
Code:
http://www.stufflives.com
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
connectivity error sb123 ASP.NET 1.0 and 1.1 Basics 1 March 13th, 2008 08:36 AM
Connectivity error pratibha7881 ASP.NET 1.0 and 1.1 Basics 2 January 14th, 2008 01:21 PM
jdbc:sql:tomcat connectivity shraddhavs Pro JSP 3 July 15th, 2006 12:15 PM
jdbc:mysql connectivity kvenk111 Pro JSP 2 April 21st, 2006 03:25 AM
Cannot load JDBC driver class with com.mysql.jdbc. dzis Apache Tomcat 0 January 29th, 2004 11:57 AM



All times are GMT -4. The time now is 09:45 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.