Prob: Connecting hosting SQL server
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