This week's book giveaway is in the OCAJP forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide 1Z0-808 and have Jeanne Boyarsky & Scott Selikoff on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes No Suitable Driver Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "No Suitable Driver Error" Watch "No Suitable Driver Error" New topic
Author

No Suitable Driver Error

Steve Dyke
Ranch Hand

Joined: Nov 16, 2004
Posts: 1514
    
    1
This is my class. I get error No Suitable Driver. Please help:

Ulf Dittmer
Rancher

Joined: Mar 22, 2005
Posts: 42952
    
  73
I think the ":microsoft" in the connection URL is superfluous; try "jdbc:sqlserver:" instead.

By the way, it's much more common not to instantiate the driver directly, but to do something like:

That also makes it easy to keep driver class name and connection url details in an external data source, instead of hardcoding them.
Steve Dyke
Ranch Hand

Joined: Nov 16, 2004
Posts: 1514
    
    1
Now I get a message: Unknown Source
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1135

Steve,
Database connection URLs are usually JDBC driver specific.
I don't use SQL Server but I imagine that its compatible JDBC drivers have documentation which provide details of how to write a suitable one for your situation.
Am I mistaken?

Just did a Google search and came up with this:

http://support.microsoft.com/kb/313100

Maybe it will help you?

Good Luck,
Avi.
Nishanth Sivaraman
Greenhorn

Joined: Aug 12, 2008
Posts: 7
are you using sqlserver 2000 or 2005? connection varies for them, see the coed below. Get appropriate driver from microsoft site.

String connectionstring="jdbc:microsoft:sqlserver://nishanths:1433";
username="abc";
password="abcd";
//use any one of the line according to your sqlserver version
//DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQLServerDriver()); //Use For SQL Server 2005

DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver()); //Use For SQL Server 2000
Con = DriverManager.getConnection(connectionstring,username,password);


Thanks,

Nishanth.S
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: No Suitable Driver Error