how to connect my application with the database in other computer ??

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Hello , I just finished my C# application (.Net 2008) it contains CrystalReports and deal with SQL server 2005 , now I want to but the Data Base on computer(lets call it DB-Computer) and the application on another computer(lets call it Client-Computer), I just know that I must install (.NET Framework 3.5) on Client-Computer to run the application ..
now I need to know what I must do to make it work , step by step please..
* what i must install on DB-Computer?
* what i must install on Client-Computer?
* what the connection string will be?

i get this answer;

1-what i must install on DB-Computer?

SQL Server

2-what i must install on Client-Computer?

.NET framework, also Crystal report run-time framework

3- what the connection string will be?

connection string= Data Source=DB-Computer IPAddress;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
Attachment

now i need to know

* if the db-computer ip=0123456789 what tha Connection String will be ?
* what is DBMSSOCN mean ?
* wont i need any SQL tool to install on Client-Computer ?

[edit]Just a tidy up... - OriginalGriff[/edit]

Posted 15-Jan-11 1:41am

MohammedSabry

Updated 15-Jan-11 1:52am

OriginalGriff

v2

Add a Solution

2 solutions

Solution 1

Firstly, an IP address is not like that: it is four gorups of numbers, separated by '.' characters: "192.168.1.1" or similar. Look at your router / switch and find teh IP address, or ask you DB administrator. Mostly, I use server references rather than IP addresses unless I am connecting to a static IP on the internet. (local IP addresses are not always fixed and can move with cable changes, etc.)

Secondly, DBMSSOCN is just a library name, part of SQL server. Don't worry about it.

Thirdly: No. The necessary bits for your app to communicate with SQL server will be installed as part of the .NET framework.

Posted 15-Jan-11 1:58am

OriginalGriff

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)

Estys · Accepted Answer · 2011-01-15T01:59:00

Solution 2

1 substitute "DB-Computer IPAddress" with your IP-address (xxx.xxx.xxx.xxx)

2 for DBMSSOCN see http://www.connectionstrings.com/Articles/Show/define-sql-server-network-protocol[^]

3 No, not if you don't want to manually query DB's. The .NET framework is sufficient.

Posted 15-Jan-11 1:59am

Estys