File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem with JdbcOdbcDriver