wood burning stoves 2.0*
The moose likes Servlets and the fly likes No suitable driver found (for SQL Server db system) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Servlets
Reply locked New topic
Author

No suitable driver found (for SQL Server db system)

Roger F. Gay
Ranch Hand

Joined: Feb 16, 2007
Posts: 349
Last week, I connected to an SQL Server database for the first time using normal (not servlets) java objects.
I have this connected to a browser app (html) via AJAX and am printing the error message in the browser:
No suitable driver found for jdbc:sqlserver://MyComputer\SQLEXPRESS:1433;databaseName=MyDB;user=myself;password=xxxxx;

The servlet:


The object that is supposed to make the connection:


Correlation does not prove causality.
Roger F. Gay
Ranch Hand

Joined: Feb 16, 2007
Posts: 349
Another day of googling later, I think my problem is that the web app is not configured with a ref to the SQL Server driver. I at least hinted that I am new to this. I posted a short description this problem in the Tomcat forum without the code. Tomcat: Configure SQL Server (driver)
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60822
    
  65

Let's continue the conversation in the Tomcat posting.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: No suitable driver found (for SQL Server db system)
 
Similar Threads
JTDS jdbc driver
Not able to connect with SQLServer from java.
Connection Through JDBC
SQL Server 2008r2 Connection Failed
Resultset processes 1 record