Devart Forums

Right - using that file now. The error I'm getting is different:

Can't connect to MySQL server on '*****' (10061): Authentication failed.

So the host name seems to be correct, if I change it to anything other than the machine name or localhost, or alter the port I'm back to 'cannot establish HTTP connection'. Just seems it can't connect to MySql at this point. The User and Pass in the connection string should be correct though.

Thanks for that StanislavK - not sure what you mean by using an absolute path to the host in the connection string instead of localhost. Could you give an example?

Edit - I've tried using the machine name in the Host area of the connection string but still receive the same error.

I'm looking at using DotConnect to connect to MySql with HTTP tunneling. Following the documentation I'm using the same parameters (URL, User etc) as I set up in Navicat which connects fine. I get the following from an Exception when calling Open() on the MySqlConnection () : 'Can't connect to MySQL server on 'localhost' (10061): Can't establish HTTP connection.'. Here's the code:

MySqlConnection() sqlConnectionTarget = new MySqlConnection();
sqlConnectionTarget.ConnectionString = "Host=localhost;port=3306;user=xxxx;password=xxxx";
sqlConnectionTarget.Protocol = MySqlProtocol.Http;
sqlConnectionTarget.HttpOptions.Url = @"xxxx/ntunnel_mysql.php";
sqlConnectionTarget.HttpOptions.User = "xxxx";
sqlConnectionTarget.HttpOptions.Password = "xxxx";

I've been over it a few times, referencing the documentation and checking all the values against the connection properties I have set up in Navicat which works every time. Any ideas?