I'd like to connect to the database through microsoft's jdbc drivers. I'm using the sql server 2000 service pack drivers which can be found here.
These are the relevant lines of code:
I get this error back:
java.sql.SQLException: No suitable driver
I know that the classpath is setup correctly, because when run with verbose output enabled I can see the classes from the microsoft jars being loaded:
I've tried various url's, both pointing at a local database and at remote databases. Because of this I don't think it's a network issue. I've also tried adding a default database option to the url.
I've tried compiling and running with jre 1.3.1 and jre 1.4.2, but I still get the error.
I'm stuck and confused, am I missing something obvious? I would greatly appreciate any help.
String url = "jdbc:microsoft:sqlserver://systemname:1433/databasename;"
--- add a ":" and "databasename "
Are you sure it should have the semi-colon on the end?
Checking the FAQ, the suggested syntax is jdbc:Microsoft:sqlserver://my-virtualserver:1433;DatabaseName=Pubs
I'd try adding the database name in the form above, or leave off everything after (and including) the semicolon.