SQL Server -> MYSQL (Connection String)

Hello,

I have some small issue,

I have build a aspx + aspx (cs) file on localhost with SQL server 2005,
But now want to shift it to live server, and that live server has just MYSQL and no SQL Server.

Code For ASPX (cs) file with connection string in Bold :

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class LOGIN_PAGE : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection("server=localhost;database=registration;Trusted_Connection=Yes");
SqlCommand comm = new SqlCommand("select * from admin");
SqlCommand comm1 = new SqlCommand("select * from register");
SqlDataAdapter da, da1;
DataSet ds, ds1;
int count, count1, x = 0;
string designation;
protected void Page_Load(object sender, EventArgs e)
{

comm.Connection = conn;
conn.Open();
da = new SqlDataAdapter(comm);
ds = new DataSet();
da.Fill(ds, "login");
count = ds.Tables[0].Rows.Count;
conn.Close();

comm1.Connection = conn;
conn.Open();
da1 = new SqlDataAdapter(comm1);
ds1 = new DataSet();
da1.Fill(ds1, "user name");
count1 = ds1.Tables[0].Rows.Count;
conn.Close();

}
protected void Button1_Click(object sender, EventArgs e)
{
Session["roll_no"] = TextBox1.Text;
if (RadioButton1.Checked == true)
{
designation = "student";
}
else
{
if (RadioButton2.Checked == true)
{
designation = "T.P.O";
}
else
{
if (RadioButton3.Checked == true)
{
designation = "administrator";

}
else
{
if (RadioButton4.Checked == true)
{
designation = "management";
}
else
{
designation = "teacher";
}
}

}
}
Session["designation"] = designation;
for (int i = 0; i < count; i++)
{
if (TextBox1.Text == ds.Tables[0].Rows[0].ToString() && ds.Tables[0].Rows[2].ToString() == "yes"&&ds.Tables[0].Rows[3].ToString()==designation)
{
for (int j = 0; j < count1; j++)
{
if (TextBox1.Text == ds1.Tables[0].Rows[j][0].ToString() && TextBox2.Text==ds1.Tables[0].Rows[j][1].ToString())
{
//Response.Write(ds1.Tables[0].Rows[j][2].ToString());
Session["User_name"] = ds1.Tables[0].Rows[j][2].ToString();
Session["designation"] = designation;
if (TextBox1.Text == "1")
{
Session["director"] = "director";
}
if (designation == "management")
{
x = 2;
}
else
{
if (designation == "T.P.O")
{
x = 3;
}
else
{
if (designation == "administrator")
{
x = 4;
}
else
{
if (designation == "student" ||designation=="teacher")
{
x = 1;
}
}

}
}

break;
}

}
break;

}

}

if (x == 0)
{
Response.Write("either the user is not registered or it enter the wrong entries");
}
else
{
if (x == 1)
{
Response.Redirect("STUDENT_HOME_PAGE.aspx");
}
else
{
if (x == 2)
{
Response.Redirect("Account_entry.aspx");
}
else
{
if (x == 3)
{
Response.Redirect("Placement_sir_message.aspx");

}
else
{
if (x == 4)
{
Response.Redirect("Administrator_student_entry.aspx");
}
}

}
}
}

}
protected void Button2_Click(object sender, EventArgs e)
{

Response.Redirect("registration.aspx");
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
Response.Redirect("forget_your_password.aspx");

}
}

Click to expand...

Now, that i have restored the database, ( just few empty tables ) on MYSQL, but i need to change connection string ?

As while opening aspx page , we get this error now

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Click to expand...

Any Advice ?

How can we make this work with MYSQL , Instead of SQL Server ?

Log in or Sign up

SQL Server -> MYSQL (Connection String)

TheOwner Active Member

JenniP Peon

Log in or Sign up

SQL Server -> MYSQL (Connection String)

TheOwner Active Member

JenniP Peon

Useful Searches