• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Bear Bibeault
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Jj Roberts
  • Tim Holloway
  • Piet Souris
Bartenders:
  • Himai Minh
  • Carey Brown
  • salvin francis

Problem with JdbcOdbcDriver

 
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Ranch Hand
Posts: 128
Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi
I have done that in the System DSN. it is "TeamDataSource". That is the one, i'm using it.
Thank you
regards,
Augg
 
Sheriff
Posts: 4313
Android IntelliJ IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
And then the entire population worshiped me like unto a god. Well, me and this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic