|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
jdbc-sql 2000 errorI'm having trouble connecting to Sql Server 2000 via Java 2 (5.0). I'm on Windows Server 2003 and trying to connect locally from the server. I've downloaded the jar files (mssqlserver.jar,msutil.jar, msbase.jar) containing the jdbc driver from microsoft and placed them in the same directory as my java file, below is a snippet of my code to test the connection: public void openTest() throws Exception { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver" ); Connection m_Conn = DriverManager.getConnection ("jdbc:microsoft:sqlserver://local:1433", "", ""); } I compile using the following command there are no errors: javac -classpath ".;./mssqlserver.jar;./msbase.jar;./msutil.jar" Test.java At runtime i get the following error, Exception in thread "main" java.lang.ClassNotFoundException: com.microsoft.jdbc. sqlserver.SQLServerDriver at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.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 Hello.openTest(HelloPrint.java:30) at HelloPrint.main(HelloPrint.java:11) Can anyone help? Many thanks in advance. Inder Hi
It's been a while since I used the JDBC driver! microsoft.public.sqlserver.jdbcdriver may be a better newsgroup to post to. You may want to make sure the .jar files are on the classpath and you may want to re-run the setup just in case there is some corruption. John Show quote "inder" wrote: > Hi, > > I'm having trouble connecting to Sql Server 2000 via Java 2 (5.0). > I'm on Windows Server 2003 and trying to connect locally from the > server. I've downloaded the jar files (mssqlserver.jar,msutil.jar, > msbase.jar) containing the jdbc driver from microsoft and placed them in > the same directory as my java file, below is a snippet of my code to > test the connection: > > public void openTest() throws Exception > { > > Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver" ); > > Connection m_Conn = DriverManager.getConnection > ("jdbc:microsoft:sqlserver://local:1433", "", ""); > } > > > I compile using the following command there are no errors: > javac -classpath ".;./mssqlserver.jar;./msbase.jar;./msutil.jar" > Test.java > > At runtime i get the following error, > > > Exception in thread "main" java.lang.ClassNotFoundException: > com.microsoft.jdbc. > sqlserver.SQLServerDriver > at java.net.URLClassLoader$1.run(Unknown Source) > at java.security.AccessController.doPrivileged(Native Method) > at java.net.URLClassLoader.findClass(Unknown Source) > at java.lang.ClassLoader.loadClass(Unknown Source) > at sun.misc.Launcher$AppClassLoader.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 Hello.openTest(HelloPrint.java:30) > at HelloPrint.main(HelloPrint.java:11) > > > > Can anyone help? Many thanks in advance. > > Inder > Hi John,
I've got that error fixed; you were right, it was a classpath problem. Now i have another error, [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. when i run the following, Connection m_Conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://servername:1433; DatabaseName=Northwind","",""); The problem is that my 'servername' is the same as my windows server 2003 domain and when i setup my sql server 2000 i set it to use the windows authentication, so now i'm not sure what to put for the username and password in the above string. Many thanks again, Inderjit *** Sent via Developersdex http://www.developersdex.com *** Hi
This may help a bit. http://support.microsoft.com/default.aspx?scid=kb;en-us;313100 AFIK the JDBC driver does not support Windows Authentication as it is not a type 4 driver. You may want to look at http://www.jnetdirect.com/products.php?op=jsqlconnect John |
|||||||||||||||||||||||