Kanhialal kk

Kanhialal kk

  • NA
  • 234
  • 333.7k

Database access from main Server

Mar 26 2012 2:38 AM
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...

Answers (3)