I can´t connect to mine mysql server. What is wrong ?
connect to Mssql works with this:
using (System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection("Server=per-191345.mssql.binero.se;Database=191345-per;User ID=191345_as37852;Password=XXXXXXXX;"))
But connect to mysql doesn´t work with this:
using (System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection("Server=per-191345.mysql.binero.se;Database=191345-per;User ID=191345_th26552;Password=XXXXXXXX;"))
I´m a beginner.
Using Visual studio 2012 C#.
Intern connection to Binero webserver
Text in top of aspx file:
<%@ Page Language="C#" % DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
html xmlns="http://www.w3.org/1999/xhtml" >
[SqlException (0x80131904): 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)]
Refer the discussion thread at WHUK's Forum - MySQL ConnectionString
MySQL Connection String Samples - ConnectionStrings.com
Did you get it to work?
I have the exact same issue and would really appreciate a concussion.