connection string for access the another system database

Posted by Kalaikathiravan under C# on 12/22/2012 | Points: 10 | Views : 934 | Status : [Member] | Replies : 3
connection string for accessing another system database in using windows application using c#. I need explanation also please tell me




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