asp.net连接远程mysql数据库???

来源:百度知道 编辑:UC知道 时间:2024/06/27 15:28:19
如下代码:
string conn = "Data Source=61.133.257.159;UserID=***;Password=***;DataBase=channel;Charset=gb2312;";

MySqlConnection con = new MySqlConnection(conn);
con.Open();
......
con.Close();
老是连接失败

用ODBC连接MySQL和ASP.NET

http://www.builder.com.cn/2005/0118/171283.shtml

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
SqlConnection con = new SqlConnection();
SqlDataAdapter ada;
DataSet dst;
private void Form1_Load(object sender, EventArgs e)
{
con.ConnectionString = "server=(local);database=student;integrated security=sspi";
con.Open();
ada = new SqlDataAdapter("sele