|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Sql server 2005 connection
i tried make jdbc connection like followig & import jtds driver also.
import java.sql.*; public class testConnection { public static Connection getConn(){ try{ Connection con=null; Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance(); con=DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/master", "test", "123"); System.out.println("connected"); return con; } catch (Exception e){ System.out.println("DB Connection ERROR"); e.printStackTrace();} return null; } public static void main(String[] args) { testConnection.getConn(); } } but it getting folowing errors.. run: DB Connection ERROR java.sql.SQLException: Network error IOException: Connection refused: connect at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:385) at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50) at net.sourceforge.jtds.jdbc.Driver.connect(Driver.ja va:182) at java.sql.DriverManager.getConnection(DriverManager .java:582) at java.sql.DriverManager.getConnection(DriverManager .java:185) at sample.testConnection.getConn(testConnection.java: 15) at sample.testConnection.main(testConnection.java:26) Caused by: java.net.ConnectException: Connection refused: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl .java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSoc ketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.j ava:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.j ava:366) at java.net.Socket.connect(Socket.java:519) at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at net.sourceforge.jtds.jdbc.SharedSocket.createSocke tForJDBC3(SharedSocket.java:304) at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:255) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:310) ... 6 more BUILD SUCCESSFUL (total time: 1 second) please correct for me.. tks |
![]() |
| Viewing: Dev Articles Community Forums > Programming > Java Development > Sql server 2005 connection |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|