Connect to MySQL through https tunnel?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for universal data access
Post Reply
Grolle
Posts: 13
Joined: Tue 15 Apr 2008 12:02

Connect to MySQL through https tunnel?

Post by Grolle » Sat 27 Dec 2014 10:40

Hi,

please could someone give me an example how to build the connection string through an https tunnel with dotConnect Universal in an WPF Application? I cannot find an example for this case. Thanks a lot and best regards ...

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Connect to MySQL through https tunnel?

Post by Pinturiccio » Mon 29 Dec 2014 15:22

dotConnect Universal uses common features of ADO.NET providers and does not use the specific provider features. Since HTTP tunnel is a MySQL-specific feature, it is not supported in dotConnect Universal. If you want to use the HTTP tunnel feature, use dotConnect for MySQL. For more information, please refer to http://www.devart.com/dotconnect/mysql

idem84
Posts: 50
Joined: Thu 04 Apr 2013 19:12

Re: Connect to MySQL through https tunnel?

Post by idem84 » Fri 16 Jan 2015 14:28

Hi!
Then, what is the purpose of the "tunnel.php" file in dotConnect Universal Installation folder?

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Connect to MySQL through https tunnel?

Post by Pinturiccio » Thu 22 Jan 2015 16:17

We are sorry for the misunderstanding. You are right, dotConnect Universal supports HTTP tunnel. dotConnect Universal uses dotConnect for MySQL for connecting to MySQL databases. You can find more detailed information on using HTTP tunnel in the dotConnect for MySQL documentation. For more information, please refer to http://www.devart.com/dotconnect/mysql/ ... tml#tunnel

However, UniConnection does not have the corresponding HTTP tunnel-related properties for setting HttpOptions, and you need to set HttpOptions values via the connection string. Here is the list of HttpOptions properties and corresponding connection string parameters:

Code: Select all

HttpOptions.Base64 - HTTP Base64
HttpOptions.ContentLength - HTTP Content Length
HttpOptions.Host - HTTP Host
HttpOptions.KeepAlive - HTTP Keep Alive
HttpOptions.MaxConnectionAge - HTTP Max Connection Age
HttpOptions.Password - HTTP Password
HttpOptions.Port - HTTP Port
HttpOptions.StrictContentLength - HTTP Strict Content Length
HttpOptions.Url - HTTP Url
HttpOptions.User - HTTP User
For more information about HttpOptions properties, please refer to http://www.devart.com/dotconnect/mysql/ ... rties.html

Post Reply