Two Laptop Bag*
The moose likes Tomcat and the fly likes JDBC trouble with Tomcat 5 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 » Products » Tomcat
Bookmark "JDBC trouble with Tomcat 5" Watch "JDBC trouble with Tomcat 5" New topic

JDBC trouble with Tomcat 5

Roy Simon
Ranch Hand

Joined: Aug 26, 2005
Posts: 62
i am using tomcat 5.5.9 and and jdk1.5 when i try to use jdbc to connect to ms access via my servlet i get the following exception.

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

i tested the model seperately and the code worked perfectly fine from the comman prompt!!

Can someone tell me what is that i am missing??

Ben Souther

Joined: Dec 11, 2004
Posts: 13410

Where did you put the driver?

Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
Roy Simon
Ranch Hand

Joined: Aug 26, 2005
Posts: 62
I didnt put any driver anywhere!! . i know i have to put the driver in the servers lib directory but i am not able to find the driver!! can u please tell me where i can find the driver??

It is sorta covered in the JavaRanch Style Guide.
subject: JDBC trouble with Tomcat 5
Similar Threads
Help in database connections
code or server problem ?
Installing Oracle JDBC Driver in Tomcat.
junk values for the id property
JDBC driver for Oracle 8i, Tomcat and JDK