Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What's the connection string to connect between a program and the database on a server with real IP in C#؟

user-image
Question added by Ahmad Khadrah , senior Software Developer , wsm Company
Date Posted: 2013/04/24
Zubair Ali
by Zubair Ali , Software Developer III , S&P Global

Visit http://www.connectionstrings.com/ for all the connectionstrings based on various scenarios.

 

Eng Nasser
by Eng Nasser , programmer_ اعداد برامج , الشركة الوطنية لانشاء وتنمية وادارة الطرق

Data Source=tcp:(ip address),(port number);User Id=...; Password >>> لو انت على نتورك خاصه .....................................
اما لو انت والسرفر على نفس النتورك connection string easy : SqlConnection con = new SqlConnection(@"server = name of server; integrated security = sspi;user id = ----;password = -------;Database=name of database")

Maher Alsilwy
by Maher Alsilwy , CONSULTANT , B7R DESIGN WWW.B7RDES.COM

Very simple.
If you can connect to the local DBMS then the same way you connect to the real time DBMS with the change of the connection string parameters.
Have a look also on this: http://www.connectionstrings.com

Waleed AlZoghby
by Waleed AlZoghby , Software Engineer , OpenWare Information System Consulting Co.

The connection string will vary according to the Data Framework that you will use, In case if you will use ADO.NET so you can pick one of the following data providers to use according to your requirements such as SQLClient, OleDb, Odbc and OracleClient you can take a look on the following link "http://msdn.microsoft.com/en-US/library/ms254500(v=vs.80).aspx".
In case if you will use Entity Framework (EF) you can take a look on this link "http://msdn.microsoft.com/en-us/library/cc716756.aspx".

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.