Hi all, I am working with Servlets and JDBC right now. I am facing a problem. I hope any of you people can help me out. I worked with Servlets program and JDBC program. Both r working fine. When I club the JDBC program into the Servlets program appropriately and run the servlet in a web browser, I am getting an error saying that "No Suitable Driver". Do I need to register my driver with the webbrowser? I mean do I need to do any browser settings for the driver? I am using I-net Sprinta2000 type-4 JDBC driver. And I am using SQL-Server 7 for back-end. Hope I will get around with my problem with all of ur help. Thank you. Kiran
The browser has nothing to do with JDBC since the JDBC is running on the server. Check the code and make sure that you are properly loading the driver and properly specifying the correct URL in the getConnection.
Thank u very much for ur reply. I think the problem is not with my code because I did everything properly. I got the answer for my previous problem. I am using JavaWebServer2.0. Because it has it's own classpath settings, the problem originated. It is not recognizing the driver. I copied all the driver classes in the servlets directory of the server where it can recognize. Now the message is changed saying that Inet Sprinta 2000 driver need JVM1.2 or higher. I am using JDK1.2. How to know the JVM version and how to solve this problem? Thanks again. Kiran