[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