Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 4060
Home > Forums > C# >

connection string for access the another system database

Posted by Kalaikathiravan under C# on 12/22/2012 | Points: 10 | Views : 1734 | Status : [Member] | Replies : 3
Write New Post | Search Forums | AnsweredResolved Posts | Un Answered Posts | Forums Home 
connection string for accessing another system database in using windows application using c#. I need explanation also please tell me



Reply | Reply with Attachment
Alert Moderator 

Responses

Posted by: Guna27 on: 12/23/2012 [Member] Starter | Points: 25

Up
0
Down
//Connection String
public static SqlConnection con=new SqlConnection("Data Source=SP\\SQLEXPRESS;Initial Catalog=MyDB;User ID=sa;Password=boss;");

Before that you have to configure the SQL Server Surface Area Configuration

Open--> SQL Server Surface Area Configuration--> Surface Area Configuration for Features--> Then Enable all the service
Within(SqlExpress -->Database Engine)--OK

This configuration allows us to access within a Intranet


Guna..............

Kalaikathiravan, if this helps please login to Mark As Answer. | Alert Moderator
Posted by: Kalaikathiravan on: 12/24/2012 [Member] Starter | Points: 25

Up
0
Down
what means 'Sp' guna plz explain me.........

Kalaikathiravan, if this helps please login to Mark As Answer. | Alert Moderator
Posted by: Guna27 on: 12/26/2012 [Member] Starter | Points: 25

Up
0
Down
Data Source=SP\\SQLEXPRESS
The term--SP indicate the Specific machine name which we want to access in intranet
SQLEXPRESS ->It represent SQL Server name within the machine (SP)

Guna..............

Kalaikathiravan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response

Latest Posts