[Mono-aspnet-list] Problem with Predefined Connection String

[Alexander M. Batishchev]

Hi,

Be sure that type specified in providerName works properly.
Maybe everything is ok with connection string but with type - it is not.
Is MySQL client assembly placed in /bin? Is it specified in
configuration/system.web/assemblies/add?
Is your project a web app or a web site?

Alex

-----Original Message-----
From: mono-aspnet-list-bounces at lists.ximian.com
[mailto:mono-aspnet-list-bounces at lists.ximian.com] On Behalf Of
stevenjamesfrank
Sent: Tuesday, July 13, 2010 11:04 PM
To: mono-aspnet-list at lists.ximian.com
Subject: [Mono-aspnet-list] Problem with Predefined Connection String


I have an ASP.NET app up and running on SUSE, with mySql 5.0.67. 

I have the Connector so that I can us Visual Studio to manage my databases,
that works great. 

I also can, from within my application, use the MySqlConnection class to
open a connection and make whatever kind of SQL call I want and this also
works great. 

Based on the above, I'm pretty sure I have (almost) everything configured
correctly. 

My problem is with using the asp:SqlDataSource tag. I have the
ConnectionString and ProviderName set to reference my ConnectionStrings area
of the web.config file and as far as that goes, I think its is correct
because when I debug( Run the app on my Windows workstation connecting to
the remore DB) it works fine. 

However, when I move the app up to the SUSE box I get the following: 
Failed to find or load the registered .Net Framework Data Provider
'MySql.Data.MySqlClient'. 

Here is the important part of my SqlDataSource tag: 
<asp:SqlDataSource ID="SqlUser" runat="server" ConnectionString="<%$
ConnectionStrings:csBookm %>" ProviderName="<%$
ConnectionStrings:csBookm.ProviderName %>" 

Here is the Connection string from web.config: 
<connectionStrings> 
<add name="csBookm"
connectionString="server=myserver;uid=myuser;pwd=mypwd;database=mydb;"
providerName="MySql.Data.MySqlClient"/> 
</connectionStrings>