Re: Why do I get "name 'LocalSqlServer' was not found" when my app uses MySQL?

re:
as far as i know you can't disable it

Sure you can :

<remove name="LocalSqlServer"/>

Then, you can clear the connection strings :

<connectionStrings>
<clear />
<add providerName="blah, blah...>

and then, clear the default provider and specify a custom provider:

<membership defaultProvider="YourSqlProvider">
<providers>
<clear />
<add name="YourSqlProvider"

See :
http://www.codeproject.com/aspnet/MySQLMembershipProvider.asp
for sample access code to MySql using ASP.NET 2.0.



Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================
<digitaljeebus@xxxxxxxxx> wrote in message
news:1150300375.351995.150100@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
the LocalSqlServer set up in the machine.config file is the one that
stores your Session variables, and other browser data ... as far as i
know you can't disable it (but i could be wrong) so if you are using a
mysql database you need to edit that machine.config file to point to
your mysql server ... i'm not sure if there's anything else that needs
to be done, but google around and you'll find something =)

Juan T. Llibre wrote:
That error is telling you that the SQL Server specified in your Provider

connectionStringName="LocalSqlServer"

can't be found.

If you're using MySQL as your database platform as a custom Provider,
you beed to have somthing akin to :

<add name="MySqlProfileProvider"

in web.config.

See :

http://www.codeproject.com/aspnet/MySQLMembershipProvider.asp

for sample access code to MySql using ASP.NET 2.0.



Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================
"webonomic" <webonomic@xxxxxxxxx> wrote in message
news:1150167336.760393.145950@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
"The connection name 'LocalSqlServer' was not found in the applications
configuration or the connection string is empty."

I get the error above. It tells me the error is in
Line 120: <profile>
Line 121: <providers>
Line 122: <add name="AspNetSqlProfileProvider"
connectionStringName="LocalSqlServer" applicationName="/"
type="System.Web.Profile.SqlProfileProvider, System.Web,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
Line 123: </providers>
Line 124: </profile>

in the machine.config.

Ok that's all fine and dandy, but why the heck is it even looking for
LocalSqlServer? I am using MySQL as the DB. I don't have a SQL
Express or other Microsoft DB in the app. There is nothing in my
Web.Config or my code (unless it was autogenerated without my
knowledge) that suggests I am using a SQL Express or MSSQL or MSAccess
DB.

So what is it about an Asp.net application to make it search for the
LocalSqlServer? How can I stop it from doing that?




.

Relevant Pages

  • Re: Which MySQL Provider.
    ... Read the GPL, ... The GPL isn't different for this particular provider. ... We wanted to target Mysql in our o/r mapper. ... for their database. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Normalisierung: brauche Tipp...
    ... Default engine as of MySQL 3.23 with great performance: ... CSV storage engine: CSV ... Federated MySQL storage engine: FEDERATED ... Provider dir so etwas noch anbietet, ...
    (de.comp.datenbanken.mysql)
  • Re: Using SQL on Development Machine
    ... Download the MySQL bits for your OS. ... you need a provider if you are ... do I need to download and install this in order to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Why do I get "name LocalSqlServer was not found" when my app uses MySQL?
    ... clear the default provider and specify a custom provider: ... for sample access code to MySql using ASP.NET 2.0. ... Juan T. Llibre, asp.net MVP ... I don't have a SQL ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Access und MySQL
    ... dass Du einen Provider findest der einen ODBC-Zugriff ... Zum technischen hintergrund Access MySQL findest ... Prev by Date: ... Next by Date: ...
    (microsoft.public.de.access)