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

[The_Assimilator]

So... you changed the data provider from MSSQL to MySQL, but are still 
using a MSSQL database, and you're wondering why things don't work?

If that's not what you did, please explain more clearly.

On 2012-03-24 19:52, Lars Ebeling wrote:
> 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
>