[Mono-list] Problem using MySql with a GridView

Tue May 1 23:20:15 EDT 2007

I am trying to display a basic gridview with data queried from MySql.  My
code and the subsequent error follow. I have the MySql assembly loaded into
references.

<%@ Page Language="C#" Inherits="webapp1.Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
	<title>Default</title>
</head>
<body>
	<form id="form1" runat="server">
		<asp:TextBox id="textBox1" runat="server"/>
		<asp:Button id="button1" runat="server" OnClick="onButtonClick"/> 
		<asp:Gridview id="GridView1" runat="server" autogeneratecolumns="true"
datasourceid="mydatasource">
			<Columns>
			<asp:BoundField DataField="name_id" HeaderText="id"
SortExpression="name_id" />
			<asp:BoundField DataField="first_name" HeaderText="first"
SortExpression="first_name" />
			<asp:BoundField DataField="last_name" HeaderText="last"
SortExpression="last_name" />
			</Columns>
		</asp:GridView>
		<asp:SqlDataSource ID="mydatasource" runat="server"
ConnectionString="Server=localhost;Database=films;User
ID=user;Password=password;Pooling=false;"
ProviderName="MySql.Data.MySqlClient" SelectCommand="SELECT * FROM
names"></asp:SqlDataSource>

	</form>
</body>
</html>

Server error in '/' application
Description: Error processing request.

Error Message: HTTP 500.

Stack Trace:

System.Data.SqlClient.SqlException: Server does not exist or connection
refused. ---> Mono.Data.Tds.Protocol.TdsInternalException: Server does not
exist or connection refused. ---> System.Net.Sockets.SocketException:
Connection refused
  at System.Net.Sockets.Socket.Connect (System.Net.EndPoint remote_end)
[0x00000] 
  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32
port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x00000] ---
End of inner exception stack trace ---

  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32
port, Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x00000] 
  at Mono.Data.Tds.Protocol.Tds..ctor (System.String dataSource, Int32 port,
Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x00000] 
  at Mono.Data.Tds.Protocol.Tds70..ctor (System.String server, Int32 port,
Int32 packetSize, Int32 timeout) [0x00000] 
  at (wrapper remoting-invoke-with-check) Mono.Data.Tds.Protocol.Tds70:.ctor
(string,int,int,int)
  at System.Data.SqlClient.SqlConnection.Open () [0x00000] --- End of inner
exception stack trace ---

  at System.Data.SqlClient.SqlConnection.Open () [0x00000] 
  at System.Data.Common.DbDataAdapter.Fill (System.Data.DataSet dataSet,
Int32 startRecord, Int32 maxRecords, System.String srcTable, IDbCommand
command, CommandBehavior behavior) [0x00000] 
  at System.Data.Common.DbDataAdapter.Fill (System.Data.DataSet dataSet,
System.String srcTable) [0x00000] 
  at (wrapper remoting-invoke-with-check)
System.Data.Common.DbDataAdapter:Fill (System.Data.DataSet,string)
  at System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect
(System.Web.UI.DataSourceSelectArguments arguments) [0x00000] 
-- 
View this message in context: http://www.nabble.com/Problem-using-MySql-with-a-GridView-tf3678498.html#a10279570
Sent from the Mono - General mailing list archive at Nabble.com.