StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POWhat is the difference between Java and C# when it comes to connect to Sql Server Database?
primarykey
Id
6536463
data
AcceptedAnswerId
0
AnswerCount
3
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2011-06-30T14:36:22.537
FavoriteCount
0
LastActivityDate
2011-07-28T04:50:18.040
LastEditDate
2011-07-28T04:50:18.040
LastEditorUserId
76337
OwnerUserId
539679
ParentId
0
PostTypeId
1
Score
0
ViewCount
1324
LastEditorDisplayName
text
Body
I am writing an application requires to connect to sql server. I prefer to write the App in Java. but When I try to connect to the server I got the connection refused error. I am using JTDS JDBC driver. I think it is due to the port 1433 or 1434 are not open. The server is in my work place and I can not change the ports. But funny enough, I use c# writing the same thing, it connects successfully. is it because SqlConnection class in C# library works better with ms sql server? or am I doing something wrong here? FYI, the server we are using in work is MS SERVER 2003. Sorry I did not provide any code earlier. One tricky part is that the server we have is called "SERVER" on the local network. C#: <pre><code>SqlConnection objConnection = new SqlConnection("Data Source= SERVER\\SQLEXPRESS;Initial Catalog=SSS;Persist Security Info=True;User ID=user;Password=pass"); SqlCommand objcommand = new SqlCommand(); string strSQL; objcommand.Connection = objConnection; strSQL = "select * from company where companyid = @companyID "; try { objConnection.Open(); SqlDataReader Query = objcommand.ExecuteReader(); while (Query.Read()) { MessageBox.Show(Convert.ToString(Query["clientRef"])); } objConnection.Close(); } catch (Exception ex) { MessageBox.Show("Error Retreiving info: " + ex.ToString(), "Application Error", MessageBoxButtons.OK, MessageBoxIcon.Error); objConnection.Close(); } </code></pre> As I am not really familiar with C#. I have got the code above from one of the colleges. and it returns the info correctly. Java: <pre><code>try{ Connection connection; Class.forName("net.sourceforge.jtds.jdbc.Driver"); connection = DriverManager.getConnection("jdbc:jtds:sqlserver://network.local/SERVER\\SQLEXPRESS:1433/SSS","user","pass"); System.out.println("Connection succeed!"); } catch (Exception e) { e.printStackTrace(); } </code></pre> The java code above got Network error IOException: Connection refused error. FYI: I can ping server.network.local successfully. But when I telnet server.network.local 1433/1434, I got telnet: Unable to connect to remote host: Connection refused.
Tags
<c#><java><sql>
Title
What is the difference between Java and C# when it comes to connect to Sql Server Database?
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USJohn Saunders
UserOwnerUserId
1. UStmaster
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.