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
_______________________________________________
Mono-aspnet-list mailing list
Mono-aspnet-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-aspnet-list
