Database access from main Server

Question

Hi...
I am working on desktop application and i am using visual studio 5(2.0) with sql server 2000.
i have database on main server. how can create my connection string
such as..

SqlConnection conn = new SqlConnection();
string str = "servername.txt";
File.SetAttributes(str, (FileAttributes)FileAttributes.Normal);
StreamReader reader = new StreamReader(str);
string str2 = reader.ReadToEnd().Trim();
conn.ConnectionString = "Server = " + str2 + ";password=as;user ID=sa;Database = Elegent;";

..
i want to pass port number
like
"tcp://" + ServerName.server + ":8082/WEBIIF"
so how it is possible to pass above port in connection string.
please help...

Jignesh Trivedi · Answer

hi Data Source=190.190.200.1001433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword; SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));uid=myUsername;pwd=myPassword; please refer http://www.connectionstrings.com/oracle http://www.connectionstrings.com/sql-server-2005 hope this help.

Kanhialal kk · Answer

thanks sir but your reference not meets with my requirement. so please your help is needed.

Jignesh Trivedi · Answer

hi Please refer http://support.microsoft.com/kb/313295 or http://developer.mimer.com/documentation/mdp_93/Reference/source/mimer.data.client.mimerconnection.connectionstring.html hope this help.