• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem with JdbcOdbcDriver

 
Augg Stine
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 ]
 
Raj Chila
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
 
Jessica Sant
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!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic