connect database located in another program

Question

0.00/5 (No votes)

See more:

hi
I want to connect to database in another program
I use this code

C#

connection.ConnectionString = @"Server=localhost;Integrated Security=SSPI";

but what I have to put instead of "localhost" to connect to database that are located in another program ?

thanks in advance :)

Posted 17-Apr-12 23:36pm

maxpower12345

Add a Solution

5 solutions

Solution 5

Hello

Try this

C#

con = New SqlConnection("Data Source=MachineNameOnWhichDataBaseIsPlaced;Initial Catalog=DataBasename;Persist Security Info=True;User ID=SQLServerId;Password=Password")

Posted 19-Apr-12 23:58pm

DeepakThukral

Updated 20-Apr-12 0:20am

v2

Add a Solution

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

enggmichael · Accepted Answer · 2012-04-17T23:41:00

Solution 1

Trythis one

add name="Constr" connectionString="Data Source=path of server name(its may be your LAN Remote server );Initial Catalog=Database name; Persist Security Info=True;User ID=useid;Password=password;" providerName="System.Data.SqlClient

Posted 17-Apr-12 23:41pm

enggmichael

Comments

maxpower12345 18-Apr-12 16:05pm

thanks a lot :) enggmichael

Mohammad A Rahman · Accepted Answer · 2012-04-18T00:52:00

Solution 3

Hope it helps The Connection String Reference[^]

:)

Posted 18-Apr-12 0:52am

Mohammad A Rahman

Comments

Vipin_Arora 18-Apr-12 8:43am

+5 for nice link

Mohammad A Rahman 18-Apr-12 8:52am

Thanks Vipin :)

Tony Tom.k 18-Apr-12 8:58am

good one

Mohammad A Rahman 18-Apr-12 9:01am

Thanks Tony :)

maxpower12345 18-Apr-12 16:04pm

thanks a lot :) Mohammad

Mohammad A Rahman 18-Apr-12 17:55pm

not a problem :)

Vipin_Arora · Accepted Answer · 2012-04-18T02:42:00

Solution 4

For any ConnetionString, visit:

http://www.connectionstrings.com/[^]

click on Database Servers that you are using and get the connection string...

Posted 18-Apr-12 2:42am

Vipin_Arora

Comments

maxpower12345 18-Apr-12 16:05pm

thanks a lot wipin :)

Dipak V Nakum · Accepted Answer · 2012-04-18T00:10:00

Solution 2

Try below Solution.

con = New SqlConnection("Data Source=192.168.101.102;Initial Catalog=test_data;Persist Security Info=True;User ID=wml;Password=win")

Posted 18-Apr-12 0:10am

Dipak V Nakum

Comments

maxpower12345 18-Apr-12 16:06pm

thanks a lot Dipak :)

Dipak V Nakum 21-Apr-12 6:52am

Okey

connect database located in another program

5 solutions

Solution 1

Solution 3

Solution 4

Solution 2

Solution 5

Add your solution here

Preview 0

connect database located in another program

5 solutions

Solution 1

Solution 3

Solution 4

Solution 2

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us