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 Problem with JdbcOdbcDriver 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 "Problem with JdbcOdbcDriver" Watch "Problem with JdbcOdbcDriver" New topic
Author

Problem with JdbcOdbcDriver

Augg Stine
Greenhorn

Joined: Mar 24, 2004
Posts: 27
Hi
i'm using a datasource object to get a connection. But it gives me 'No Suitable Driver'. Following is a part of server.xml in Tomcat 4.1.
******************************************************************
<parameter>
<name>url</name>
<value>jdbc dbc:TeamDataSource</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>sun.jdbc.odbc.JdbcOdbcDriver</value>
</parameter>
*********************************************************************

But if i use DriverManager.getConnection with the same Database URL & the Driver, i'm able to get the Connection ...

Please help
Thank you in Advance
regards,
Augg
[ March 31, 2004: Message edited by: Bear Bibeault ]
Raj Chila
Ranch Hand

Joined: Mar 18, 2004
Posts: 128

Hi Augg,
if you are using a JDBC : ODBC Driver then I think you should also create a System DSN for accessing the Database through the native ODBC drivers.
check it up once.
Augg Stine
Greenhorn

Joined: Mar 24, 2004
Posts: 27
hi
I have done that in the System DSN. it is "TeamDataSource". That is the one, i'm using it.
Thank you
regards,
Augg
Jessica Sant
Sheriff

Joined: Oct 17, 2001
Posts: 4313

Augg Augg-
Please don't post the same thread in multiple forums -- it's a bit confusing a wastes people time. I have left this thread open so that the discussion may continue here in the appropriate forum.
Also, Welcome to the JavaRanch! We like to keep a nice professional lookin' image... (we don't want anyone to show up the Moose). So, can you please adjust your displayed name to match the JavaRanch Naming Policy? Basically it should be a believeable and not obviously fictitious first and last name.
You can change it here.
Thanks! and again welcome to the JavaRanch!


- Jess
Blog:KnitClimbJava | Twitter: jsant | Ravelry: wingedsheep
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Problem with JdbcOdbcDriver
 
Similar Threads
URGENT: problem with JdbcOdbcDriver
Context in Virtual Hosts
URGENT - connection using JdbcOdbcDriver
URGENT: problem with JdbcOdbcDriver
Tomcat DataSource