Can´t connect to MySql
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" >
Error: [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)]
2 answers
Hello,
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.
Post an answer but please login first
Similar Questions
Remote MySQL Linked Server in SQL Server, only show names of the tables.
Remote MySQL Linked Server deployed in SQL Express Management Studio do not show any content and structure, it only LIST NAME of the tables belongs to the remote connected MySQL database
Connection error to Azure MySQL from Visual Studio 2012 Ultimate
I have visual studio 2012 Ultimate on my machine and am trying to connect MySQL on Azure using MySQL .Net Connector 6.8.3 Below is my connection string Server={Server};Port=3306;Database={DbName};Uid={user};Pwd={pwd};sslMode=Prefered;
MySQL Connection behind a Proxy
Is it possible to connect with MySQL 3.1.13 behind a proxy server? Like this : MySQL.ConnectionString = "Driver={MySQL ODBC 5.1 Driver};Server=dbServ;Database=dbName;User=dbUser;Password=dbPass;Option=3;ProxyServer=proServer;ProxyUser=proUser"
Connect to MYSQL
I would like to coonect my app vb.net to mysql but the message error below
COMPILATION ERROR
COMPILATION ERROR I hosted my site designed in asp.net 2008, and it flags this error: BC30002: Type 'MySqlConnection' is not defined. I have tried but it did not work. Please, how can I solve this problem?
Classic ASP w/ MySQL and ODBC 5.1 - including web.config file
I have been out of the programming game for a bit, as I used to specialize in Classic ASP before ASP.Net became what it is today, let alone C#.
MySQL on line won't allow connection from just one computer
I have a number of computers all successfully connecting to MySQL on-line via GoDaddy. There's one computer which will not connect ie. won't open the MySQLConnection. I have tried these connection strings:
vb6withmysqlonline
i'm vb 6 developer , i need vb6 with mysql server (webserver) connection string .... pls help... error mysql odbc 3.51 driver can't connect to mysql server on 'server name' (10013)
Access Denied
I am trying to connect to MySQL from c# with xampp. I dont know what is wrong with my code that it says: "Authentication to host 'localhost' for user 'root' using method 'mysqlnativepassword' failed with message : Access denied for user 'root'@'localhost' (using password:YES)"
Connection string for embedded mysql.
What is the connection string for connecting to embedded mySQL database.
- Load more posts