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

stevenjamesfrank stevenjamesfrank at yahoo.com
Tue Jul 13 15:03:30 EDT 2010


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>
-- 
View this message in context: http://mono.1490590.n4.nabble.com/Problem-with-Predefined-Connection-String-tp2287870p2287870.html
Sent from the Mono - ASP.NET mailing list archive at Nabble.com.


More information about the Mono-aspnet-list mailing list