Todd,
I assume you are running TC5?
Please post your configs from the server.xml, web.xml, context.xml and code
snippet you use to get a connection.
Because you are getting a driver it is at least seeing some of your config.
Are you using the correct drivers?
Are they current?
Are they corrupted?
Driver jar goes in common/lib.
Doug
----- Original Message -----
From: "Todd H. Siegel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 24, 2004 10:12 PM
Subject: No suitable driver
> All,
>
> I know that this issue has been posted many times, I have read many of
them and
> and the Tomcat docs but to no avail...
>
> The names between the '*'s have been sanitized.
>
> The following code:
>
> Context initContext = new InitialContext();
> DataSource ds =
(DataSource)initContext.lookup("java:/comp/env/jdbc/*DbName*");
> Connection conn = ds.getConnection();
>
> produces the following results:
>
> java.lang.Exception: org.apache.commons.dbcp.SQLNestedException: Cannot
create
> JDBC driver of class 'com.microsoft.jdbcx.sqlserver.SQLServerDataSource'
for
> connect URL 'jdbc:microsoft:sqlserver://*hostname*', cause: No suitable
driver
>
> In the interest of keeping this brief I won't include all of the config,
but
> I've tried putting the <Resource> & <ResourceParams> definitions in the
> <Context> element for the webapp in server.xml.
>
> I've also put the <Resource> & <ResourceParams> definitions in the
> <GlobalNamingResources> in the server.xml with a <ResourceLink> in the
> <Context> element in $CATALINA_HOME/*webapp*.xml. I've also tried this
with a
> context.xml in the META-INF directory of the webapp.
>
> The jars for the driver are in common\lib, but I've also tried putting
them in
> every other imaginable lib directory too.
>
> I would greatly appreciate any help.
>
> Thank you,
> Todd
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on time.
> http://taxes.yahoo.com/filing.html
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
