File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Driver for MS SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Driver for MS SQL Server" Watch "Driver for MS SQL Server" New topic
Author

Driver for MS SQL Server

Nalini Mistry
Ranch Hand

Joined: Mar 21, 2000
Posts: 64
On attempting to create a connection to MS sql server thru a JSP, i get the error no suitable driver found. I have the J2EE 1.3 installed. I know the standard driver in there somewhere. What is it called?? and where should it be installed so that the page makes the connection???
A Agrawal
Ranch Hand

Joined: Jul 13, 2001
Posts: 41
are you loading driver using Class.forName(driver) ?
here driver is dependent on RDBMS u r using.
e.g. it can be
"oracle.jdbc.driver.OracleDriver" in case u are using Oracle thin driver.
or "sun.jdbc.odbc.JdbcOdbcDriver" in case u are using JDBC-ODBC driver.
or simply "ids.sql.IDSDriver" if you are using IDS driver.
also Take care you have put your driver (normally a .zip/.jar file) in your system's classpath.
Last, If you don't have driver for your database, you can go to RDBMS provider site (like oracle.com) and download it from there which is normally available for free.
Hope this helps.

------------------
Amit Agrawal,
New Delhi, India.


Amit Agrawal,<BR>New Delhi, India.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Driver for MS SQL Server