aspose file tools*
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 Spring in Action this week in the Spring 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: 396
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: 396
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: 61433
    
  67

Let's continue the conversation in the Tomcat posting.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
jQuery in Action, 2nd edition
 
subject: No suitable driver found (for SQL Server db system)