Problem with JdbcOdbcDriver

[Augg Stine]

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]

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]

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]

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!