Prob: Connecting hosting SQL server

Jul 25 2006 8:48 AM
I'm using a webhosting with ASP.NET1.1 and MS SQL Server Support. i've created a MS SQL database named: Pakbus i login into SQL server database with username: PBC and password: mypassword (this username and password is which i use in my hosting control panel to access the SQL server database) I've made a table name: info I'm using this Connection String in ASP.Net 1.1: user id=pbc;pwd=mypassword;server=localhost;database=pakbus;integrated security;sspi;Connection Timeout=10; I've also made a login in database (under Security > Logins) with name: PBC But when i execute this command i'm having problem: "insert into info values(..........)"; I'm running this Command under this code: private void Button1_Click(object sender, System.EventArgs e) { conn.ConnectionString = txtString.Text; com.Connection = conn; com.CommandText = txtQuery.Text; conn.Open(); com.ExecuteNonQuery(); conn.Close(); } Where txtString is a Textbox in which i type the Connection String written above. and txtQuery is where is type the TSQL Insert Command written above. I'm facing this Error everytime: "Server deosn't exist or Access Denied" PLZ help me in making connection string in ASP.Net1.1

Answers (1)