my sql server instance name is MYPC\SQLEXPRESS and I&#39;m trying to create a jTDS connection string to connect to the database &#39;Blog&#39;. Can anyone please help me accomplish that?

I&#39;m trying to do like this:

    DriverManager.getConnection(&quot;jdbc:jtds:sqlserver://127.0.0.1:1433/Blog&quot;, &quot;user&quot;, &quot;password&quot;);

and I get this:

     java.sql.SQLException: Network error IOException: Connection refused: connect
    	at net.sourceforge.jtds.jdbc.ConnectionJDBC2.&lt;init&gt;(ConnectionJDBC2.java:395)
    	at net.sourceforge.jtds.jdbc.ConnectionJDBC3.&lt;init&gt;(ConnectionJDBC3.java:50)
    	at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
    	at java.sql.DriverManager.getConnection(Unknown Source)
    	at java.sql.DriverManager.getConnection(Unknown Source)
    	at SqlConnection.Connect(SqlConnection.java:19)
    	at main.main(main.java:11)
    Caused by: java.net.ConnectException: Connection refused: connect
    	at java.net.PlainSocketImpl.socketConnect(Native Method)
    	at java.net.PlainSocketImpl.doConnect(Unknown Source)
    	at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
    	at java.net.PlainSocketImpl.connect(Unknown Source)
    	at java.net.SocksSocketImpl.connect(Unknown Source)
    	at java.net.Socket.connect(Unknown Source)
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    	at java.lang.reflect.Method.invoke(Unknown Source)
    	at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:305)
    	at net.sourceforge.jtds.jdbc.SharedSocket.&lt;init&gt;(SharedSocket.java:255)
    	at net.sourceforge.jtds.jdbc.ConnectionJDBC2.&lt;init&gt;(ConnectionJDBC2.java:323)
    	... 6 more

All Jtds Solutions on Gang of Coders

Total of 1 Jtds Solutions

Create a jTDS connection string