• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

Connecting SQL Server 2000 Thru type4 Driver  RSS feed

 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Can any one help me out
how to connect to sqlserver 2000 thru type 4 driver(java native driver)
i have downloaded the driver from (.jar file) jtds site and added it
into my classpath.
code -
class.forName("Net.sourceforge.jtds.jdbc.Driver")
SourceURl="jdbc:jtds:sqlserver/server:1433/admin;
user="sa"
password=""
Connection con=DriverManager.getConnection(SourceURl,user,password)
---
when i execute the program, "NO SUITABLE DRIVER AVAILABLE" message is printing in the exception
--prabhu
 
Bartender
Posts: 9521
12
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Read the FAQ.


Why do I get a "java.sql.SQLException: No suitable driver" when trying to get a connection?
The "No suitable driver" exception is thrown by the DriverManager when none of the registered Driver implementations recognizes the supplied URL. This means that you either did not register jTDS with the DriverManager (by doing a Class.forName("net.sourceforge.jtds.jdbc.Driver") first) or you mistyped the URL (e.g. "jbdc:jtds:..." instead of "jdbc:jtds:...").

 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!