I need a lolution for Connection String.

[tranglt]

Hi Everyone! I have a proplem of connection string to connect database I have a SQL server, thi Name server this MSSQLxxx; (Not Local) User: Xman; Pass: Xmankk; DataBase: TLxxx; Now, I Dev a website in .Net 1.x & SQLSERVER 2000. I use a connection string: "user id=Xman;pwd=Xmankk;data source=MSSQLxxx;initial catalog=TLxxx;timeout=90" But, can not connect to database. I try doing connect to the database by tool of sqlserver 2000, it is sucessful, I can view all information of the data (TLxxx), I can view Tables, views ,... I can Create table there. This is the my code: public class UserDB { private string connectionString; public UserDB() { // I try Hardcode to test connection string. connectionString = "user id=Xman;pwd=Xmankk;data source=MSSQLxxx;initial catalog=TLxxx;timeout=90";//ConfigurationSettings.AppSettings["connectionString"]; } public int GetUserID(string userName, string pass) { SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("TL_GetUserID", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@userName", SqlDbType.NVarChar,50)); cmd.Parameters["@userName"].Value = userName; cmd.Parameters.Add(new SqlParameter("@password", SqlDbType.NVarChar,32)); cmd.Parameters["@password"].Value = pass; try { con.Open(); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { return Convert.ToInt32(reader["UserID"]); } else { return -1; } } catch(SqlException) { throw new ApplicationException("data "); } finally { con.Close(); } return -1; } .... } Please, show me solution. Many Thank. I Don't Want Say No Wealth

[enjoycrack]

Just wonder what the expection you got? << >>