ASP and MySQL - Connection refused

**antinonavk** · 02-01-2010 01:33 PM

Hi all. Please help me. I run aspx site, but write error:

Server Error in '/' Application
--------------------------------------------------------------------------------
Connection refused
Description: HTTP 500. Error processing request.
Stack Trace:
System.Net.Sockets.SocketException: Connection refused
at System.Net.Sockets.Socket.Connect (System.Net.EndPoint remote_end) [0x00000]
at System.Net.Sockets.Socket+Worker.Connect () [0x00000]
--------------------------------------------------------------------------------
Version information: Mono Version: 2.0.50727.1433; ASP.NET Version: 2.0.50727.1433

My default.aspx:

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="MySql.Data.MySqlClient" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>CD cat</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script runat="server">
private void Page_Load(Object sender, EventArgs e)
{
string connectionString = "server=localhost;Database=antinona_db;userid=anti non_ad;password=x;Pooling= false;";
MySqlConnection dbcon = new MySqlConnection(connectionString);
dbcon.Open();
Response.Write("dbcon.State.ToString()");
dbcon.Close();
dbcon = null;

}
</script>
</head>
<body>
<h1>Artists</h1>
</body>
</html>

My web.config:

<?xml version="1.0" ?>
<configuration>
<appSettings />
<connectionStrings />
<system.web>
<customErrors mode="Off" />
</system.web>
</configuration>
<configuration>
<system.web>
<compilation>
<assemblies>
<add assembly="MySql"/>
<add assembly="MySql.Data"/>
</assemblies>
</compilation>
</system.web>
</configuration>

File mysql.data.dll (version 6.2 - .Net and mono) in /public_html/bin.

Please help me.:dunno: