Where jdbc:sqlserver string i s mandatory because it’s used to >serverName, instanceName, and portNumber is optional. That makes URL inval > ': No suitable driver : sqljdbc4.jar' error.įor Example in JTDS, the JDBC URL format isĪnd while using Microsoft’s JDBC driver, the URL format is : This error comes when your supplied database URL d >jtds.jar, makes a mistake while using sqljdbc4.jar by adding 'microsoft' in JDBC URL. There are two ways to connect Microsoft SQL Server from Java program, either by using Microsoft’s official JDBC driver ( sqljdbc4.jar ), or by using jTDS driver ( jtds.jar ). This is the exact exception, and below is the exact code, except for password.

I also tested that the class could be found by using an import statement below - no error during compile, so it must be finding the jar.Ĭould it be related to a dll or some sql dll that the sqldbc4.jar references? I’ve added the sqljdbc4.jar to the classpath in netbeans for both compile and Run, via the project properties. I’m getting this exception when I try to run this program.

Java no suitable driver found sqlite