pls let me know anything is wrong in my connectionstring

Posted by Chanti444 under ASP.NET on 11/21/2011 | Points: 10 | Views : 966 | Status : [Member] | Replies : 3
hi,

this is my serverip( 174.120.146.10), user: jdemos24_gallery; password: yF8uslkUQOtx;

Database Name: jdemos24_gallery;

already i wrote above details in my connection string but getting error mesage after debugging.

i cant understand what should i wrong here .......pls chek me once and tell me what is wrong here ........i wll send my error screen short .........

protected void Button1_Click(object sender, EventArgs e)
{
MySqlConnection con = new MySqlConnection("Data Source=174.120.146.10;database=jdemos24_gallery;User ID=jdemos24_gallery;Password=yF8uslkUQOtx;Persist Security Info=True;");
con.Open();
Response.Write("welcome");
con.Close();
}

satya


Responses

Posted by: Meetsatyajee on: 12/8/2011 [Member] Starter | Points: 25

Up
0
Down
Hi Please Use this to Resolve your Issues.
Standard Security:
1. "Data Source=Your_Server_Name;Initial Catalog= jdemos24_gallery;UserId=jdemos24_gallery;Password=jdemos24_gallery;"
2. "Server=Your_Server_Name;Database=jdemos24_gallery;UserID=jdemos24_gallery;Password=jdemos24_gallery;Trusted_Connection=False"

Trusted connection:
1. "Data Source=Your_Server_Name;Initial Catalog=jdemos24_gallery;Integrated Security=SSPI;"
2."Server=Your_Server_Name;Database=jdemos24_gallery;Trusted_Connection=True;"

Chanti444, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: perfectchourasia-9163 on: 12/8/2011 [Member] Starter | Points: 25

Up
0
Down
Please try once replace User ID =uid and Password=Pwd

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

Chanti444, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Varung on: 12/9/2011 [Member] Starter | Points: 25

Up
0
Down
write polling=true in connectionstring

G.Varun

Chanti444, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response