Problem in JDBC

[Preethi]

I'm getting this erro only after downloading JDBC Driver for sqlserver2005.
Can anyone say me how to remove it or how to solve the problem.(I have searched for it in add or remove
programs in control panel,but couldn't find...But i have included mssqlserver.jar,msutil.jar,msbase.jar in my classpath)

Code:

basic: Modality pushed
basic: Modality popped
basic: Registered modality listener
liveconnect: Invoking JS method: document
liveconnect: Invoking JS method: URL
basic: Referencing classloader: sun.plugin.ClassLoaderInfo@15efa6a, refcount=1
basic: Added progress listener: sun.plugin.util.GrayBoxPainter@14b389
basic: Loading applet ...
basic: Initializing applet ...
basic: Starting applet ...
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
	at sun.applet.AppletClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at sun.applet.AppletClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClassInternal(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at xmlTrail.XMLReading.fileParsing(XMLReading.java:86)
	at xmlTrail.MD2$Imagepanel.prepareData(MD2.java:517)
	at xmlTrail.MD2$Imagepanel.<init>(MD2.java:139)
	at xmlTrail.MD2.init(MD2.java:56)
	at sun.applet.AppletPanel.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.io.FileNotFoundException: C:\Documents and Settings\com\microsoft\sqlserver\jdbc\SQLServerDriver.class (The system cannot find the path specified)
	at java.io.FileInputStream.open(Native Method)
	at java.io.FileInputStream.<init>(Unknown Source)
	at java.io.FileInputStream.<init>(Unknown Source)
	at sun.net.www.protocol.file.FileURLConnection.connect(Unknown Source)
	at sun.net.www.protocol.file.FileURLConnection.getInputStream(Unknown Source)
	at sun.applet.AppletClassLoader.getBytes(Unknown Source)
	at sun.applet.AppletClassLoader.access$100(Unknown Source)
	at sun.applet.AppletClassLoader$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)

[Eku]

have added those jar file in the
..\Java\jdk1.6.0_05\jre\lib\ext\ Folder

[masijade]

Quote:

Originally Posted by Eku

have added those jar file in the
..\Java\jdk1.6.0_05\jre\lib\ext\ Folder

DON'T add it there. Never add anything to the jre lib directories. That ext folder is for language extensions (the meaning of ext) and a JDBC Driver is far from a language extension. Besides, what happens when you upgrade Java? What happens, when for one app you need a newer version of a Driver, and for an older app you need an older version?

Add the jarfile to your CLASSPATH (not your system classpath as the older/newer version problem still exists there, and most web containers and IDE's won't use that anyway), but rather, if you are using a jarfile, to the manifest, and if you are not using a jarfile, to the command line -cp option, or if you are using a web container/IDE configure it there.

[masijade]

Ach, and your problem is that you're using an applet. In that case you must provide the Driver classes yourself (unpacked form in the "codebase" directory, or in the jarfile if using a jarfile) or, make url (or RMI or someother remote protocol) to a self-written server that will interface with the db for you and just send you the results.

[Niveditha]

I think it ll be in "SQL-Installation path/Lib", correct me if ia m wrong.
Check this too
HOW TO: Get Started with Microsoft JDBC

[AnilKanike]

Hi,

You might have missed out some .jar files to be included. Try to add its corresponding jar files and then try out.

[masijade]

To both of the last posters. He is using an Applet. That means that the application itself will be running on a client machine that he may (and probably should) have no control over. That he means, whatever he writes will have access to core java, and core java, only, unless he provides it from the "codebase" he defines in the Applet tag.

@OP: Make sure the Driver is freely distributable, though, otherwise you will be violating license restrictions, and that could become very costly in terms of both money (fines) and time (prison).

[rajeshbehera]

for using sqlserver type 4 database you have to download 3 jar files.and keep it in lib folder before running your web application

[masijade]

It's not a web application. It's an applet, so he must provide all three of those jarfiles (in unpacked format, as already noted) as part of the "codebase".