Getting Sql server Instance in Network

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

HI I am developing an application which is using Sqlserver 2005 with Winforms.My requirement is I have to build an application or add in for an windows application which is using sqlserver 2005.Now my Problem is the application have two part one brain an d other is work station now one can start brain in one machine and then can start workstation form another machine in network.I want to get the Sqlserver used by the Brain .How to do that Please reply soon running out of ideas

Thanks In Advance

Devopriyo

Posted 5-Mar-12 18:22pm

Member 8669805

Add a Solution

Comments

Charlemagne Gustilo 6-Mar-12 0:34am

Hi! Are you trying to create applications that communicate with each other on the network, where in the workstation asks the brain it's sql server connection and the brain sends back the information? You can try System.Net.Sockets. As for sql server connection, both needs to have SQL Client in order for them to connect on the same server.

Member 8669805 7-Mar-12 8:01am

Hi Can you give me some more detail.Please share your experience if you have done something like this before.
Thanks In Advance

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sachin10d · Answer 1 · 2012-03-05T19:00:00

Solution 1

Use System.Data.SqlClient.SqlConnectionStringBuilder

C#

string strCn=@"server=SQLInstance;database=DBName;user id=sa;password=password";
SqlConnectionStringBuilder cnBuilder = new SqlConnectionStringBuilder(strCn);
string db = cnBuilder.InitialCatalog;
string server = cnBuilder.DataSource;

Posted 5-Mar-12 19:00pm

sachin10d

Updated 5-Mar-12 19:02pm

v2

MaulikDusara · Answer 2 · 2012-03-05T19:13:00

Solution 2

Hi,

Please follow these links:

Multi-threaded Client/Server Socket Class[^]
Simple Client-server Interactions using C#[^]
Introduction to TCP client server in C#[^]
A TCP/IP Server written in C#[^]
Client Server Communication[^]

Posted 5-Mar-12 19:13pm

MaulikDusara