• 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:
  • Campbell Ritchie
  • Paul Clapham
  • Liutauras Vilda
  • Knute Snortum
  • Bear Bibeault
Sheriffs:
  • Devaka Cooray
  • Jeanne Boyarsky
  • Junilu Lacar
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • salvin francis
Bartenders:
  • Tim Holloway
  • Piet Souris
  • Frits Walraven

Driver for MS SQL Server

 
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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???
 
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
If you two don't stop this rough-housing somebody is going to end up crying. Sit down and read this tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!