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)]
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.
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?0 votes0 answersKennedy Benjamin6 months ago
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#.0 votes1 answerTom Cullenon May 11, 2017
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:0 votes0 answersJonathan Trahairon Apr 26, 2017
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)0 votes0 answersvenkates kumaron Mar 27, 2017
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)"0 votes1 answerJosielyn Huligangaon Mar 03, 2017
Connection string for embedded mysql.
What is the connection string for connecting to embedded mySQL database.0 votes2 answersGbenga Amusuyion Jan 09, 2017
vb.net 2010: Can't connect to a MySQL DB (64 bit) under Windows 10
Hi there, I'm trying to write a vb.net program (VS 2010) that connects to a MySQL DB (64 bit) under Windows (10). Amongst other attempts these are my recent once:1 vote2 answersWolfgang Scheeron Oct 20, 2016
OPTIONS values for MySQL connection string
Where do I find the various number value options for the OPTIONS clause in the MySQL Connection String? Searching the MySQL site didn't turn up the full listing. Thanks in advance!0 votes1 answerMichael Babcockon Oct 17, 2016
datasource incorrect for MySQl in text unit in c#
I would like to use a database MySQl in a test unit c#. It's ok for xml or a database access but i don't find the good "datasource" for a database MySQL please, help me ! differents tests here :0 votes1 answerSEVERINE QUESQUEon Sep 27, 2016
How to connect MYSQL database from asp file?
I have sample Code like this. Please let me know how to connect Mysql DB from these ASP file. I have installed MySQLODBC driver 5 on my machine. SQL="select fname,lname from Guest" set rs=Conn.Execute(SQL)0 votes3 answersrmp son Sep 24, 2016
- Load more posts