Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par Ahmad Khadrah , senior Software Developer , wsm Company
Date de publication: 2013/04/24
Zubair Ali
par Zubair Ali , Software Developer III , S&P Global

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

 

Eng Nasser
par 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
par 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
par 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