asp.net webpages mysql connection

Question

I'm trying to access a mysql database hosted online, but every time getting the same error. Here is the error message, code and web.config connectionStrings I used:

"An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code"

"Additional information: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

            <div class="col-md-12">
                @{
                    var db = Database.Open("SQLServerConnectionString");
                    var selectQueryString = "SELECT * FROM `emp`";
                    var data = db.Query(selectQueryString);
                    var grid = new WebGrid(data);
                }
                @grid.GetHtml()
            </div>

  <connectionStrings>
    <add
      name="SQLServerConnectionString"
      connectionString= "server=**.***.***.*;database=Zain;uid=Zain;pwd=Zain123"
      providerName="System.Data.SqlClient" />
  </connectionStrings>

stovroz · Accepted Answer · 2015-04-10 15:10:14Z

1

You're passing in the string "SQLServerConnectionString" as a connection string, you should be passing a variable containing your connection string.

var db = Database.Open("SQLServerConnectionString");

should be something like:

var connectionString = ConfigurationManager.AppSettings["SQLServerConnectionString"]
var db = Database.Open(connectionString);

edited Apr 10, 2015 at 15:10

answered Apr 10, 2015 at 15:02

stovroz

7,1052 gold badges52 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Anas Jawabra Over a year ago

im getting this error : The name 'ConfigurationManager' does not exist in the current context

Anas Jawabra Over a year ago

i used System.Web.Configuration.WebConfigurationManager.AppSettings["ServerConnectionString"] instead of ConfigurationManager.AppSettings["SQLServerConnectionString"] but now i'm getting this error : An exception of type 'System.ArgumentException' occurred in WebMatrix.Data.dll but was not handled in user code Additional information: Value cannot be null or an empty string.

Collectives™ on Stack Overflow

asp.net webpages mysql connection

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related