Bug #28646 configurate connection in vs2005

• Submitted: 24 May 2007 10:38
• Modified: 24 May 2007 21:48
• Reporter: Steffen Rathsack
• Status: Duplicate
• Category: Connector / NET
• Severity: S3 (Non-critical)
• Version: 5.1.1.0
• OS: Windows (xp pro sp2)
• CPU Architecture: Any
• Tags: configurate connection with connection wizard ( in Vs 2005 sp1)

[24 May 2007 10:38] Steffen Rathsack

Description:
If I configurate a connection with the Connection wizard 
in my Visual studio 2005 pro sp1 (Framework v2.0.50727), 
it's all fine I can add username etc. the Test Connection works
, but when i try to configurate the website 
for the roleprovider i became an error that the site 
can't connect to the Server.  

How to repeat:
->righ click on Cennections in Server Explorer
->click addConnection
->use Mysql dataprovider
->fill in the username etc.
->click ok
->open your website
->use the "Asp.net Configuration" button

Suggested fix:
i fixed it like this:

Changed:

<connectionStrings>
    ...
    <add name="LocalMySqlServer" connectionString="" />
</connectionStrings>

to something like this:

<connectionStrings>
    ...
    <add name="LocalMySqlServer" connectionString="Server=localhost;Uid=root;Pwd=mypassw;Database=test;" />
</connectionStrings>

[24 May 2007 21:48] Reggie Burnett

This is basically a duplicate of 28648 which is now fixed.