[Mono-aspnet-list] Fw: [MonoDevelop] Also newbie

[Lars Ebeling]

The mail down I posted to the monodevelop-list without any reaction, hope I 
get better response here.
I have installed the mysql-connector version 6.4.4 with gacutil. I have 
created a .pc file with vi.
You could have a look at http://leopg9.np-ip.org/Sqltest2/ this page runs on 
Ubuntu and is created with monodevelop.
On thew Ubuntubox I installed Virtualbox with Windows XP and Sqlserver. That 
is what you see.


Dear all,

I lifted a small application from MS VS 2010 to Ubuntu 10.04 and
mono-develop 2.8.6.3.
On MS I connected to a SqlServer database, this still works on mono-develop,
but I want to get rid of the MS connection.
 In Default.aspx I have a DropDownlist which I want to fill from the
database. You find codesnippets below.


<form runat="server">

<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"

DataSourceID="SqlDataSource1" DataTextField="Ã"mne" DataValueField="FID">

</asp:DropDownList>



<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:larsConnectionString %>"

SelectCommand="SELECT * FROM [my_forum]"></asp:SqlDataSource>



>From web.config



<add name="larsConnectionString" connectionString="Initial Catalog=lars;Data
Source=127.0.0.1;User Id=root;Password=secret;Pooling=False"

providerName="MySql.Data.MySqlClient"/>



NB the commented code down works.

<!-- <add name="larsConnectionString" connectionString="Data
Source=192.168.0.113;Initial Catalog=lars;User ID=lars;Password=secret"

providerName="System.Data.SqlClient" /> -->


This is what I get when I run Debug in monodevelop

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+SocketAsyncResult.CheckIfThrowDelayedException ()
[0x00000]
in <filename unknown>:0

  at System.Net.Sockets.Socket.EndConnect (IAsyncResult result) [0x00000] in
<filename unknown>:0

  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32
port, Int32 packetSize,
Int32 timeout, TdsVersion tdsVersion) [0x00000] in <filename unknown>:0



Version information: Mono Runtime Version: 2.10.8.1 (Debian
2.10.8.1-1~dhx1~lucid1); ASP.NET Version: 2.0.50727.1433

-- 
Med vänliga hälsningar/Regards
Lars Ebeling
Rentier

http://leopg9.no-ip.org


"I am not young enough to know everything."
-- Oscar Wilde